topic Labeling duplicate values in SAS Programming

Labeling duplicate values

richart — Wed, 05 Dec 2018 00:03:16 GMT

Hi there, I have the following data:

1 1

2 1

3 1

4 1

5 1

6 2

7 2

8 1

9 1

10 3

11 3

12 3

13 4

14 4

15 4

16 4

etc

where column 1 is userid and column 2 is whether it is unique or not (thus, users 13-16 are duplicates, 10-12 are duplicates, and 6 and 7 are duplicates. I need an output variable labeling each user as a unique value, so something like this:

1 1 1

2 1 2

3 1 3

4 1 4

5 1 5

6 2 6

7 2 6

8 1 7

9 1 8

10 3 9

11 3 9

12 3 9

13 4 10

14 4 10

15 4 10

16 4 10

Thanks!

Re: Labeling duplicate values

Tom — Wed, 05 Dec 2018 00:14:18 GMT

That is a strange structure. Also what are the NAMES of those variables?

data want ;
  set have ;
  by var2 notsorted ;
  var3 + (first.var2 or var2=1);
run;

Re: Labeling duplicate values

richart — Wed, 05 Dec 2018 00:24:56 GMT

I agree it's strange, why I needed to find a way out of it. And you have provided just that! Cheers!