DATA Step, Macro, Functions and more

label duplicate cases in data set

Accepted Solution Solved
Reply
Super Contributor
Posts: 318
Accepted Solution

label duplicate cases in data set

My data set has variables user_id and others like v1, v2, .. v5.

There are some duplicate cases which have the same user_id.

 

is there a way to label the duplicate cases, by adding a new variable, value 1 for the primary cases, and value 0 for the second case with the same user_id? By doing this I do not need to delete the duplicate cases, but when analysis I can select the distinct cases by this new variable.

 

Thanks in advance.


Accepted Solutions
Solution
‎12-21-2015 09:27 PM
Super User
Posts: 5,495

Re: label duplicate cases in data set

Posted in reply to fengyuwuzu

Sort your data if it's not yet in order:

 

proc sort data=have;

by user_id;

run;

 

Then it's simple:

 

data want;

set have;

by user_id;

new_variable = first.user_id;

run;

View solution in original post


All Replies
Solution
‎12-21-2015 09:27 PM
Super User
Posts: 5,495

Re: label duplicate cases in data set

Posted in reply to fengyuwuzu

Sort your data if it's not yet in order:

 

proc sort data=have;

by user_id;

run;

 

Then it's simple:

 

data want;

set have;

by user_id;

new_variable = first.user_id;

run;

Super Contributor
Posts: 318

Re: label duplicate cases in data set

Posted in reply to Astounding

great! this works!

 

This forum is really good.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 261 views
  • 2 likes
  • 2 in conversation