libname hercules 's:\courses\stat-renaes\stat404';

* Using SORT;

proc sort data=hercules.sales
          out=sortsales;
	by Gender descending Employee_ID;
run;

proc print data=hercules.sales; 
   var Gender Employee_ID First_Name Last_Name Salary;
run;

proc print data=sortsales; 
   var Gender Employee_ID First_Name Last_Name Salary;
run;

* Using SORT then MERGE;

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;
   var Employee_ID Employee_Name Birth_Date Salary;
   format Birth_Date weekdate. Salary dollar10.;
run;