I am currently using the below code to import a worksheet from an excel workbook. Unable to import where the worksheet name begins with a number. Proc IMPORT OUT= Test1 DATAFILE= "/sas/data_20131101_130401.xls" DBMS=xls REPLACE; sheet = 7061_newdata; GETNAMES=YES; MIXED=YES; run; Please advise. Thanks Raj
The sheet parameter is usually quoted, and you have to give it a valid SAS name.
The sheet parameter is usually quoted, and you have to give it a valid SAS name.
Reeza, Thank you!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.