topic Problem import xls file with special sheet's name in SAS Procedures

Problem import xls file with special sheet's name

Mike_Davis — Thu, 14 Jun 2012 18:47:21 GMT

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 — Thu, 14 Jun 2012 19:06:09 GMT

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

Mike_Davis — Thu, 14 Jun 2012 21:30:09 GMT

This works,Thank you Reeza!

and would you please explain the meaning of $ here?

Thank you!

Reeza — Thu, 14 Jun 2012 22:09:30 GMT

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.