BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
PhilipH
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

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

3 REPLIES 3
BrunoMueller
SAS Super FREQ

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
PhilipH
Quartz | Level 8
Hi Bruno
Thanks.
Where else should I calculate the median to show it on a WRS report? Can I do that in WRS?
BrunoMueller
SAS Super FREQ

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

 

Bruno

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

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