Remove duplicate records from Dataset. Expecting suggestions for the code below.

LokeshDake — Thu, 30 Jun 2022 07:53:18 GMT

/*ReplacedSASDatasetLibNameWithWork */

/*proc append base=&libn2..ctlencstclaimackdtl data=ctlenstclaimackdtl; */

data ctlencstclaimacdtl;

run;

%append dup_check(srctbl)=ctlencstclaimackdtl, srclib=work,

trgttbl =ctlencstclaimackdtl, trgtlib=&libn2., key=rowid);

/* SAS2AWS2: WritrdatatoRedshift - Remove Duplicates */

proc sort data = ctlencstclaimackdtl ----------------------------

-------------------------

------------------------

run;

can anyone help to fill the sort code for that.

Re: Remove duplicate records from Dataset. Expecting suggestions for the code below.

Kurt_Bremser — Thu, 30 Jun 2022 09:16:51 GMT

Look here (Maxim 1): PROC SORT Statement

You will easily find the option which deals with duplicates.