topic Re: Enumeration by group in SAS Procedures

Enumeration by group

LB — Tue, 23 Apr 2013 19:37:45 GMT

Hi all;

I am trying to enumerate a group with a counter-

So for example if I have data that looks like this-

FAC YEAR

A 2008

A 2009

A 2010

B 2008

B 2009

B 2010

What I want is

FAC YEAR CT

A 2008 1

A 2009 1

A 2010 1

B 2008 2

B 2009 2

B 2010 2

The code I have currently is:

DATA plots2;

CT+1;

SET plots;

BY FAC_ID;

IF FIRST.FAC_ID THEN CT=1;

RUN;

Which gives me:

FAC YEAR CT

A 2008 1

A 2009 2

A 2010 3

B 2008 1

B 2009 2

B 2010 3

Which is not what I want. Any help appreciated. I have attempted to use lag & retain functions, much to the same effect.

Thanks

Lawrence

Re: Enumeration by group

PGStats — Tue, 23 Apr 2013 19:47:56 GMT

You were almost there...

DATA plots2;

SET plots;

BY FAC_ID;

IF FIRST.FAC_ID THEN CT+1;

RUN;

or simpler still

DATA plots2;

SET plots;

BY FAC_ID;

CT + FIRST.FAC_ID;

RUN;

Re: Enumeration by group

LB — Tue, 23 Apr 2013 19:55:11 GMT

Many Thanks PG!

Lawrence

Re: Enumeration by group

Haikuo — Wed, 24 Apr 2013 03:06:35 GMT

If using DOW:

DATA plots2;

do until (last.fac_id);

SET plots;

BY FAC_ID;

CT=_n_;

output;

end;

RUN;

Haikuo

Re: Enumeration by group

Ksharp — Wed, 24 Apr 2013 05:37:25 GMT

Or lag function.

IF FAC_ID ne lag(FAC_ID ) THEN CT+1;

Ksharp

Re: Enumeration by group

LB — Wed, 24 Apr 2013 17:10:03 GMT

Thanks everyone. I knew I was close but this helped !

Lawrence