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

[LokeshDake]

/*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.

[Kurt_Bremser · Accepted solution]

Look here (Maxim 1): PROC SORT Statement 

You will easily find the option which deals with duplicates.