topic Re: Outlier Macro in SAS Data Science

Outlier Macro

dsp1 — Fri, 02 Feb 2018 05:30:26 GMT

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.

Re: Outlier Macro

andreas_lds — Fri, 02 Feb 2018 06:06:03 GMT

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

Re: Outlier Macro

dsp1 — Fri, 02 Feb 2018 06:24:01 GMT

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....

Re: Outlier Macro

RW9 — Fri, 02 Feb 2018 09:10:49 GMT

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

Re: Outlier Macro

Kurt_Bremser — Fri, 02 Feb 2018 09:23:06 GMT

@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.

Re: Outlier Macro

PaigeMiller — Fri, 02 Feb 2018 11:31:24 GMT

There's also Google, have you tried that?

Re: Outlier Macro

ChrisHemedinger — Fri, 02 Feb 2018 12:36:15 GMT

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).

Re: Outlier Macro

Ksharp — Fri, 02 Feb 2018 12:56:00 GMT

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

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-and-scatter.html

Re: Outlier Macro

Reeza — Fri, 02 Feb 2018 16:05:41 GMT

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