06-14-2012 02:47 PM
I have a problem import .xls file to SAS when the sheet's name including " - " (Minus sign with blanks),please advise.
SHEET="north - east"; /*if I remove the blanks before and after the minus sign that will be ok(sheet="north-east")*/
06-14-2012 06:09 PM
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.