topic Re: Find out Kth smallest in SAS Programming

Find out Kth smallest

jitendrakoli — Thu, 22 Apr 2021 04:31:36 GMT

Dear All,

I want to find out 8th and 29th smallest value from data.

Please guide me.

Please find attached sample data.

Thanks,

Re: Find out Kth smallest

andreas_lds — Thu, 22 Apr 2021 05:01:56 GMT

Finding k-th smallest values has been discussed multiple times, the problem is even part of papers. So please search and adapt the things you find.

Re: Find out Kth smallest

japelin — Thu, 22 Apr 2021 05:18:04 GMT

You can identify the Kth obs by sorting in ascending order and specifying its obs number in _n_.

data have;
  input values;
datalines;
1.01
1.17
0.97
1.26
1.19
1.12
0.76
0.87
0.72
0.94
0.89
0.84
0.85
0.98
0.81
1.06
1
0.94
0.79
0.91
0.76
0.98
0.93
0.88
0.9
1.04
0.86
1.12
1.06
1
0.81
0.94
0.78
1.01
0.95
0.9
;
run;

proc sort data=have;
  by values;
run;

data want;
  set have;
  if _n_=8 or _n_=29 then do;
    order=cats(_n_,'th');
    output;
  end;
run;

Re: Find out Kth smallest

PeterClemmensen — Thu, 22 Apr 2021 10:33:34 GMT

Alternatively

proc summary data = have;
   var values;
   output out = want(keep = values_8 values_29) idgroup (max(values) out[29] (values) = );
run;

Re: Find out Kth smallest

Ksharp — Thu, 22 Apr 2021 11:48:38 GMT

Do you consider TIES value ?

Re: Find out Kth smallest

mkeintz — Thu, 22 Apr 2021 13:45:54 GMT

@PeterClemmensen :

This is a great solution I wish I had known about before (I really must go back and review proc summary).

BUT ... I think you need to replace "max(values)" with "min(values)"