topic Re: Assign number of happening times in SAS Procedures

Assign number of happening times

rx5873 — Fri, 30 Oct 2020 14:56:47 GMT

Hello

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

Event

basketball

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

Re: Assign number of happening times

novinosrin — Fri, 30 Oct 2020 14:59:23 GMT

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;

Re: Assign number of happening times

PaigeMiller — Fri, 30 Oct 2020 14:59:42 GMT

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

Assumes the data is grouped by event.

Re: Assign number of happening times

ballardw — Fri, 30 Oct 2020 17:51:37 GMT

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