Question

Basic SAS coding

2. Use the SAS datasets empdata and raisel to calculate each employee's new salary. Employees are to receive a 3% raise or the amount specified in dataset rasel, İ.e. the amount of raise is the amount specified in the dataset raise! or 3% if not specified. Prepare a report which (a) is sorted by LastName, FirstName, NewSalary (b) displays only LastName, FirstName, NewSalary (c) suppresses the observations column (d) uses labels 'Last Name', First Name', 'New Salary (e) uses a dollar format for NewSalary

Answer 1

a. is sorted by LastName, FirstName, NewSalary
(Note Employee is the name of the dataset)
PROC SORT DATA = Employee OUT = Sorted_dept_sal ;
BY LastName FirstName NewSalary;
RUN ;

PROC PRINT DATA = Sorted_dept_sal;
RUN ;

b. displays only LastName, FirstName, NewSalary
PROC PRINT DATA = Sorted_dept_sal;
var LastName FirstName NewSalary;
RUN ;

c. Suppresses the observations column
PROC PRINT DATA = Sorted_dept_sal NOOBS;
var LastName FirstName NewSalary;
RUN ;

d. Uses labels 'Last Name', 'First Name', New Salary
DATA = Sorted_dept_sal;
LABEL   LastName = "Last Name"
   FirstName = "FirstName"
   NewSalary = "New Salary"
PROC PRINT DATA = Sorted_dept_sal label NOOBS;
var LastName FirstName NewSalary;
RUN ;

e. uses a dollar format for NewSalary
DATA = Sorted_dept_sal;
LABEL   LastName = "Last Name"
   FirstName = "FirstName"
   NewSalary = "New Salary"
PROC PRINT DATA = Sorted_dept_sal label NOOBS;
var LastName FirstName NewSalary;
format NewSalary dolloar26.;
RUN ;