Solved: Re: How to import an excel file with worksheet name starting with numb... - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

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

Posted 11-06-2013 03:59 PM (902 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

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

Posted 11-06-2013 04:00 PM (1005 views) | In reply to Rish

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

View solution in original post

2 REPLIES 2

Super User

Super User

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

Posted 11-06-2013 04:00 PM (1006 views) | In reply to Rish

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

Calcite | Level 5

Calcite | Level 5

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

Posted 11-06-2013 04:04 PM (830 views) | In reply to Reeza

Reeza, Thank you!