only need those clamnum which are not repeating

[aanan1417]

data have;

input clamnum  sno;

datalines;

900001 1

900001  2

900002  3

900003  4

900003  5

900008  6

;

run;

data want;

input clamnum  sno;

datalines;

900002  3

900008  6

;

run;

[andreas_lds · Accepted solution]

Not tested:

proc sort data=have out=sorted;
  by clamnum;
run;

data want;
  set sorted;
  by clamnum;

  if first.clamnum and last.clamnum;
run;

Docs: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrcon/n01a08zkzy5igbn173zjz82zsi1s.htm

[data_null__]

You can create the subset directly from PROC SORT.

data have;
   input clamnum  sno;
   datalines;
900001 1
900001  2
900002  3
900003  4
900003  5
900008  6
;
run;

proc sort nounikey data=have out=dups uniout=unique;
   by clamnum;
   run;
proc print data=unique;
   run;
proc print data=dups;
   run;

[andreas_lds]

Interesting, i have never seen the options "nounikey" ... will have to memorise it.