BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ashotts
Calcite | Level 5

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
Obsidian | Level 7

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
Fluorite | Level 6

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"

 

SAS121_1-1675379292707.png

 

 

 

sas-innovate-2024.png

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.

 

Register now!

5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats