topic only need those clamnum which are not repeating in New SAS User

only need those clamnum which are not repeating

aanan1417 — Tue, 03 May 2022 07:12:35 GMT

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;

Re: only need those clamnum which are not repeating

andreas_lds — Tue, 03 May 2022 08:08:38 GMT

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

Re: only need those clamnum which are not repeating

data_null__ — Tue, 03 May 2022 13:21:07 GMT

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;

Re: only need those clamnum which are not repeating

andreas_lds — Wed, 04 May 2022 06:01:30 GMT

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