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;
Put a $ after the name, ie "north - east$"
This works,Thank you Reeza!
and would you please explain the meaning of $ here?
Thank you!
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.