Sample SAS Training 1

---

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? 

---

Fill out my online form.