topic Re: Create unique id based on two variables in SAS Programming

Create unique id based on two variables

di_niu0 — Thu, 29 Apr 2021 18:41:53 GMT

Hello All,

As shown above, I'm trying to assign unique id based on var1 and var2. Not sure how to do it.

var1 var2 id

1 1 1

1 3 2

2 1 3

2 2 4

Thank you!

PeterClemmensen — Thu, 29 Apr 2021 19:01:49 GMT

Try this


data have;
input var1 var2;
datalines;
1 1 
1 1 
1 3 
2 1 
2 1 
2 2 
;

data want;
   set have;
   by var1 var2;
   if first.var2 then id + 1;
run;

di_niu0 — Thu, 29 Apr 2021 19:06:23 GMT

Thank you very much!!!!!!!!

PeterClemmensen — Thu, 29 Apr 2021 19:10:33 GMT

Anytime, glad to help.