Automation is SAS for outliers detection

[sas_search]

Hi team 

I am working on detection of outliers from the payroll data set where I have to detect the outliers on weekly basis. Kindly help me out in writing algorithm in SAS to automate the same. 

For reference below is one of the example of the data in which I have to find outliers.

Calls 425 555 235 452 654 785 452 555 665 245 324 245 365 452 754 854 546 456 652 345 246 356 124 758 111 954 845 

Thank you 

[PeterClemmensen]

Hi. There are several ways to do outlier detection in SAS. Do a Google search and you will find tons of examples.. However, it all depends on what you consider and outlier?

[Ksharp]

How do you define outliers ? out of range [mean-3*std , mean+3*std ] or [mean-2*std , mean+2*std ]  ......?

[ballardw]

---

@Ksharp wrote:

How do you define outliers ? out of range [mean-3*std , mean+3*std ] or [mean-2*std , mean+2*std ]  ......?

---

Amount of change from previous value? Above set value? Below set value?

[Ksharp]

Above set value  OR  Below set value .

[sas_search]

Outlier is an  out of range where If a value is higher and lesser than the 3 times of Interquartile Range (IQR)  

[PeterClemmensen]

Do you mean less than or greater than the mean +- 3*IQR? 

[PeterClemmensen · Accepted solution]

Just to get things started, you can do something like this

data have;
input Calls @@;
datalines;
425 555 235 452 654 785 452 555 665
245 324 245 365 452 754 854 546 456
652 345 246 356 124 758 111 954 845
;

proc univariate data=have;
    var Calls;
    output out=stats qrange=iqr mean=mean;
run; 

data Outliers;
    if _n_=1 then set stats;
    set have;
    if calls lt mean-1.5*iqr | calls gt mean+1.5*iqr;
run;

[sas_search]

Hi

Thank you for the solution I got it.