topic Re: Removing the lowest value in grouped variables in SAS Programming

Removing the lowest value in grouped variables

deleted_user — Wed, 02 Dec 2009 23:34:09 GMT

Hi.

If I have an array -

array z

x1-x5 y1-y10;

and I want to get rid of the lowest 2 values in x1-x5, and the lowest 2 values of y1-y10, how do I get rid of the values, and not the entire observation/variable? Or conversely, is there a way to just keep a subset of the kth highest values in x1-x5, y1-y10?

Sorry for the bad tables, but -
I have this:
obs x1 x2 x3 x4 x5 y1 y2 y3 ... y10
1 10 9 2 5 3 9 9 0 ... 2
2 0 0 7 10 9 3 10 9 ... 10
...
500 9 5 9 5 9 10 5 6 ... 7

what i want is something like:

obs x1 x2 x3 x4 x5 y1 y2 y3 ... y10
1 10 9 . 5 . 9 9 . ... .
2 . . 7 10 9 . 10 9 ... 10
...
500 9 . 9 . 9 10 . . ... 7

thanks!

Re: Removing the lowest value in grouped variables

Peter_C — Thu, 03 Dec 2009 07:55:25 GMT

what is your preference?
PROC TRANSPOSE, PROC RANK, PROC TRANSPOSE.
or ARRAY handling in a data step?
PeterC

Re: Removing the lowest value in grouped variables

deleted_user — Thu, 03 Dec 2009 09:06:16 GMT

Knowing how to do it in an array within the data step would be my preference. I thought about trying the transpose rank transpose but it seems like an inefficient way to go about it.

Re: Removing the lowest value in grouped variables

data_null__ — Thu, 03 Dec 2009 12:07:47 GMT

Which Smallest.

[pre]
data have;
input x1-x5 y1 y2 y3 y10;
array x[5];
array y

y:;
when='Before';
output;
do i = 2,1;
x[whichN(smallest(i,of x

),of x

)] = .;
y[whichN(smallest(i,of y

),of y

)] = .;
end;
when='After';
output;
cards;
10 9 2 5 3 9 9 0 2
0 0 7 10 9 3 10 9 10
9 5 9 5 9 10 5 6 7
;;;;
run;
proc print;
run;
[/pre]

Re: Removing the lowest value in grouped variables

SASPhile — Thu, 03 Dec 2009 16:45:14 GMT

Does this hold good only for two smallest values?if the need be for 3 or 4 lowest values how will this work?
I have gone through the documentation and the example is not clearly explained.

Re: Removing the lowest value in grouped variables

deleted_user — Thu, 03 Dec 2009 21:59:18 GMT

Thank you _null_, that is exactly what I was looking for. I'll have to jot that one down for future reference.

Cheers!