DATA Step, Macro, Functions and more

data record duplication

Reply
N/A
Posts: 1

data record duplication

i have a data set
contains about 5000 records
and 250 or more columns



how can i check the duplication records or find out all smiler record???
Super Contributor
Super Contributor
Posts: 3,174

Re: data record duplication

Investigate using PROC SORT options DUPSOUT - do remember that your BY variable list must be granular enough to generate "adjacent" duplicate records though, otherwise you may not see your duplicates removed.

Scott Barry
SBBWorks, Inc.
Super Contributor
Super Contributor
Posts: 3,174

Re: data record duplication

Correction: the option is DUPOUT, not DUPSOUT.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument to consider using:

proc sort dupout site:sas.com
Ask a Question
Discussion stats
  • 2 replies
  • 118 views
  • 0 likes
  • 2 in conversation