Outlier Macro

[dsp1]

Hi, I am looking for a macro which needs to do some tasks as mentioned below.

It should check all outliers in the given dataset and treat those outliers based on some conditions like imputing those outlier values with median or mode or deleting those outliers...

If anyone have this macro, please share with us...

Thanks in advance.

[andreas_lds]

So another task that you don't want to solve for yourself. Maybe you should hire someone.

Link to the other macro request: https://communities.sas.com/t5/SAS-Data-Mining-and-Machine/Dummy-Variable-Creation-Macro/m-p/433387

[dsp1]

I am not kidding Andreas. I am new to SAS macros.......that's why asking and we have some existing macros for each question I asked. But in those macros, some manual intervention required and those macros are like bits and pieces...to solve those type of issues I have posted my requirements....

[RW9]

This is not a contract work request forum.  Please post specific question on individual items.

[Kurt_Bremser]

---

@rpeddireddy wrote:

I am not kidding Andreas. I am new to SAS macros.......that's why asking and we have some existing macros for each question I asked. But in those macros, some manual intervention required and those macros are like bits and pieces...to solve those type of issues I have posted my requirements....

---

If you are that far out of your depth, you should seriously consider hiring a consultant for the time being, and attend as many SAS courses as you can get while the consultant solves your most pressing issues.

[PaigeMiller]

There's also Google, have you tried that?

[ChrisHemedinger]

Perhaps if you could be more specific about your objective here, with sample data that shows what you're starting with and what you want as a result.

For example, if you're looking to reduce the impact of outliers on your data, you might be looking at Winsorization.  Or depending on your analysis, you could use ROBUSTREG to calculate univariate statistics that you need.

Asking for a specific macro -- which can be a dangerous black box of code if you don't understand what it's doing -- is a particular hot-button on this community (as you've seen).

[Ksharp · Accepted solution]

https://blogs.sas.com/content/iml/2012/01/20/detecting-outliers-in-sas-part-1-estimating-location.ht...

https://blogs.sas.com/content/iml/2012/01/27/detecting-outliers-in-sas-part-2-estimating-scale.html

https://blogs.sas.com/content/iml/2012/02/02/detecting-outliers-in-sas-part-3-multivariate-location-...

[Reeza]

Search LexJansen.com for user written papers which sometimes includes the code to solve these issues.