08-18-2017 05:28 AM
I hope you're doing well. I have a question if I can get or compute the median of a table in Data Query? I would like to pre-compute this in VDB and make it static before creating a report in VA.
Hope someone could tell me if this is possible or not.
08-21-2017 05:41 PM - edited 08-21-2017 05:49 PM
@Albert0 I think using the point and click tools in data builder you can only calculate average not median, however you can unlock the code so may well be able to manually calculate - https://communities.sas.com/t5/SAS-Visual-Analytics/Tip-Unlocking-code-in-SAS-Visual-Data-Builder/td...
If you don't have Data Integration Studio then Enterprise Guide will allow you to do what you need.
@LinusH- I agree with your sentiment but unfortunately VA lacks the power of its main competitors to calculate aggregations of aggregations, this forces report designers to pre-aggregate data in order to meet the needs of end users. Not ideal but doesn't seem likely to change in the short/medium term, Its a shame as VA is a decent tool otherwise. http://blogs.sas.com/content/sgf/2016/06/21/need-an-aggregation-of-an-aggregation-use-visual-data-bu...