topic Re: SAS Visual Data Builder in SAS Visual Analytics

SAS Visual Data Builder

Albert0 — Fri, 18 Aug 2017 09:28:41 GMT

Hi All,

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.

Thanks.

Albert

Re: SAS Visual Data Builder

LinusH — Sun, 20 Aug 2017 17:25:03 GMT

I don't think so, at least not OOTB. Perhaps in a separate Base SAS program.
But why? Saving the median into a table makes the data inflexible.

Re: SAS Visual Data Builder

itchyeyeballs — Mon, 21 Aug 2017 21:49:29 GMT

Hi,

@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-p/289234

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-builder-to-pre-aggregate-your-data/

Re: SAS Visual Data Builder

Albert0 — Tue, 22 Aug 2017 00:57:45 GMT

Hi Guys,

Thank you for your help...I'll try another approach.

Regards,
Albert0