topic Re: Location for data file for Lesson 3 / Level 1 Practice in SAS Programming

Location for data file for Lesson 3 / Level 1 Practice

OmniDIYer — Mon, 22 Oct 2018 14:58:35 GMT

Hi: I'm coming back to SAS after 20 years away. I'm working through SAS® Programming 1: Essentials.

I'm currently stuck on Lesson 3's Level 1 Practice. Specifically, the first sentence reads:

"The pg1.np_summary table contains public use statistics from the National Park Service"

There's no "np_summary" table in the pg1 library (which we created in Lesson 2. I went back and worked through Lesson 2 to be sure I hadn't missed a step--I hadn't).

I found the file in the following location: /home/myuserid/EPG194/data/np_summary.sas7bdat

The course hasn't yet dealt with moving data tables from folders to libraries. Not sure how to proceed.

Thanks, Sandra

Re: Location for data file for Lesson 3 / Level 1 Practice

FreelanceReinh — Mon, 22 Oct 2018 16:15:30 GMT

Hi @OmniDIYer and welcome to the SAS Support Communities!

So, you're coming from SAS 6.12? Great. I liked that version.

There is no need for "moving data tables." Simply use a LIBNAME statement:

libname pg1 (pg1 '/home/myuserid/EPG194/data');

This creates a concatenated library which consists of the existing pg1 library and the folder where np_summary.sas7bdat resides.

Thus you can refer to this dataset as pg1.np_summary and still access the datasets in the "old" pg1 library as before. When you create a new dataset in this library, it is created in the folder which was previously alone associated with libref pg1, i.e., there's no change in this regard either.