data record duplication

[hangtinching]

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???

[sbb]

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.

[sbb]

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