https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicate-detail-table-entries-cpedit-and-cpdupchk/m-p/69875#M15136 Appears the macro used may be version-specific, possibly %CPDUPCHK or %RMDUPCHK. Have a look at the DOC reference below. Also, I noticed a HOTFIX also mentioned - suggest using SEARCH on SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> to locate the SAS tech note with the details on the problem/solution.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <A href="http://support.sas.com/documentation/onlinedoc/itsv/" target="_blank">http://support.sas.com/documentation/onlinedoc/itsv/</A> Sun, 18 Jan 2009 00:01:00 GMT sbb 2009-01-18T00:01:00Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicate-detail-table-entries-cpedit-and-cpdupchk/m-p/69874#M15135 I have a case open with HP regarding the 'extract' command which does *not* extract only yesterday's configuration data as documented:<BR /> <BR /> extract -xp D-1 -c -f /tmp/yesterday_only.txt<BR /> does not export yesterday's configuration data only.<BR /> <BR /> This has resulted in many duplicate configuration records in one of our ITRM tables.<BR /> <BR /> Could someone please provide some sample code, using cpedit and cpdupchk perhaps, showing how to remove these duplicate records by DATETIME? Sat, 17 Jan 2009 22:33:20 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicate-detail-table-entries-cpedit-and-cpdupchk/m-p/69874#M15135 deleted_user 2009-01-17T22:33:20Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicate-detail-table-entries-cpedit-and-cpdupchk/m-p/69875#M15136 Appears the macro used may be version-specific, possibly %CPDUPCHK or %RMDUPCHK. Have a look at the DOC reference below. Also, I noticed a HOTFIX also mentioned - suggest using SEARCH on SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> to locate the SAS tech note with the details on the problem/solution.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <A href="http://support.sas.com/documentation/onlinedoc/itsv/" target="_blank">http://support.sas.com/documentation/onlinedoc/itsv/</A> Sun, 18 Jan 2009 00:01:00 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicate-detail-table-entries-cpedit-and-cpdupchk/m-p/69875#M15136 sbb 2009-01-18T00:01:00Z