Data Profiling

[abhityagi]

Hi Team,

How to achieve given below request in sas.

* Mean value and Range of values for numeric fields
• Five lowest and five highest values.

* How to find outliers in SAS column.

Thanks!

[ed_sas_member]

Hi @abhityagi 

You will find most information you need in the following link : http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p0v0y1on1hbxukn0zqgsp...

The table The Most Common Simple Statistics compares the different procedures that you can use to get what you want.

[Reeza]

Try PROC UNIVARIATE

There are examples for most of the things you're asking for here:

https://documentation.sas.com/?docsetId=procstat&docsetVersion=9.4&docsetTarget=procstat_univariate_...

---

@abhityagi wrote:

Hi Team,

How to achieve given below request in sas.

* Mean value and Range of values for numeric fields
• Five lowest and five highest values.

* How to find outliers in SAS column.

Thanks!

---