Cumulative Counter Variable

[collegestudent2]

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;

[mkeintz]

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.

[BrianB4233]

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;