My sincere thanks to all who responded to my query. This is such an amazing community, so quick to help. I chose this solution among the many because it opened my eyes to the power of SQL. Thanks to all, Gene
... View more
Try this: PROC IMPORT OUT=CA_2011
DATAFILE="\\Pathway\CA_2011.xlsx"
DBMS=xlsx REPLACE;
GETNAMES=YES;
RANGE = "Sheet1$A1:G3000";
GUESSINGROWS=3000;
RUN;
Replace Sheet1 with the name of your Excel sheet and the range with your values.
... View more
