topic Re: Capture of Median - DataFlux in SAS Data Management

Capture of Median - DataFlux

Ronny_Dsouza — Mon, 24 Nov 2014 20:12:53 GMT

Hi All,

As part of a Business Rule, there is a requirement of using the Median as part of the condition, one of the approach we are trying to take is to see if its part of any of the profiling node which then can be used in conjunction of the Data Monitoring node in a data job.

Hence the following query

1) Is there any manner wherein I can capture the Median Statistic that is outputted as part of a Profiling activity, if Not

2) Any one who has used the expression node to generate the median.

Regard

Ronny

Re: Capture of Median - DataFlux

skillman — Tue, 25 Nov 2014 16:49:34 GMT

Ronny,

There is not a straightforward way to do this with just one expression. I have attached a screenshot of a job that will calculate the median:

Input:

Output:

The other variables are ones that were created to assist in the median calculation.

-shawn

Re: Capture of Median - DataFlux

Ronny_Dsouza — Wed, 26 Nov 2014 19:44:37 GMT

Hey Shawan,

would it be possible to share the job , it would be of great help

Re: Capture of Median - DataFlux

skillman — Mon, 01 Dec 2014 14:22:32 GMT

Ronny, I have attached the job in a Data Management package file as well as the ddf file.

Let me know if you have any questions importing it into your environment, or any questions about the job itself.

Thanks,

-shawn