Week 3 level 1 practice : Sorting data and creating an output table

[Christina_j920]

Create the np sort table contains data for national parks. You want the data sorted by regional code and decreasing numbers of daily visitors.

1.Open p103p08. sas from the practices folder.

2. Modify the Proc Sort Step to read pg1.np_summary and create a temporary, sort table named np_sort.

3. Add a BY statement to order the data by Reg descending DayVisits values.

4. Add a WHERE statement to select Type equal to NP.

5. Submit the program and view the output data.

How many rows are in the np sort table?

[Kurt_Bremser]

Which of the 5 steps poses an unsurmountable obstacle to you?

[sahaj]

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.

[Kurt_Bremser]

Which of the 5 steps poses an unsurmountable obstacle to you?