/*****************************************************************************************************************

SAS file name: NodupvsNodupkey
File location: 
_________________________________________________________________________________________________________________

Purpose: To demonstrate the difference between the two options Nodupkey and Nodup in SAS PROC SORT
Author: Peter Clemmensen
Creation Date: 18/01/2019

This program supports the example page "The Difference Between NodupKey and NoDup in PROC SORT" on SASnrd.com

*****************************************************************************************************************/

/* Example data */
data MyData;
input ID var;
datalines;
1 10
1 20
1 10
2 30
2 30
2 40
3 50
;

/* Nodupkey option */
proc sort data=MyData out=sort_nodupkey nodupkey;
   by ID;
run;

proc print data=sort_nodupkey;
run;

/* Nodup option */
proc sort data=MyData out=sort_noduprec noduprec;
   by ID;
run;

proc print data=sort_noduprec;
run;