DATA Step, Macro, Functions and more

How to remove duplicate detail table entries? cpedit and cpdupchk?

Reply
N/A
Posts: 0

How to remove duplicate detail table entries? cpedit and cpdupchk?

I have a case open with HP regarding the 'extract' command which does *not* extract only yesterday's configuration data as documented:

extract -xp D-1 -c -f /tmp/yesterday_only.txt
does not export yesterday's configuration data only.

This has resulted in many duplicate configuration records in one of our ITRM tables.

Could someone please provide some sample code, using cpedit and cpdupchk perhaps, showing how to remove these duplicate records by DATETIME?
Super Contributor
Super Contributor
Posts: 3,174

Re: How to remove duplicate detail table entries? cpedit and cpdupchk?

Posted in reply to deleted_user
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 http://support.sas.com/ to locate the SAS tech note with the details on the problem/solution.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/documentation/onlinedoc/itsv/
Ask a Question
Discussion stats
  • 1 reply
  • 130 views
  • 0 likes
  • 2 in conversation