Accessing Data Through Libraries Activity

[eleverson]

Perform the following tasks in your SAS software:

• Open a new program window.
  
  
• Write a LIBNAME statement to create a library named NP that reads np_info.xlsx in the course data as follows:
  • SAS Studio: Specify the full path to your EPG194/data folder and the complete file name.
  • Enterprise Guide: Specify &path and the complete file name.
• Run the LIBNAME statement.
  
  
• Navigate to your list of libraries and open the NP library. How many tables are there in the NP library?

^^^ I get an error message that the NP doesn't exist. Plus how do I get the xlsx files? I'm not seeing it after creating the files for the course

[Reeza]

Show the code you ran and the log. Did you get errors or did it run correctly?

[Krueger]

You downloaded the course material (which was in a .zip format) correct?
You then extracted the course material correct?
You then went through the two setup processes which were labeled as REQUIRED in 3 different locations before you accessed this right?

If all the above is true then you just need to do:

libname np xlsx "FILEPATH/np_info.xlsx";

FILEPATH being the FULL directory to np_info.xlsx. You can browse to the file location and right-click on the folder this file is in > properties > highlight location > copy

Edit: If you didn't do any of the above you need to click "Lessons" at the top-left and then under the actual Lessons click on "Course Overview and Data Setup (REQUIRED)SCORM package" and follow the instructions.

[eleverson · Accepted solution]

It is resolved...I was missing "data" in my file path