Hey,
Is it possible to calculate the 99.865 percentile in VA? I am working with SAS VIYA.
I found the solution: the percentile-funcion is working, but NOT in" locale="de_DE" 🙂
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
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.
@Sam_SAS : Thank you for your help!
I am working with VA 8.5.1, but it doesen't work 😞
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:
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
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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.