/* The usual PROC IMPORT commands for Import Wizard may not work in versions of SAS 9.3 or later.  */
/* Here is an example of an import that appears to be more reliable                                */

proc import out=tough
datafile="e:\stat 540\ToughSpreadsheet.xlsx"
dbms=xlsx replace;
sheet="Sheet1";
run;

/* Default code (with a few extra options) provided by the Import Wizard */
PROC IMPORT OUT= WORK.tough 
            DATAFILE= "Z:\STAT 540\ToughSpreadsheet.xlsx" 
            DBMS=EXCEL REPLACE;
     RANGE="Sheet1$"; 
     GETNAMES=YES;
     MIXED=NO;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;