topic Re: SAS Programming 1: Essentials : No data in PG1 library in SAS Studio

SAS Programming 1: Essentials : No data in PG1 library

Hakase102 — Mon, 23 Mar 2020 12:58:15 GMT

Hello,

I'm having some trouble accessing data from the PG1 library for an activity in the SAS Programming 1: Essentials course. Usually when I run the code from the libname.sas program I created it populates the library without issue.

The code I in my libname.sas program is:

libname pg1 "/folders/myfolders/EPG194";

However when I run this what appears to be an empty PG1 library is created as per the below screenshot.

Can anyone tell me what I'm doing wrong here?

Best regards,

Hakase102

Re: SAS Programming 1: Essentials : No data in PG1 library

Quentin — Mon, 23 Mar 2020 13:45:20 GMT

If you browse to that folder, do you see the expected files (data sets), or is it an empty folder? I know for the macro course, there is a program to run to create all the data sets.

Re: SAS Programming 1: Essentials : No data in PG1 library

Cynthia_sas — Mon, 23 Mar 2020 14:24:29 GMT

Hi:

It's always a good idea to search for previous postings with similar questions, like this one: https://communities.sas.com/t5/New-SAS-User/can-t-create-libname-pg1-as-per-sas-programming-essentials-1/td-p/633928 please see the suggestion I made yesterday about NOT going directly to the Libraries pane.

Instead, please go to Server Files and Folders, find the EPG194 folder, find the data sub-folder inside that main folder. Now, right click on the data sub-folder -- in the popup window, choose Properties. When the Properties window pops up, you will see a Location -- THAT location is the full path name for your data folder.

Inside the Programming 1 course, is a section called Course Overview and Data Setup. That section has 5 different sets of instructions for how to run a program to MAKE all the data used in the course. When you go to the EPG194/data folder under Server Files and Folders -- you should see some xlsx and some other files, but there should be over 20 files with the file extension of .sas7bdat -- indicating SAS data sets. If you see a data sub-folder that's good, that usually means you've set up the shared folder location in University Edition correctly. However, if you do NOT see any SAS tables in the folder, then that means you still have to follow the setup instructions. If you DO see SAS tables inside the data sub-folder, then please, right click on the data sub-folder and choose Properties -- usually, on SAS University Edition in a Virtual Machine, the fully qualified path for the data folder in Programming 1 is:

libname pg1 '/folders/myfolders/EPG194/data';

and on SAS OnDemand for Academics:

libname pg1 '/home/<yourUserID>/EPG194/data';

Hope this helps,

Cynthia

Re: SAS Programming 1: Essentials : No data in PG1 library

Hakase102 — Mon, 23 Mar 2020 22:41:13 GMT

Thank you, Cynthia_SAS for the detailed response. That solved the problem.

It looks like the main issues was the fact that I didn't include /data in my command.

I looked around for some solutions but didn't quite hit what I needed. Thank you again for clearly solving this problem. I can now get back to studying. 🙂

Best regards,

Hakase102