Sentry Page Protection
SAS Functions [1-14]
Mathematical Operators
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.
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.
Need some help?
HINT:
You must create a new variable that contains the salary information based on the equation provided.
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.