topic Generating an accumulating column from Data Manipulation 9.4 practice=p202p04.sas in New SAS User

Generating an accumulating column from Data Manipulation 9.4 practice=p202p04.sas

heatherml20 — Thu, 05 Jun 2025 14:16:28 GMT

*Hi, This is the lesson and there are two solutions below. In the first solution please let me know if you need .... count+1? both solutions are the same without it. If it is included, what is the reasoning. Thank you!! ********************************************************;
* LESSON 2, PRACTICE 1 *;
* a) Open the PG2.NP_YEARLYTRAFFIC table. Notice the *;
* Count column records the number of cars that have *;
* passed through a particular Location. *;
* b) Modify the DATA step to create a column, totTraffic,*;
* that is the running total of Count. *;
* b) Keep the ParkName, Location, Count, and *;
* totTraffic columns in the output table. *;
* c) Format totTraffic so values are displayed with *;
* commas. *;
***********************************************************;

data totalTraffic ;
set pg2.np_yearlyTraffic;
Count+1; *Running Total of Count */;
retain totTraffic 0;
totTraffic+Count;
format totTraffic comma12.;
keep ParkName Location Count totTraffic;
run;

/*OR*/

data totalTraffic;
set pg2.np_yearlytraffic;
totTraffic+Count;
keep ParkName Location Count totTraffic;
format totTraffic comma12.;
run;

Re: Generating an accumulating column from Data Manipulation 9.4 practice=p202p04.sas

LinusH — Thu, 05 Jun 2025 14:42:51 GMT

Depends on the source table.

Second example relies on a count column in the source, the first doesn't.

Re: Generating an accumulating column from Data Manipulation 9.4 practice=p202p04.sas

Cynthia_sas — Thu, 05 Jun 2025 16:25:47 GMT

Hi:

You might want to go back and revisit the lectures on the RETAIN statement and the SUM statement. In this code (I changed the output data table names with 1 and 2), You can see that the only difference is the RETAIN statement. The fact that Example 2 works the same as Example 1 tells you something about how the SUM statement works.

Notice that the lecture on the SUM statement explains that the SUM statement does an automatic RETAIN.

Thus, the RETAIN statement in the first example is not necessary for purposes of having the program work. On the other hand, using a RETAIN statement, even with a SUM statement makes it clearer that totTraffic is the variable being accumulated and retained.

Understanding when you need to use RETAIN and when it's not absolutely required is one of the objectives for this practice. However, you can break the SUM statement like this:

Learning when to use the RETAIN statement and how the SUM statement works is one of the goals of this Lesson.

Cynthia

Re: Generating an accumulating column from Data Manipulation 9.4 practice=p202p04.sas

heatherml20 — Fri, 06 Jun 2025 13:12:12 GMT

Hi Cynthia,

My question was this: do I need the Count+1 in Example 1. You took it out so I assume we don't need it. I am referring to my Example 1:
data totalTraffic ;
set pg2.np_yearlyTraffic;
Count+1;
retain totTraffic 0;
totTraffic+Count;
format totTraffic comma12.;
keep ParkName Location Count totTraffic;
run;

Re: Generating an accumulating column from Data Manipulation 9.4 practice=p202p04.sas

Cynthia_sas — Fri, 06 Jun 2025 14:31:30 GMT

Hi:
Reread the instructions for the practice again and then run a PROC CONTENTS on the pg2.np_yearlyTraffic data table. In the instructions, there is a sentence that says "Notice that the Count column records the number of cars that have passed through a particular location." So, you need to use the COUNT column from the starting data to create totTraffic in this instance. In a different scenario, you might create your own variable, but it is not necessary in this case.
Cynthia