topic Re: enumeration variable by group in SAS Programming

enumeration variable by group

ari — Wed, 17 Aug 2016 12:15:25 GMT

Have:

id	v1	v2	v3	v4	v5
1	0	0.1	1	1	0.1
1	0		2	0	0.1
1	5		2	0	0.1
1	10		2	0	0.1
1	15		2	0	0.1
1	20		2	0	0.1
1	25		2	0	0.1
1	30		2	0	0.1
1	0	0.1	1	1	0.2
1	0		2	0	0.2
1	5		2	0	0.2
1	10		2	0	0.2
1	15		2	0	0.2
1	20		2	0	0.2
1	25		2	0	0.2
1	30		2	0	0.2

want:

id	v1	v2	v3	v4	v5	count
1	0	0.1	1	1	0.1	1
1	0		2	0	0.1	1
1	5		2	0	0.1	1
1	10		2	0	0.1	1
1	15		2	0	0.1	1
1	20		2	0	0.1	1
1	25		2	0	0.1	1
1	30		2	0	0.1	1
1	0	0.1	1	1	0.2	2
1	0		2	0	0.2	2
1	5		2	0	0.2	2
1	10		2	0	0.2	2
1	15		2	0	0.2	2
1	20		2	0	0.2	2
1	25		2	0	0.2	2
1	30		2	0	0.2	2

I am trying to get an enumeration variable (count) which indicates number of different v5 groups by ID.

Please help me to derive count variable.

Thanks

Re: enumeration variable by group

Reeza — Wed, 17 Aug 2016 12:31:06 GMT

You need clear rules on where to restart/increment your counts. Based on sample data this could work, but it depends on how closely it matxhes your real data.

Data want;

set have;

by id v1;

Retain count 0;

if v1=0 and v2=0.1 then count+1;

run;

Re: enumeration variable by group

RW9 — Wed, 17 Aug 2016 12:30:02 GMT

Hi,

data want;
  set have;
  by id;
  retain count;
  if _n_=1 then count=0;
  if first.id then count=count+1;
run;

Re: enumeration variable by group

ari — Wed, 17 Aug 2016 12:37:43 GMT

HI RW9,

this code gives the enumeration for the id but doesnt give the enumeration for the variable 'V5'

Re: enumeration variable by group

Kurt_Bremser — Wed, 17 Aug 2016 12:40:57 GMT

proc sort data=have;
by id v5;
run;
/* just to be sure */

data want;
set have;
by id v5;
retain count;
if first.id then count = 0;
if first.v5 then count + 1;
run;

Re: enumeration variable by group

ari — Wed, 17 Aug 2016 12:59:05 GMT

Thanks Kurt.

Re: enumeration variable by group

ari — Wed, 17 Aug 2016 12:59:27 GMT

Thanks RW9

Re: enumeration variable by group

ari — Wed, 17 Aug 2016 12:59:58 GMT

Thanks Reeza

id	v1	v2	v3	v4	v5
1	0	0.1	1	1	0.1
1	0		2	0	0.1
1	5		2	0	0.1
1	10		2	0	0.1
1	15		2	0	0.1
1	20		2	0	0.1
1	25		2	0	0.1
1	30		2	0	0.1
1	0	0.1	1	1	0.2
1	0		2	0	0.2
1	5		2	0	0.2
1	10		2	0	0.2
1	15		2	0	0.2
1	20		2	0	0.2
1	25		2	0	0.2
1	30		2	0	0.2

id	v1	v2	v3	v4	v5
1	0	0.1	1	1	0.1
1	0		2	0	0.1
1	5		2	0	0.1
1	10		2	0	0.1
1	15		2	0	0.1
1	20		2	0	0.1
1	25		2	0	0.1
1	30		2	0	0.1
1	0	0.1	1	1	0.2
1	0		2	0	0.2
1	5		2	0	0.2
1	10		2	0	0.2
1	15		2	0	0.2
1	20		2	0	0.2
1	25		2	0	0.2
1	30		2	0	0.2

id	v1	v2	v3	v4	v5
1	0	0.1	1	1	0.1
1	0		2	0	0.1
1	5		2	0	0.1
1	10		2	0	0.1
1	15		2	0	0.1
1	20		2	0	0.1
1	25		2	0	0.1
1	30		2	0	0.1
1	0	0.1	1	1	0.2
1	0		2	0	0.2
1	5		2	0	0.2
1	10		2	0	0.2
1	15		2	0	0.2
1	20		2	0	0.2
1	25		2	0	0.2
1	30		2	0	0.2