https://communities.sas.com/t5/SAS-Programming/data-record-duplication/m-p/38691#M7803 i have a data set <BR /> contains about 5000 records<BR /> and 250 or more columns<BR /> <BR /> <BR /> <BR /> how can i check the duplication records or find out all smiler record??? Sun, 10 Jan 2010 18:17:34 GMT hangtinching 2010-01-10T18:17:34Z https://communities.sas.com/t5/SAS-Programming/data-record-duplication/m-p/38691#M7803 i have a data set <BR /> contains about 5000 records<BR /> and 250 or more columns<BR /> <BR /> <BR /> <BR /> how can i check the duplication records or find out all smiler record??? Sun, 10 Jan 2010 18:17:34 GMT https://communities.sas.com/t5/SAS-Programming/data-record-duplication/m-p/38691#M7803 hangtinching 2010-01-10T18:17:34Z https://communities.sas.com/t5/SAS-Programming/data-record-duplication/m-p/38692#M7804 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sun, 10 Jan 2010 18:45:06 GMT https://communities.sas.com/t5/SAS-Programming/data-record-duplication/m-p/38692#M7804 sbb 2010-01-10T18:45:06Z https://communities.sas.com/t5/SAS-Programming/data-record-duplication/m-p/38693#M7805 Correction: the option is DUPOUT, not DUPSOUT. <BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument to consider using:<BR /> <BR /> proc sort dupout site:sas.com Sun, 10 Jan 2010 18:46:09 GMT https://communities.sas.com/t5/SAS-Programming/data-record-duplication/m-p/38693#M7805 sbb 2010-01-10T18:46:09Z