topic Re: Accessing Data Through Libraries Activity in SAS Programming

Accessing Data Through Libraries Activity

eleverson — Fri, 22 Nov 2019 21:35:18 GMT

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

Re: Accessing Data Through Libraries Activity

Reeza — Fri, 22 Nov 2019 21:44:19 GMT

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

Re: Accessing Data Through Libraries Activity

Krueger — Fri, 22 Nov 2019 22:18:18 GMT

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.

Re: Accessing Data Through Libraries Activity

eleverson — Sat, 23 Nov 2019 13:38:27 GMT

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