topic Re: Create weighted percentile calculations in Visual Analytics in SAS Visual Analytics

Create weighted percentile calculations in Visual Analytics

jens1 — Wed, 12 Jan 2022 15:28:27 GMT

Hi!

Need some help.

Have someone managed to create weighted percentile calculations in Visual Analytics ?

If so, could you please show some examples how to create them ?

We are working with Viya 3.5 and SAS VA 8.5.1.

Regards

Jens Öberg, TietoEvry

Re: Create weighted percentile calculations in Visual Analytics

acordes — Wed, 12 Jan 2022 18:51:37 GMT

read this do-loop entry from @Rick_SAS

https://blogs.sas.com/content/iml/2016/08/29/weighted-percentiles.html

I follow on that.

I think you can only achieve it if you duplicate the observations by their weight.

data public.weight(promote=yes);
input x wt;
datalines;
1    0.25
1.9  0.05
2.2  0.15
3.0  0.25
3.7  0.15
4.1  0.10
5    0.05
;

data public.weight1(promote=yes);
set public.weight;
decimals=input(scan(put(wt,best32.),2,'.'), best32.);
do i=1 to decimals;
output;
end;
drop i;
run;

Re: Create weighted percentile calculations in Visual Analytics

Rick_SAS — Mon, 24 Jan 2022 15:48:56 GMT

I am not familiar with computing weighted percentiles in SAS VA, but I don't think Arne's proposal will give the correct estimates.

Re: Create weighted percentile calculations in Visual Analytics

jens1 — Fri, 14 Jan 2022 11:53:51 GMT

Thanks for your answers.

It seems to be difficult to create the weighted percentile calculations in Visual Analytics. We will try some more, otherwise we have to pre-aggregate the values before landing in VA.

Regards

Jens