topic Cumulative Counter Variable in SAS Programming

Cumulative Counter Variable

collegestudent2 — Mon, 29 Nov 2021 22:33:32 GMT

I am trying to create a cumulative counter variable that tracks the total number games. The code I have been using can be found below. I am not sure how to word it so that the TotalGames column adds 1 for each new game, sorted by date. That way that the count is totaled based on the dates the games were played.

PROC SORT data = NewRoseBowl;
by Date;
RUN;

Data CountRoseBowl;
set NewRoseBowl;
TotalGames + 1;
by Date;
if first.date then TotalGames = 1;
PROC PRINT;
Format Date WEEKDATE30.;
RUN;

Re: Cumulative Counter Variable

mkeintz — Tue, 30 Nov 2021 02:07:20 GMT

Do you want the total number of games for each date?

If so, why not run a PROC FREQ on the DATE variable?

No need for sorting, or a data step.

Re: Cumulative Counter Variable

BrianB4233 — Tue, 30 Nov 2021 06:06:15 GMT

It looks like you need to add the name of the variable that indicates what the game is, as in:

proc sort;
by game_type date;
run;

data CountRoseBowl;
set NewRoseBowl;
by game_type date;

/* set up counter */
if first.date then game_cnt = 1;
else game_cnt + 1;

/* output last record by GAME_TYPE to get total sum */
if last.game_type;
run;