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?
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;
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;
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.
If that’s the goal look at the TRIMMED and/or WINDSOR option in PROC UNIVARIATE.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.