![TaeYi_0-1600052416117.png](/skins/images/29ECD7D4BA1D11CF872D70A0DBE7250A/responsive_peak/images/image_not_found.png)
![TaeYi_0-1600053730483.png](/skins/images/29ECD7D4BA1D11CF872D70A0DBE7250A/responsive_peak/images/image_not_found.png)
![TaeYi_1-1600053765303.png](/skins/images/29ECD7D4BA1D11CF872D70A0DBE7250A/responsive_peak/images/image_not_found.png)
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;