https://communities.sas.com/t5/New-SAS-User/How-to-create-a-new-column-that-is-running-total-of-values-of/m-p/844265#M36678 Thank you Sir for your help. Tue, 15 Nov 2022 04:14:12 GMT PranavShelke 2022-11-15T04:14:12Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-new-column-that-is-running-total-of-values-of/m-p/844015#M36654 Open p202p04.sas from the practices folder.<BR /><BR />2. Complete the PROC SORT step to sort the pg2.np_yearlytraffic table by ParkType and ParkName.<BR /><BR />3. In the DATA step, read the sorted table created in PROC SORT.<BR /><BR />4. Add a BY statement to group the data by ParkType.<BR /><BR />5. Create a column, TypeCount, that is the running total of Count within each value of ParkType.<BR /><BR />6. Format TypeCount so that values are displayed with commas.<BR /><BR /><BR /><BR />7. Keep only the ParkType and TypeCount columns in the output table.<BR /><BR />I need help in performing 5th step Sun, 13 Nov 2022 17:55:07 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-new-column-that-is-running-total-of-values-of/m-p/844015#M36654 PranavShelke 2022-11-13T17:55:07Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-new-column-that-is-running-total-of-values-of/m-p/844017#M36655 <P>You need to RETAIN the new variable.</P> <P>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.</P> Sun, 13 Nov 2022 18:51:48 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-new-column-that-is-running-total-of-values-of/m-p/844017#M36655 Kurt_Bremser 2022-11-13T18:51:48Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-new-column-that-is-running-total-of-values-of/m-p/844265#M36678 Thank you Sir for your help. Tue, 15 Nov 2022 04:14:12 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-new-column-that-is-running-total-of-values-of/m-p/844265#M36678 PranavShelke 2022-11-15T04:14:12Z