Problem import xls file with special sheet's name

[Mike_Davis]

Hello everyone,

I have a problem import .xls file to SAS when the sheet's name including " - " (Minus sign with blanks),please advise.

Thanks!

Mike

PROC IMPORT

OUT= one

DATAFILE= "c:\abc.xls"

DBMS=EXCEL REPLACE;

SHEET="north - east"; /*if I remove the blanks before and after the minus sign that will be ok(sheet="north-east")*/

GETNAMES=YES;

MIXED=YES;

USEDATE=YES;

SCANTIME=YES;

RUN;

[Reeza]

Put a $ after the name, ie "north - east$"

[Mike_Davis]

This works,Thank you Reeza!

and would you please explain the meaning of $ here?

Thank you!

[Reeza]

Has to do with name literals and telling SAS how to read a name with spaces in it.

If you want to see what you should call the sheet I usually run access my excel workbook via a libname statement,

ie libname myxlfile excel 'C:\abc.xls';

Check the abc library in the explorer now and you can see how to reference your worksheets.