This is what I do:
PROC IMPORT OUT= outdataset DATAFILE= "&pathfile" DBMS=&ext REPLACE; SHEET="&sheet"; GETNAMES=no; RUN;
&ext would be xls or xlsx.
This will bring in all the columns (as text) that have data and name them A, B, C, D,...
You can then rename and convert them as you please. You can even use the names in the 1st row, if that's where they are.
Here's an example of how to convert Excel date into SAS date:
input(Date_Received,best10.)-21916 as Received_Dt format date9.,
And a currency amount:
input(Provider_Billed_Amount,dollar12.2) as Provider_Billed_Amt format dollar12.2,
... View more
