Needing Assistance with p103a02.sas Activity

[ivarenho]

Hello,

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

 

[Tom]

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.

[ivarenho]

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

[Tom]

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.

[ivarenho]

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?

[ivarenho]

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

[Rachel_McLawhon · Accepted solution]

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!

[ivarenho]

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. 

[Rachel_McLawhon]

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!

[ivarenho]

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?

[Tom]

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

[ivarenho]

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.

[Rachel_McLawhon]

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.

[ivarenho]

Thank you!

[ivarenho]

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?