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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.