Hi:
With BASE SAS, you will not be able to use the LIBNAME Excel engine, but you should be able to read a CSV file with this syntax:
[pre]
PROC IMPORT OUT= WORK.???
DATAFILE= "??????.csv"
DBMS=CSV REPLACE;
RUN;
proc print data=work.???;
run;
[/pre]
If you do have SAS/Access for PC File Formats, then, depending on your version of SAS, you should be able to use either of these models:
[pre]
PROC IMPORT OUT= WORK.???
DATAFILE= "??????.xls"
DBMS=EXCEL REPLACE;
SHEET="???";
RUN;
proc print data=work.???;
run;
** OR;
libname myxls excel '??????????';
data work.???;
set myxls.?????;
run;
proc print data=work.???;
run;
[/pre]
This paper has some good LIBNAME engine examples:
http://www2.sas.com/proceedings/sugi31/024-31.pdf
and the documentation has some good background info:
http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#/documentation/cdl...
cynthia