topic How to do capping and flooring of outlier values? in SAS Programming

How to do capping and flooring of outlier values?

venkatard — Mon, 25 Mar 2013 10:30:05 GMT

How to do capping and flooring of outlier values in proc univariate?

Re: How to do capping and flooring of outlier values?

UrvishShah — Mon, 25 Mar 2013 10:57:04 GMT

Hi,

To set the limit of outliers to be printed, you can use the NEXTRAOBS = n option in proc univariate statement...By default, proc univariate give you maximum and minimum five values from the dataset...you can set the limit by using NEXTRAOBS = n option...

Re: How to do capping and flooring of outlier values?

venkatard — Mon, 25 Mar 2013 11:59:33 GMT

I have a dataset which has many variables- By using proc univariate i found the outliers. Now i want to cap and floor the outlier values.

Re: How to do capping and flooring of outlier values?

UrvishShah — Mon, 25 Mar 2013 12:28:29 GMT

Try the following code...

ODS OUTPUT extremeobs = extremeobs;

proc univariate data = dsn noprint;

var ...;

run;

ODS OUTPUT CLOSE;

proc sql;

select min(low) as min_extreme,

max(high) as high_extreme

from extremeobs;

quit;

Hope it meets the requirement...

Thanks,

Urvish

Re: How to do capping and flooring of outlier values?

venkatard — Mon, 25 Mar 2013 13:43:06 GMT

I have used the below code and got the result. Thanks

ODS OUTPUT extremeobs = extremeobs;

proc univariate data = lcs_beta.studentgpadevelopment plot ;

var no_of_posts_New;

output out=inc pctlpre=Q_ pctlpts=5, 95 ;

run;

ODS OUTPUT CLOSE;

Re: How to do capping and flooring of outlier values?

Peter_C — Mon, 25 Mar 2013 14:59:23 GMT

thank you for clarifying what you wanted.

I had thought you wanted to apply 5 and 95% filters, not just "collect" the P5 and P95 stats

an alternate (and I think simpler because it doesn't use ods)

proc means data= your.data min p5 p95 max ;

var no_of_posts_New;

output out= top_tail_pt p5= lower p95=upper ;

run ;

*****

and if you want to apply these stats ;

**** first put the 5pt-pctiles into macro vars;

proc sql noprint ;

select lower, upper into :low, :upp from top_tail_pt(obs=1) ;

quit ;

****** and now use them ;

data top_and_tailed ;

set your.data ;

where not (no_of_posts_New between &low and &upp) ;

run ;