PROC IMPORT OUT= employees DATAFILE= "" DBMS=xlsx REPLACE; GETNAMES=YES; RUN; PROC PRINT DATA= employees; RUN; PROC TABULATE DATA= employees; CLASS position; TABLE position ALL; RUN; DATA employees; SET employees; IF endDate =. THEN endDate = TODAY(); RUN; DATA truckers; SET employees; IF JOB ne 'Truck Driver' THEN DELETE; RUN; DATA truckers; SET employees; yearsOfService=INT(YRDIF(hireDate,endDate)); RUN; PROC PRINT DATA=truckers; RUN; ODS EXCEL FILE="" OPTIONS(sheet_interval='table'); PROC FREQ DATA=truckers; TABLE yearsOfService; RUN; ODS EXCEL CLOSE;
... View more