This scenario uses the
Cert.Staff data set. Write a SAS program to do the following:
-
Create a new temporary SAS data
set that uses Cert.Staff and store the results in Work.StaffReports.
-
Select observations where WageCategory
is not equal to H.
-
Format the variable DOB as mmddyy10.
-
Create a new variable named Raise
whose value is WageRate multiplied by 3%.
-
Determine the grand total of Raise
for the entire data set.