Question about Accessing Data-Activity- reading excel data

[ashotts]

Hey guys,

I was having the same problem. The libname code would create an empty library with nothing in it. The problem was that the path was incorrect. The correct code was:

libname np xlsx "/folders/myfolders/coursefiles/EPG1V2/data/np_info.xlsx";

I was accidentally setting the path to "/folder/.." when it should have been folders. Thanks to whoever mentioned double checking your path name by right clicking the file and selecting properties. Hope this helps someone else out there.

[Negarev]

Hi All,

Update on this: turned out that the course files for SAS EG did not contain any data at all. I downloaded the one for SAS studio, and this one does have the Excel files I was looking for. Thanks for your help, I thought I was going mad...

[SAS121 · Accepted solution]

Hi everyone, this is an update in 2023, as I came across this post by Googling the same problem. I am using SAS OnDemand for Academics and had a "coursefiles" folder that was separate from the "pg1v2setup_oda" folder, both of which I downloaded when installing SAS EPG1V2.

I was able to find the "Storm_Summary" worksheet located in the "storm.xlsx" workbook by going to "coursefiles > EPG1V2 > data folder > storm.xlsx"