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;