Please Complete SAS Programming $2$

$4.$ Generating an Accumulating Column within Groups

The pg$2.$np$\_$yearlyTraffic table contains annual traffic counts at locations in national parks.

Park names are grouped into park types.

a$.$ Open the p$202$p$04.$sas program in the practices folder. Complete the PROC SORT step to

sort the pg$2.$np$\_$yearlyTraffic table by ParkType and ParkName.

b$.$ Modify the DATA step as follows:

$1)$ Read the sorted table created in PROC SORT.

$2)$ Add a BY statement to group the data by ParkType.

$3)$ Create a column, TypeCount, that is the running total of Count within each value of

ParkType.

$4)$ Format TypeCount so that values are displayed with commas.

$5)$ Keep only the ParkType and TypeCount columns.

c$.$ Run the program and confirm that TypeCount is reset at the beginning of each

ParkType

group.

d$.$ Modify the program to write only the last row for each ParkType to the output table.

proc sort data$=$pg$2.$np$\_$yearlyTraffic

out$=$sortedTraffic$($keep$=$ParkType ParkName

Location Count$)$;

$*$Insert BY statement;

run;

data TypeTraffic;

set ;

run;