https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/768031#M71 <P><SPAN>Which of the <FONT size="7"><STRONG>5</STRONG></FONT> steps poses an unsurmountable obstacle to you?</SPAN></P> Thu, 16 Sep 2021 06:57:17 GMT Kurt_Bremser 2021-09-16T06:57:17Z https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/745383#M68 Create the np sort table contains data for national parks. You want the data sorted by regional code and decreasing numbers of daily visitors.<BR /><BR />1.Open p103p08. sas from the practices folder.<BR /><BR />2. Modify the Proc Sort Step to read pg1.np_summary and create a temporary, sort table named np_sort.<BR /><BR />3. Add a BY statement to order the data by Reg descending DayVisits values.<BR /><BR />4. Add a WHERE statement to select Type equal to NP.<BR /><BR />5. Submit the program and view the output data.<BR /><BR />How many rows are in the np sort table? Fri, 04 Jun 2021 08:28:28 GMT https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/745383#M68 Christina_j920 2021-06-04T08:28:28Z https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/745418#M69 Which of the 5 steps poses an unsurmountable obstacle to you? Thu, 03 Jun 2021 09:50:28 GMT https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/745418#M69 Kurt_Bremser 2021-06-03T09:50:28Z https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/768030#M70 <DIV class="rc-FormPartsQuestion__numberCell">&nbsp;</DIV><DIV class="rc-FormPartsQuestion__numberCell">&nbsp;</DIV><DIV class="rc-FormPartsQuestion__contentCell"><DIV class="rc-CML displayInlineBlock show-soft-breaks"><DIV><P>Create the <STRONG>np sort&nbsp;</STRONG>table that contains data for national parks. You want the data sorted by regional code and decreasing numbers of daily visitors.</P></DIV></DIV></DIV><P>&nbsp;</P> Thu, 16 Sep 2021 06:50:53 GMT https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/768030#M70 sahaj 2021-09-16T06:50:53Z https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/768031#M71 <P><SPAN>Which of the <FONT size="7"><STRONG>5</STRONG></FONT> steps poses an unsurmountable obstacle to you?</SPAN></P> Thu, 16 Sep 2021 06:57:17 GMT https://communities.sas.com/t5/SAS-Training-Courses/Week-3-level-1-practice-Sorting-data-and-creating-an-output/m-p/768031#M71 Kurt_Bremser 2021-09-16T06:57:17Z