Assign number of happening times

[rx5873]

Hello

I would like to know how to count the number of the event happening times.

Event

basketball

basketball

basketball

football

football

baseball

Result:

Event         NO

basketball  1

basketball  2

basketball  3

football      1

football      2

baseball    1

What data step can make the result like that? Please help, thank you

[novinosrin · Accepted solution]

data have;
 input Event :$12.;
 cards;
basketball

basketball

basketball

football

football

baseball
;

data want;
 set have;
 by Event notsorted;
 if first.Event then no=0;
 no+1;
run;

[PaigeMiller]

data want;
    set have;
    by event notsorted;
    if first.event then no=0;
    no+1;
run;
    

Assumes the data is grouped by event.

[ballardw]

With a subject line involving "happening times" I thought this might be a question about something from the late 1960's!?