topic Re: adding id variable in SAS Procedures

adding id variable

sasphd — Tue, 11 Nov 2014 15:42:37 GMT

I have this table

A B

10 0.1

22 0.1

22 0.2

31 0.2

31 0.3

I want to add ID

A B ID

10 0.1 1

22 0.1 2

22 0.2 2

31 0.2 3

31 0.3 3

Re: adding id variable

stat_sas — Tue, 11 Nov 2014 15:46:13 GMT

data want;

set have;

by a;

if first.a then id+1;

run;

Re: adding id variable

sasphd — Tue, 11 Nov 2014 15:49:42 GMT

I can not do that because A is not properly sorted???????????????

adding id variable

Re: adding id variable

stat_sas — Tue, 11 Nov 2014 15:53:06 GMT

What is the criteria to create id then?

Re: adding id variable

RW9 — Tue, 11 Nov 2014 15:57:03 GMT

Then sort the data. If you need original sorting then do:

data have;

set a;

prev_sort=_n_;

run;

proc sort data=have;

by a b;

run;

data want;

set have;

by a;

if first.a then id+1;

run;

proc sort data=want;

by prev_sort;

run;

However, if your test data is right (and after this sort statement I am not sure), just say:

data want;

set have;

do I=1 to 100;

if (i *10) < a <= ((I+1) * 10) then id=I;

end;

run;

Re: adding id variable

sasphd — Tue, 11 Nov 2014 15:59:09 GMT

the criteria is that A must be the same for the id=1.