Help using Base SAS procedures

Problem import xls file with special sheet's name

Reply
Regular Contributor
Posts: 222

Problem import xls file with special sheet's name

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;

Super User
Posts: 18,549

Re: Problem import xls file with special sheet's name

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

Regular Contributor
Posts: 222

Re: Problem import xls file with special sheet's name

This works,Thank you Reeza!

and would you please explain the meaning of $ here?

Thank you!

Super User
Posts: 18,549

Re: Problem import xls file with special sheet's name

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.

Ask a Question
Discussion stats
  • 3 replies
  • 710 views
  • 3 likes
  • 2 in conversation