Desktop productivity for business analysts and programmers

How to import an excel file with worksheet name starting with number

Accepted Solution Solved
Reply
Contributor
Posts: 29
Accepted Solution

How to import an excel file with worksheet name starting with number

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


Accepted Solutions
Solution
‎11-06-2013 04:00 PM
Super User
Posts: 19,194

Re: How to import an excel file with worksheet name starting with number

The sheet parameter is usually quoted, and you have to give it a valid SAS name. 

View solution in original post


All Replies
Solution
‎11-06-2013 04:00 PM
Super User
Posts: 19,194

Re: How to import an excel file with worksheet name starting with number

The sheet parameter is usually quoted, and you have to give it a valid SAS name. 

Contributor
Posts: 29

Re: How to import an excel file with worksheet name starting with number

Reeza, Thank you!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 206 views
  • 0 likes
  • 2 in conversation