How to create a new column that is running total of values of different column

[PranavShelke]

Open p202p04.sas from the practices folder.

2. Complete the PROC SORT step to sort the pg2.np_yearlytraffic table by ParkType and ParkName.

3. In the DATA step, read the sorted table created in PROC SORT.

4. Add a BY statement to group the data by ParkType.

5. Create a column, TypeCount, that is the running total of Count within each value of ParkType.

6. Format TypeCount so that values are displayed with commas.



7. Keep only the ParkType and TypeCount columns in the output table.

I need help in performing 5th step

[Kurt_Bremser · Accepted solution]

You need to RETAIN the new variable.

Since you already have a BY statement, so the automatic first.parktype variable can be used to reset the new variable to zero. Add count.

[PranavShelke]

Thank you Sir for your help.