BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Jcorti
Obsidian | Level 7

Hi Team,

 

I found a code to get only duplicates using proc sort.

 

But I need to get the duplicates with more variables ..example var1, var2, var3, var4 ..

 

Somebody how to do it??

 

Thanks,

 

 

proc sort
     data = test;
     by var1;
run;


data single dup;
     set test;
     by var1;
     if first.var1 and last.var1 
          then output single;
     else output dup;
run;
1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User
proc sort
     data = test  out=want  nouniquekey  ;
     by var1 var2 var3 var4;
run;

View solution in original post

4 REPLIES 4
ballardw
Super User

You need to define what you mean by duplicate? Preferably provide some example data and an indication of which you consider duplicates.

 

 

Astounding
PROC Star

A small variation on your program ought to do the trick:

 

proc sort
     data = test;
     by var1 var2 var3 var4;
run;

data single dup;
     set test;
     by var1 var2 var3 var4;
     if first.var4 and last.var4 
          then output single;
     else output dup;
run;

 

 

If this doesn't do it, you might need to answer some of the questions already asked, like the meaning of a duplicate.

Ksharp
Super User
proc sort
     data = test  out=want  nouniquekey  ;
     by var1 var2 var3 var4;
run;

Jcorti
Obsidian | Level 7

Thanks for your solution

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 21100 views
  • 2 likes
  • 4 in conversation