/****************
Set SAS Options
****************/
OPTIONS mprint ps=55 ls=100 ERROR=1;
Libname cc 'c:\Data\SASData\Indata';
Libname cbos 'c:\Data\SASData\Outdata';
Libname wb 'c:\Data\Raw';
/**************************************************
Use the Proc Import Command to read in xls file into SAS
Create Permanent SAS data file: cbos.data94.sd2
**************************************************/
PROC IMPORT OUT=cbos.data94
DATAFILE=»C:\Data\SASData\Raw\data94.xls»
DBMS=EXCEL2000 REPLACE;
GETNAMES=YES;
RUN;