SAS Functions [1-14]

Mathematical Operators

Var3 = Var1 + Var2;
Var3 = Var1 - Var2;
Var3 = Var1 * Var2;
Var3 = Var1 / Var2;

Let's start with something simple.

Below is the NUMBERS data set.

It contains 2 variables: VAL1 and VAL2. 

Note: the yellow box below contains the code for the NUMBERS data set.

Copy and run the code to get the NUMBERS data set on SAS Studio.

To add, subtract, multiply and divide values in SAS, you can use the following mathematical operators:

Add & Subtract

Data Math1;
    Set Numbers;
    val3 = val1 + val2;
    val4 = val1 - val2;
Run;

Multiplication & Division

Data Math2;
    Set Numbers;
    val3 = val1 * val2;
    val4 = val1 / val2;
Run;

Exercise

Copy and run the ACCOUNTING data set from the yellow box below. 

ACCOUNTING contains 4 variables:

EmployeeID: ID
Base: Base Salary
OTHours: Overtime Hours
Rate: Overtime Rate

Employee's salary is calculated as Base Salary + (Overtime Hours x Overtime Rate)

Write a SAS program to calculate the salary for each employee. Create any data set or variables if necessary.