libname hercules 's:\courses\stat-renaes\stat426\data1';

proc print data=hercules.employee_payroll;
run;
proc print data=hercules.employee_addresses;
run;

proc sort data=hercules.employee_payroll
          out=payroll; 
   by Employee_ID;
run;
proc sort data=hercules.employee_addresses
          out=addresses;
   by Employee_ID;
run;

data payadd;
   merge payroll addresses;
   by Employee_ID;
run;
proc print data=payadd;
   format Birth_Date weekdate. Salary dollar10.;
run;