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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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