Not Able to Create Library XLSTORM in Libraries

[chamgrl007]

Hello,

I am following Demo Step p102d02.sas, to create libref in libraries named XLSTORM. Its there but no tables?

*Complete the OPTIONS statement;
options validvarname=v7;

*Complete the LIBNAME statement;
libname xlstorm xlsx "EPG194/data/storm.xlsx";

[heffo · Accepted solution]

The libname in that demo has a macro variable path that should point to something useful. When you don't have anything like C: or // or \\ in the beginning of the path of the library, SAS will assume that you want it in the default path. 

The default path differs with what product you are using. But most likely SAS will look in the wrong place for your file. 

So, find the file and use that folder path. 

NB! Make sure that the SAS server can see that path. So, if you run SAS on the server, then SAS will not see your local disk. So, do not use C: or similar if the server is not on the same computer. 

[chamgrl007]

All that time, I thought I was using full path, but wasn't. I did this instead /"folders/myfolders/EPG194/data/storm_summary";

Thank you for your help

[Reeza]

So excel files can be tricky because the libname will always exist. This is because a libname in this case can be used to either read data or write data. So if the file doesn't exist, SAS thinks that you want to create it and it assigns the library. If the file is supposed to exist and this isn't part of the lesson you're supposed to follow along with then my guess is you didn't quite do the set up correctly. Has any other data sets not worked in the courses? Did you follow the setup instructions exactly when setting up the data and those have worked so far?

---

@chamgrl007 wrote:

Hello,

I am following Demo Step p102d02.sas, to create libref in libraries named XLSTORM. Its there but no tables?

*Complete the OPTIONS statement;
options validvarname=v7;

*Complete the LIBNAME statement;
libname xlstorm xlsx "EPG194/data/storm.xlsx";

---

[chamgrl007]

All that time, I thought I was using the full path, /EPG194/data. But I wasn't, so I corrected with this instead. "/folders/myfolders/EPG194/data/storm_summary";

Thank you for your help.