Hi,
I'm struggling to find a function in SAP HANA that can be used to create a percentile. I'm looking for something similar to the percentile_desc function in oracle that can create a percentile based on a certain subsets of the data.
What I'm exactly looking for:
Example, I have a table with 2 fields country & population of each state within that country
Need to find out the 99th percentile of population (within each country) and impute any value > than that to the 99th percentile.
Any help will be appreciated!
Thanks,
Vignesh
Hi Vignesh,
You can try to integrate R Language with your HANA instance, create a procedure using R Language and use quantile function in R programming language.
You can refer to the following guide (and sample procedure code) for HANA Development Guide - Integration with R programming language:
http://help.sap.com/hana/hana_dev_r_emb_en.pdf
Regards,
Ferry
Add a comment