topic Question about Level 1 Practice: Sorting Data and Creating an Output Table in SAS Training Courses

Question about Level 1 Practice: Sorting Data and Creating an Output Table

zhangrachel0118 — Fri, 17 Nov 2023 21:14:56 GMT

Create the np_sort table that contains data for national parks. You want the data sorted by regional code and decreasing numbers of daily visitors. If necessary,start SAS before you begin.

Reminder: If you restarted your SAS session, you must open and submit the libname.sas program created in Activity 2.04 to access your course files.

Open p103p08.sas from the practices folder.
Modify the PROC SORT step to read pg1.np_summary and create a temporary, sorted table named np_sort.
Add a BY statement to order the data by Reg and descending DayVisits values.
Add a WHERE statement to select Type equal to NP.
Submit the program and view the output data.

How many rows are in the np_sort table?

I cannot get the right answer for this question, and I am not sure if I am incorrect with the activity 2.04 or the coding for np_sort, and the error said that File WORK.NP_SUMMARY.DATA does not exist and Library PG1 does not exist.

Re: Question about Level 1 Practice: Sorting Data and Creating an Output Table

Tom — Fri, 17 Nov 2023 23:17:50 GMT

Read the REMINDER in what you just posted.

Did you run the libname.sas program? Did it work? If so it should have created the PG1 libref where you could find the input dataset.

Re: Question about Level 1 Practice: Sorting Data and Creating an Output Table

Cynthia_sas — Sat, 18 Nov 2023 02:12:39 GMT

Hi:
I just posted some examples of how to construct the LIBNAME statement in your other post asking about the LIBNAME statement activity.
Cynthia