topic Re: Percentile in SAS VIYA - Visual Analytics in SAS Visual Analytics

Percentile in SAS VIYA - Visual Analytics

Muandre — Thu, 12 Aug 2021 09:10:14 GMT

Hey,

Is it possible to calculate the 99.865 percentile in VA? I am working with SAS VIYA.

Re: Percentile in SAS VIYA - Visual Analytics

utrocketeng — Thu, 12 Aug 2021 13:28:34 GMT

i suspect that you will need to do new calculated item:

click the Operators tab, then filter for Percentile:

Enter your desired percentile in the GUI:

and choose your numeric column.

test it out to ensure that it is giving you the value you expect.

good luck

Re: Percentile in SAS VIYA - Visual Analytics

Sam_SAS — Thu, 12 Aug 2021 13:34:54 GMT

Yes, this should work. By default the column format will only display 2 decimal places, so you might want to change this if you want to display a more precise value.

Re: Percentile in SAS VIYA - Visual Analytics

Muandre — Thu, 12 Aug 2021 14:02:33 GMT

Percentile only works for integers, so Percentile [_ByGroup_] ('XXXXXX'n, 95) works, but Percentile [_ByGroup_] ('XXXX'n, 95.5) is a missing value.

Re: Percentile in SAS VIYA - Visual Analytics

Sam_SAS — Thu, 12 Aug 2021 14:19:26 GMT

What version of VA do you have? I tested this in the latest version and it worked and 95.656 returned a different value than 95 or 96.

Re: Percentile in SAS VIYA - Visual Analytics

Muandre — Thu, 12 Aug 2021 14:22:26 GMT

I am working in SAS VIYA, Version 3.5

Re: Percentile in SAS VIYA - Visual Analytics

Sam_SAS — Thu, 12 Aug 2021 14:28:54 GMT

If you click the user icon at the top right and select About, it should tell you the VA version number.

It works on VA 8.5 (which is Viya 3.5) but I don't have an older deployment available to test with.

Re: Percentile in SAS VIYA - Visual Analytics

Muandre — Fri, 13 Aug 2021 08:24:53 GMT

@Sam_SAS : Thank you for your help!

I am working with VA 8.5.1, but it doesen't work 😞

Test_integerTest_floating

COPY FROM BIRD:

<AggregateCalculatedItem dataType="double" name="bi166287" label="test_integer" format="COMMA12.2">
<Expression>percentile(group,${bi84,raw},50)</Expression>
</AggregateCalculatedItem>
<AggregateCalculatedItem dataType="double" name="bi166288" label="test_floating" format="COMMA12.2">
<Expression>percentile(group,${bi84,raw},50.53)</Expression>
</AggregateCalculatedItem>

Result in VA:

Re: Percentile in SAS VIYA - Visual Analytics

Muandre — Fri, 13 Aug 2021 09:52:07 GMT

@Sam_SAS

I found the solution: the percentile-funcion is working, but NOT in" locale="de_DE" 🙂

Re: Percentile in SAS VIYA - Visual Analytics

Sam_SAS — Fri, 13 Aug 2021 13:13:14 GMT

So by changing your locale you got it working? I will do what I can to be sure we are working on a fix for this.

Thanks,

Sam

Re: Percentile in SAS VIYA - Visual Analytics

Muandre — Fri, 13 Aug 2021 18:04:14 GMT

Yes, changing the local was the solution 🙂

Re: Percentile in SAS VIYA - Visual Analytics

Sam_SAS — Fri, 13 Aug 2021 18:54:53 GMT

Did you change the app/browser locale, or the locale of the CAS server?

I have reported the bug to the development team, but more details are always helpful to us 🙂

Thanks,

Sam

Re: Percentile in SAS VIYA - Visual Analytics

Muandre — Mon, 16 Aug 2021 06:00:41 GMT

I changed my locale and then I built my report again.

In BIRD, this line changed:
<CasResource server="cas-shared-default" library="Public" table="CLASS" locale="de_DE"/> (didn't work)
<CasResource server="cas-shared-default" library="Public" table="CLASS" locale="en_AU"/> (solution)