/**********************************************************
   THIS FILE SHOWS HOW TO READ AN EXCEL FILE INTO SAS

   FILENAME: IMPORT_EXCEL.SAS
***********************************************************/
 OPTIONS FORMCHAR="|----|+|---+=|-/\<>*";
 TITLE;
 OPTIONS PAGENO=1;

PROC IMPORT OUT= WORK.EMPLOYEE 
            DATAFILE= "EMPLOYEE.XLS" 
            DBMS=EXCEL REPLACE;
     RANGE="EMPLOYEE$"; 
     GETNAMES=YES;
     MIXED=NO;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;
 
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;

proc means data=employee2;
run;