topic Re: Recreate PG1 library by libname.sas in Programming 1 and 2

Recreate PG1 library by libname.sas

arbresel — Tue, 15 Jan 2019 12:46:13 GMT

Hello,

I am a SAS beginner and self learninig with SAS Programming 1: Essentials training with SAS Studio on line.

I am blocked when I restart SAS Studio, for exemple in lesson 3 : Exploring and Validating Data

My question is that I don't understand how to excute libname.sas to recreate the PG1 library once I restart SAS studio ?

Here is the remander:

Reminder: If you restarted your SAS session,you must recreate the PG1 library so you can access your practice files. In SAS Studio, open and submit the libname.sas program in the EPG194 folder.

Righe click the folder EPG04, then I open a new program (or F4) and execute libname.sas in code, and run, but it doesn't work...

Thanks for your help

Re: Recreate PG1 library by libname.sas

PremS — Tue, 15 Jan 2019 13:33:39 GMT

LIBNAME.SAS was a program with code you wrote in Lesson 2: Accessing Data Through Libraries. The program should have a LIBNAME statement as written below:

libname pg1 "FILEPATH";

Just replace the text FILEPATH with the location of the EPG194/data folder. It might be called something different on your SAS Studio. If you right click the data folder and click Properties (picture below), then you can see the Location and copy it into your LIBNAME statement.

I am guessing you did that activity but did not save the program as LIBNAME.SAS, so nothing's wrong at all! Let me know if this works.

Re: Recreate PG1 library by libname.sas

Panagiotis — Wed, 16 Jan 2019 14:53:19 GMT

Hi @arbresel, did the response answer your question?

Re: Recreate PG1 library by libname.sas

arbresel — Wed, 16 Jan 2019 18:10:05 GMT

Many thanks, the pg1 is recreated 🙂

Re: Recreate PG1 library by libname.sas

arbresel — Wed, 16 Jan 2019 18:10:51 GMT

Yes 🙂

Re: Recreate PG1 library by libname.sas

Panagiotis — Wed, 16 Jan 2019 18:21:34 GMT

Great! If you can, can you mark this as solved?

Re: Recreate PG1 library by libname.sas

SAM9 — Wed, 21 Aug 2019 08:37:18 GMT

HI I tried your suggestion but am still getting this error message

WARNING: "Libref EPG1 is not assigned"

Re: Recreate PG1 library by libname.sas

Panagiotis — Wed, 21 Aug 2019 12:18:20 GMT

Out of curiosity, are you using SAS University Edition or SAS On Demand for Academics? Or a local version of SAS?

You need to find the location of the data folder, confirm that there are tables in that location, then copy the file location. You will use that in a LIBNAME statement to tell SAS where to look for all the data.

For example. My data is in my S:\workshop\data folder. In that location I have 25 SAS tables. I need to tell SAS where the tables are.

LIBNAME pg1 "S:\workshop\data";

If there are not tables in that location you will need to create the data for the course. You can do that by checking out these videos: https://communities.sas.com/t5/Programming-1-and-2/bd-p/course_discussions

Let me know if that works.

- Peter

Re: Recreate PG1 library by libname.sas

abdis — Wed, 29 Jan 2020 18:24:13 GMT

I have a related question. I am using SAS studio. I logged out and when I began a new session, I recreated the library using my saved libname program. When I run the program, it does create the PG 1 library. However the PG1 library folder is empty - no tables. I am directing the libname statement to my EPG 194 folder within SAS studio where I do see many tables. Why is the library empty? Here is my syntax:

LIBNAME pg1 "/home/u44988922/EPG194";

Re: Recreate PG1 library by libname.sas

Panagiotis — Wed, 29 Jan 2020 18:32:29 GMT

Looks like you are using SAS On Demand for Academics?

Physically go to the folder you pointed to with your LIBNAME statement. You should see that there are folders in that location but no actual SAS data sets. You need to go into the data subfolder.

Go into that data folder through the Server Files and Folders pane. You should see data in it. If you do, you set it up correctly and need to tell SAS 'Go to that data folder, I have data there I want to use'. You can right click on the data folder, select properties and see the location.

To tell SAS you want to use the data in that location make sure to use the LIBNAME statement to point to it. You need to most likely add data to the end of your path:

libname pg1 '/home/u44988922/EPG194/data';

Re: Recreate PG1 library by libname.sas

abdis — Wed, 29 Jan 2020 19:30:57 GMT

That did the trick - thank you! I will mark as resolved.

Re: Recreate PG1 library by libname.sas

Panagiotis — Wed, 29 Jan 2020 19:31:38 GMT

Glad it worked!

Re: Recreate PG1 library by libname.sas

abdis — Wed, 29 Jan 2020 19:35:04 GMT

Well, I don't see an option to mark this solution - perhaps because the thread already is marked as solved. At any rate, thank you for your help!

Re: Recreate PG1 library by libname.sas

