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

SAS file name: sort_options2
File location: 
_________________________________________________________________________________________________________________

Purpose: To demonstrate the 3 PROC SORT Options Details, Noequals and Nouniquekey options in SAS
Author: Peter Clemmensen
Creation Date: 18/11/2017

This program supports the example page "Three Other PROC SORT Options You Should Know" on SASnrd.com

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

/* Set relevant options */
options fullstimer msglevel=i threads cpucount=4;

/* Create example data */
data MyData(drop=i);
   do i=1 to 5e7;
      ID=rand('integer', 1, 1e4);
      val=rand('integer', 1, 1e5);
      output;
   end;
run;

/* Details Option */
proc sort data=MyData details;
   by ID;
run;

/* Noequals Option */
proc sort data=MyData noequals;
   by ID;
run;

proc sort data=MyData equals;
   by ID;
run;

/* Nounique option */
Data MyData;
input ID $ var;
datalines;
1 10
1 20
3 10
3 20
3 10
2 30
run;

proc sort data=MyData nouniquekey;
   by ID;
run;