How to drop the extremum

[Xinhui]

Let's suppose I have 100 values in my data set. If I want to drop the three highest values, as well as the three lowest values, what code would best accomplish this?

[WarrenKuhfeld · Accepted solution]

data x;
do i = 1 to 100;
   r = uniform(368);
output;
end;
run;

proc sort data=x; by r; run;

data x2;
   set x;
   if _n_ gt 3 and _n_ lt 98;
run;

[Reeza]

How are you planning to deal with duplicates. If you have 5 values of 100 as the highest, do all 5 go? What about the next 3 99s?

The rules are ambiguous. 

[Xinhui]

First, thank you for your valuable reminder.

Since I want to get rid the influence of extremum on my standard deviation, I think I should consider duplicate numbers as one value. So, in your example, if I have 5 duplicates of 100, they would all be gone. They are considered one value, not five.

[Reeza]

If that’s the goal look at the TRIMMED and/or WINDSOR option in PROC UNIVARIATE.