SAS Import & Export (for older Excel version)

PROC EXPORT DATA= sashelp.Verbmgr OUTFILE= "C:\temp\example.xls"
DBMS=EXCEL2000 REPLACE;
RUN;

PROC IMPORT OUT= exceldata
DATAFILE= "C:\temp\example.xls"
DBMS=EXCEL2000 REPLACE;
GETNAMES=YES;
RUN;

Leave a Reply