The logic is something you need to create per variable but SAS has enough proc’s to get percentile, box plot and other descriptive data and graphs for you to decide how you want to treat the outliers.

You can build a macro for the data set you are using and make it automated based on applying a domain knowledge over the data and fine tuning what logic you want for treating them.

Example - Say income. There is a chance that there are 20 Senior folks in your company whose salary is so high that they appear as a cluster and as an outlier. To treat (Cap) or not to treat is driven by what you are achieving and you will have to use the business knowledge and purpose of report to do it.

Easiest approach - Get Percentiles from 1-15 and 85-99 and 99-99.99 and look at max % drop in values to see realistic outliers.

Say 99.95 to 99.99 there is a 30% drop in value, i would use a logic to cap it at 99.95 which also means i am not losing too many values.

Blind logic to use is cap it at 99.97.