topic Re: Data Profiling in SAS Programming

Data Profiling

abhityagi — Mon, 06 Jan 2020 17:47:03 GMT

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!

Re: Data Profiling

ed_sas_member — Mon, 06 Jan 2020 17:55:21 GMT

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#p0v0y1on1hbxukn0zqgsp5ky8hc0.htm

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

Re: Data Profiling

Reeza — Mon, 06 Jan 2020 18:03:09 GMT

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_examples.htm&locale=en

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