Panagiotis — Wed, 29 Jan 2020 19:38:40 GMT

Yeah i'm guessing that's why. No worries, glad you everything is working!

Re: Recreate PG1 library by libname.sas

asta1 — Mon, 06 Jul 2020 03:04:44 GMT

im unable to create a library

it is showing

ERROR: Library PG1 is not in a valid format for access method RANDOM.

ERROR: Error in the LIBNAME statement.;

Re: Recreate PG1 library by libname.sas

Cynthia_sas — Tue, 07 Jul 2020 18:48:05 GMT

Hi:
How are you running your programs: SAS University Edition in a Virtual Machine, SAS OnDemand for Academics or SAS through your work or school license?

Typically, if you have followed the setup instructions, and if you're using SAS Studio, you can right click on the EPG1V2 folder and select Properties and you'll find the correct full path to use in the Location field of the Properties Windows.

Videos for how to do the setup for each method of using SAS can be found here: https://communities.sas.com/t5/SAS-Communities-Library/Creating-Data-for-Programming-1-and-Programming-2/ta-p/494541 Inside the article you'll find a button to get to the EPG1V2 instructions (and if you're taking an earlier version of Programming 1, there is also a button to get to the recordings for the older EPG194 version of the course).

Most useful when posting questions like this is showing us the actual code you submitted and a screen shot of your log message. Saying that you're unable to create a library indicates that you are farther along in the course, past the setup section and in this case, it is also useful to know what Lesson you're working in (Lesson 1, Lesson 2, etc) and what activity or practice within the lesson.
Hope the videos in the article help you figure things out.
Cynthia

Re: Recreate PG1 library by libname.sas

jnbaene — Wed, 22 Jul 2020 17:24:07 GMT

Hello, I have a related question. I am using SAS studio. I logged out and when I began a new session, I recreated the library using my saved libname program. When I run the program, it does create the PG 1 library. However the PG1 library folder is empty - no tables. I am directing the libname statement to my EPG1V2/Data folder within SAS studio where I do see many tables. Why is the library empty? Here is my syntax:

libname pg1 "/folders/myfolders/coursefiles/EPG1V2/data";

Re: Recreate PG1 library by libname.sas

Cynthia_sas — Wed, 22 Jul 2020 19:55:05 GMT

Hi:

This is NOT the path we recommend:

For SAS University Edition, we recommend that you make your EPG1V2 folder directly under the My Folders top node, in which case, the correct path would be:

libname pg1 "/folders/myfolders/EPG1V2/data";

However, the way to find the correct path is to start with the Server Files and Folders pane (not the Libraries pane). Then, in Server Files and Folders, navigate to the EPG1V2 folder and expand it. Then navigate to the data subfolder. Do you see files inside? Some of the files will have .xlsx, .csv and .dat file extensions. Other files will have .sas7bdat extensions. If you see all of these file types in the data subfolder, then right-click on the data subfolder and choose Properties.

The Properties popup window will have a location field. THAT will be the correct location for you to use in your LIBNAME statement.

When you ran the data setup programs for the class, did you see the PROC CONTENTS results at the end of the successful completion of the programs? If so, the top of the PROC CONTENTS also showed you the correct path to use. You can use your path with "coursefiles" in the name, if that is the actual folder structure you have and the folder structure you used when you created the class files.

If you do NOT see any sas7bdat file extensions in your data folder, that implies that something went wrong with your data creation program. Go back to the course setup instructions and re-run the programs again. Be sure you use the correct folder name for the location of your data for class.

You will ONLY see SAS datasets in the Libraries window AFTER you are successful at running the data creation program in class. Did you watch the videos that were referenced in my earlier posting?

Cynthia

Re: Recreate PG1 library by libname.sas

dgreenberg — Sun, 01 Nov 2020 19:34:11 GMT

I was having the same problem using the SAS University Edition. When the course directed me to set up the PG1 library it did not require me to specify the data subfolder. Once I went back in and added that it worked like a charm. Thank you for this!

Re: Recreate PG1 library by libname.sas

dolphen_2020 — Mon, 23 Nov 2020 04:27:08 GMT

Hello, I'm in lesson 3 level 1 practice: exploring data with procedures 

/* list first 20 rows */
proc print data=pg1.np_summary (obs=20);
  var Reg Type Park Name DayVistis Tent Campers RVCampers;
  run;

when i run this statement

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 /* list first 20 rows */

74 proc print data=pg1.np_summary (obs=20);

ERROR: Libref PG1 is not assigned.

75 var Reg Type Park Name DayVistis Tent Campers RVCampers;

76 run;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 216.93k

OS Memory 30116.00k

Timestamp 11/23/2020 04:24:54 AM

Step Count 66 Switch Count 0

Page Faults 0

Page Reclaims 31

Page Swaps 0

Voluntary Context Switches 0

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 0

79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

can someone help me