topic Re: How to create an enumeration variable within one datastep? in SAS Procedures

How to create an enumeration variable within one datastep?

rx5873 — Fri, 30 Oct 2020 16:34:35 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? It need to output in one data step. Please help. Thanks!

Re: How to create an enumeration variable within one datastep?

novinosrin — Fri, 30 Oct 2020 16:38:44 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: How to create an enumeration variable within one datastep?

Reeza — Fri, 30 Oct 2020 16:39:46 GMT

https://stats.idre.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/

@rx5873 wrote:

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? It need to output in one data step. Please help. Thanks!

Re: How to create an enumeration variable within one datastep?

rx5873 — Fri, 30 Oct 2020 16:41:58 GMT

it use the proc function which more than one data step.

Re: How to create an enumeration variable within one datastep?

rx5873 — Fri, 30 Oct 2020 16:44:56 GMT

I need to show the result in one data step. It cannot open another data want; and use the by function

Re: How to create an enumeration variable within one datastep?

novinosrin — Fri, 30 Oct 2020 16:59:32 GMT

Are you trying to mean that you do not want to create a "new" dataset named want and would rather update the existing dataset? If yes, you could just recreate "have"


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

Re: How to create an enumeration variable within one datastep?

Reeza — Fri, 30 Oct 2020 17:02:23 GMT

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