Percentile in SAS VIYA - Visual Analytics

[Muandre]

Hey,

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

[utrocketeng]

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

[Sam_SAS]

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.

[Muandre]

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

[Sam_SAS]

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.

[Muandre]

I am working in SAS VIYA, Version 3.5

[Sam_SAS]

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.

[Muandre]

@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:

[Muandre · Accepted solution]

@Sam_SAS 

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

[Sam_SAS]

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

[Muandre]

Yes, changing the local was the solution 🙂

[Sam_SAS]

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

[Muandre]

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)