Question: 2. Generating an Accumulating Column within Groups The pg2.np_yearlyTraffic table contains annual traffic counts at locations in national parks. Park names are grouped into park

 2. Generating an Accumulating Column within Groups The pg2.np_yearlyTraffic table contains

2. Generating an Accumulating Column within Groups The pg2.np_yearlyTraffic table contains annual traffic counts at locations in national parks. Park names are grouped into park types. a. Open the p202p04.sas program in the practices folder. Complete the PROC SORT step to sort the pg2.np_yearlyTraffic table by ParkType and ParkName. b. Modify the DATA step as follows: c. Read the sorted table created in PROC SORT. d. Add a BY statement to group the data by ParkType. e. Create a column, TypeCount, that is the running total of Count within each value of ParkType. f. Format TypeCount so that values are displayed with commas. g. Keep only the ParkType and TypeCount columns. h. Run the program and confirm that TypeCount is reset at the beginning of each ParkType group. i. Modify the program to write only the last row for each ParkType to the output table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!