SAS Functions [1-14]
(Samples)

---

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.

Data Numbers; Input Val1 Val2; Datalines; 1 26 4 49 17 45 13 32 11 22 34 43 25 25 0 43 19 23 23 33 ; Run;

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. 

Data Accounting; Input EmployeeID $ Base OTHours Rate; Datalines; ID0001 6300 4 40 ID0002 4500 8 35 ID0003 8800 5 45 ID0004 8900 4 60 ID0005 5600 3 55 ID0006 6000 9 45 ID0007 7600 2 35 ; Run;

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.

Next

---

Need some help? 

Get Hint

HINT:
You must create a new variable that contains the salary information based on the equation provided.

Get Solution

SOLUTION:
Data EmpSalary;
Set Accounting;
Salary = Base + OTHours*Rate;
Run;

Note: The data set we created is called EMPSALARY. You do not need to follow our data set naming convention. You can name your data set any way you want. Same for the variable SALARY.

---

Fill out my online form.