DATA Step, Macro, Functions and more

creating a data set that contains duplicate records

Accepted Solution Solved
Reply
Regular Contributor
Posts: 216
Accepted Solution

creating a data set that contains duplicate records

Hi

If you have an existing data set, is there a way to create a new data set from this one that only contains records from the original that are duplicates based on a specific variable?

Paul


Accepted Solutions
Solution
‎04-16-2013 08:33 AM
Super User
Posts: 5,424

Re: creating a data set that contains duplicate records

proc sort dupout=...

Data never sleeps

View solution in original post


All Replies
Solution
‎04-16-2013 08:33 AM
Super User
Posts: 5,424

Re: creating a data set that contains duplicate records

proc sort dupout=...

Data never sleeps
Regular Contributor
Posts: 216

Re: creating a data set that contains duplicate records

Thanks Linus and Sanjeev.

Paul

Super Contributor
Posts: 276

Re: creating a data set that contains duplicate records

Hi..

Why Not??

You can use Dupout in Proc Sort to get duplicates into a separate dataset with out disturbing original dataset.. .

Regards..

Sanjeev.K

🔒 This topic is solved and locked.

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

Discussion stats
  • 3 replies
  • 206 views
  • 3 likes
  • 3 in conversation