SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Capture of Median - DataFlux

Reply
Contributor
Posts: 42

Capture of Median - DataFlux

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

SAS Employee
Posts: 85

Re: Capture of Median - DataFlux

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:

itssasct - Remote Desktop Connection_2014-11-25_11-44-50.png

Input:

itssasct - Remote Desktop Connection_2014-11-25_11-47-03.png

Output:

itssasct - Remote Desktop Connection_2014-11-25_11-47-52.png

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

-shawn

Contributor
Posts: 42

Re: Capture of Median - DataFlux

Hey Shawan,

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

SAS Employee
Posts: 85

Re: Capture of Median - DataFlux

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

Attachment
Attachment
Ask a Question
Discussion stats
  • 3 replies
  • 322 views
  • 0 likes
  • 2 in conversation