Open a new program window in SAS Studio. Write a LIBNAME statement to create a library named PG1 that reads SAS tables in the EPG1V2/data folder. If you are not sure of the path to your data folder, right-click the data folder in the navigation pane and select Properties. You can copy the path shown there. Run the code. After the code runs, you should see a note in the log that the library was successfully assigned. Select the Code tab. Save your program as libname.sas in the course folder. You can replace the file if it already exists. Select Libraries in the navigation pane and expand My Libraries. Expand the PG1 library and view the list of SAS tables. After I created the code for PG1 library and run it on SAS Studio, it said  Library PG1 does not exist. And I am not sure if this is the correct respond that everyone get, and because of this mistake I cannot be successful at the following activities as well. And my code is libname pg1 base "FILEPATH/EPG1V2/data". Thank you. ... View more

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. ... View more