/* Here are examples of import code that are reliable and streamlined                */

*Excel .xls workbook;
proc import out=tough
datafile="e:\stat 540\ToughSpreadsheet.xls"
replace;
sheet="Sheet1";
run;

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

*Tab-delimited text file;
proc import out=tough
datafile="e:\stat 540\ToughSpreadsheet.txt"
replace;
run;