/*Import the Data*/
PROC IMPORT OUT= WORK.EMPLOYEE 
            DATAFILE= "C:\labdata\EMPLOYEE.XLS" 
            DBMS=EXCEL REPLACE;
     RANGE="EMPLOYEE$"; 
     GETNAMES=YES;
     MIXED=NO;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;

/*Modify the data to create new variables*/

data employee2;
  set employee;
  saldiff = salary-salbegin;
  if 0<= educ < 12 then edcat = 1;
  if educ = 12 then edcat = 2;
  if educ > 12 then edcat = 3;
run;

/*Get descriptive statistics for numeric variables*/
proc means data=employee2;
run;