topic Re: find the top n biger value in each obsevation in SAS Programming

find the top n biger value in each obsevation

LillianLee — Tue, 04 Mar 2014 13:55:51 GMT

I have a data set that have over thousands observations and over ten variables, and all values are numeric.

what I need to do is find out the top 6 bigger values for each observation.

Any feedback would be greatly appreciated

Re: find the top n biger value in each obsevation

Tom — Tue, 04 Mar 2014 14:31:50 GMT

Did you mean the top 6 values for each variable? Then why not use PROC UNIVARIATE.

Re: find the top n biger value in each obsevation

Haikuo — Tue, 04 Mar 2014 14:44:42 GMT

I am not clear on your final output, so this is just a idea that you may start upon, after conversion, n5-n10 will be the top 6 bigger value for each row.

%macro have;

data have;

do row=1 to 5;

%do i=1 %to 10;

n&i=ranuni(0);

%end;

output;

end;

run;

%mend;

%have;

data want;

set have;

array n(10) n:;

call sortn(of n(*));

/* put n5-n10;*/

run;

Haikuo

Re: find the top n biger value in each obsevation

LillianLee — Tue, 04 Mar 2014 18:34:52 GMT

no, the top 6 values in on observation.

Re: find the top n biger value in each obsevation

Reeza — Tue, 04 Mar 2014 18:35:42 GMT

Sample data and output are always helpful in determining requirements.

Re: find the top n biger value in each obsevation

data_null__ — Tue, 04 Mar 2014 19:29:43 GMT

Perhaps LARGEST function.

data have1;
   array x[10];
   do row=1 to 5; 
      do i=1 to dim(x);
         x=ranuni(1);
         end; 
      output; 
      end; 
   drop row i;
   run; 

data largest6;
   set have1;
   array l[6];
   do i=1 to dim(l);
      l=largest(i,of x:);
      end; 
   run; 
proc print; 
   run; 

Re: find the top n biger value in each obsevation

Peter_C — Thu, 06 Mar 2014 09:13:07 GMT

It might be that I'm easily impressed, but continue to be amazed at our contributor who comes up (I expect, first) with these novel functions like

LARGEST(i, array )

Much appreciation for contributor

Re: find the top n biger value in each obsevation

data_null__ — Thu, 06 Mar 2014 16:16:41 GMT

For a descending sort you can use a descending enumerated range.

data want;
   set have;
   set have(rename=(x1-x10=n1-n10));
   call sortn(of n10-n1);
   drop n7-n10;
   run;

Re: find the top n biger value in each obsevation

data_null__ — Thu, 06 Mar 2014 16:20:31 GMT

Thank you . The last few versions of SAS have intruduced some really nice functions.

Re: find the top n biger value in each obsevation

Haikuo — Thu, 06 Mar 2014 19:12:05 GMT

Thanks, Null. Did not think of that.

Haikuo