
PROCLIB.PAYROLL
This data set (table) is updated in “Example 3: Updating Data in a PROC SQL Table” in
Chapter 7 of SAS SQL Procedure User's Guide, and its updated data is used in
subsequent examples.
data proclib.payroll;
input IdNumber $4. +3 Gender $1. +4 Jobcode $3. +9 Salary 5.
+2 Birth date7. +2 Hired date7.;
informat birth date7. hired date7.;
format birth date7. hired date7.;
datalines;
1919 M TA2 34376 12SEP60 04JUN87
1653 F ME2 35108 15OCT64 09AUG90
1400 M ME1 29769 05NOV67 16OCT90
1350 F FA3 32886 31AUG65 29JUL90
1401 M TA3 38822 13DEC50 17NOV85
1499 M ME3 43025 26APR54 07JUN80
1101 M SCP 18723 06JUN62 01OCT90
1333 M PT2 88606 30MAR61 10FEB81 ...