10-10-2016 12:59 PM
Hello. I am working through the SAS Base Class and am trying to assign a library to an excel document.
When I execute the code as directed in the tutorial, everything works swimmingly.
libname orionx pcfiles path="&path/Sales.xls";
Then, I tried to apply it to my own data. The code runs without error. When I open the library, I see Sheet1$, Sheet2$ and Sheet3$.
But there is not data in any of the sets. Also, I receive an error that the table Lx."Sheet1$"n either does not exist or cannot be displayed. None of the tables have any observations. Any ideas?
2009 libname lx pcfiles path="&path/TryingItOut.xlsx";
NOTE: Libref LX was successfully assigned as follows:
Physical Name: H:\UserData\Desktop\ecprg193\TryingItOut.xlsx
10-10-2016 01:18 PM
10-10-2016 02:15 PM
So the odd thing is that if I name the range, it works. Also, It appears that I can reference the datasets in the sheet, I just cannot view them.
10-10-2016 02:22 PM