topic Re: Needing Assistance with p103a02.sas Activity in SAS Software for Learning Community

Needing Assistance with p103a02.sas Activity

ivarenho — Mon, 23 Mar 2026 20:29:47 GMT

Hello,

I'm trying to complete activity 3 and below is the first error I get.

Re: Needing Assistance with p103a02.sas Activity

Tom — Mon, 23 Mar 2026 20:40:19 GMT

Make sure to follow the setup steps for the course you are taking.

It looks like you skipped the set where you created the libref of PG1 to point to the directory where the dataset STORM_SUMMARY summary was stored.

The syntax should look like

libname pg1 "the actual path goes here";

Note that SAS stores datasets in files with the extension of sas7bdat. So if you cannot find the actual instructions then look for a file named storm_summary.sas7bdat (notice that the filename uses lowercase letters only) and use the path of the directory where you found the file.

Re: Needing Assistance with p103a02.sas Activity

ivarenho — Tue, 24 Mar 2026 00:27:55 GMT

You're right, I didn't connect it to the storm summary date set please see below. I appreciate your help.

Re: Needing Assistance with p103a02.sas Activity

Tom — Tue, 24 Mar 2026 00:55:39 GMT

So your latest picture is showing that you were able to define the libref MYLIB.

I cannot tell from your picture if that folder has the storm_summary dataset in it or not since I do not see any folder named EGPV12 in the range of your camera.

But note that your first program tried to use the libref of PG1 and not the libref of MYLIB. So to get them to work together pick only one name for your library and stick with it in your code.

Re: Needing Assistance with p103a02.sas Activity

ivarenho — Tue, 24 Mar 2026 13:46:59 GMT

I want to link the storm data summary to the library and set it up properly. I went back and reviewed last night and I didn't understand where in the steps of the required set up of lesson 2 that I was supposed to incorporate the storm data summary. How should I address this issue?

Re: Needing Assistance with p103a02.sas Activity

ivarenho — Tue, 24 Mar 2026 13:47:23 GMT

I also need to know what images would be the most helpful for you to be able to assist :).

Re: Needing Assistance with p103a02.sas Activity

Rachel_McLawhon — Tue, 24 Mar 2026 13:54:03 GMT

You're on the right track, @ivarenho! Your libname statement to make the storm data available to SAS should be:

libname pg1 "S:/workshop/EPG1V2/data";

This will put all the SAS datasets that are stored in your EPG1V2 > data folder into a library, which can then be read during the p103a02 activity. Let me know if this doesn't work!

Re: Needing Assistance with p103a02.sas Activity

ivarenho — Tue, 24 Mar 2026 15:44:38 GMT

The activity says to run each line and it will return results for each WHERE statement. For example, the first, based on what it states it should return rows that only having missing min pressure but this table has rows with min pressures that are not missing.

Re: Needing Assistance with p103a02.sas Activity

Rachel_McLawhon — Tue, 24 Mar 2026 17:59:34 GMT

In your code, all the WHERE statements are commented out - meaning that SAS is ignoring them. Removing the asterisk (*) from the front of the first WHERE statement will indicate to SAS that the statement should be included in the run and the filtering will occur. Taking a look at color coding can be very helpful to identify when code has been commented out!

Re: Needing Assistance with p103a02.sas Activity

ivarenho — Sun, 29 Mar 2026 22:42:43 GMT

How do I fix the library so that I don't have to run that piece of code
every time I want to access the library for practice?

Re: Needing Assistance with p103a02.sas Activity

ivarenho — Sun, 29 Mar 2026 22:46:26 GMT

Do I just save it in a tab so I don't have to keep running it every time I need to access the same data via the library, every time I need it for practice?

Re: Needing Assistance with p103a02.sas Activity

Tom — Mon, 30 Mar 2026 02:43:41 GMT

You could add the LIBNAME statement to your autoexec.sas file.

Re: Needing Assistance with p103a02.sas Activity

ivarenho — Mon, 30 Mar 2026 15:35:43 GMT

That is a good suggestion and I have attached my attempt to do so with the code and the log. In the mean time, I'm going to go back and review the library set because it is clear that I did not set it up properly. Any feedback would be greatly appreciated.

Re: Needing Assistance with p103a02.sas Activity

Rachel_McLawhon — Mon, 30 Mar 2026 16:34:40 GMT

Hello - looks like you changed your libname statement from what worked previously:

libname pg1 "S:/workshop/EPG1V2/data";

To access the Autoexec file, which is automatically run every time your start your SAS Studio session, go to the More application options in the upper toolbar > click Edit Autoexec file > paste the above code > Save.

Re: Needing Assistance with p103a02.sas Activity

ivarenho — Mon, 30 Mar 2026 20:00:17 GMT

Thank you!