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

InfoMap Studio and MEDIAN

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

InfoMap Studio and MEDIAN

Hi SAS Experts,

when I want to create a new variable using Information Map Studio
that calculates the mean I do the following:
MEDIAN(<<DMP_T_AVV_ERGEBNIS.NORMMW>>)
the result is a variable of type category and not measure.
Why is MAX(<<DMP_T_AVV_ERGEBNIS.NORMMW>>) a measure
but MEDIAN(<<DMP_T_AVV_ERGEBNIS.NORMMW>>) a category?
Why is there no measure in IMS for the median?

Bye


Accepted Solutions
Solution
‎03-31-2017 05:20 AM
SAS Super FREQ
Posts: 684

Re: InfoMap Studio and MEDIAN

[ Edited ]

Hi

 

You should be able to change this under Data Item Properties, see also attached screenshots.

 

Why the MEDIAN is not part of the aggregations, I do not know.

 

NOTE: do not use this infomap to get detailed data, as the median will be calculated over alle the rows.

 

Bruno

 

 

 

 


median_dataItemProp.PNG

View solution in original post


All Replies
Solution
‎03-31-2017 05:20 AM
SAS Super FREQ
Posts: 684

Re: InfoMap Studio and MEDIAN

[ Edited ]

Hi

 

You should be able to change this under Data Item Properties, see also attached screenshots.

 

Why the MEDIAN is not part of the aggregations, I do not know.

 

NOTE: do not use this infomap to get detailed data, as the median will be calculated over alle the rows.

 

Bruno

 

 

 

 


median_dataItemProp.PNG
Contributor
Posts: 71

Re: InfoMap Studio and MEDIAN

Hi Bruno
Thanks.
Where else should I calculate the median to show it on a WRS report? Can I do that in WRS?
SAS Super FREQ
Posts: 684

Re: InfoMap Studio and MEDIAN

WRS has only a subset of the aggregations available, so creating a new DataItem in the InformationMap is the way to go.

 

Bruno

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 214 views
  • 1 like
  • 2 in conversation