Sunday, November 11, 2012

Convert .xls or .xlsx file to .sas file

proc import datafile = "C:\Filename.xls"
out=temp.Filename dbms = xls replace;
run;

Convert .csv file to .sas file

proc import datafile = "C:\Filename.csv"
out=temp.Filename dbms = csv replace;
run;