topic Re: how to use variable value as parameter value in quantile function? in SAS Programming

how to use variable value as parameter value in quantile function?

grace999 — Sun, 27 Jan 2019 13:53:49 GMT

Assume a random variable follow normal distribution with mean 10, std 7, and I would like to know the 80 percentile value. I use quantile('normal', 0.8, 10, 7) get 15.89134864. I have a bunch of random variables with different mean and std, and I tried quantile('normal', 0.8, mean, std) but does not work.

data have;

input randvar $1 mean:comma3. std comma3.;

datalines;

a 10 7

b 10 8

c 11 6

; run;

how do I get the table below? Thanks.

randvar	mean	std	pct80
a	10	7	15.89134864
b	10	8	16.73296987
c	10	6	15.0497274

Re: how to use variable value as parameter value in quantile function?

FreelanceReinh — Sun, 27 Jan 2019 15:13:15 GMT

Hello @grace999,

Can you be more specific regarding what "does not work"? Please post the log if you get error messages or the results if they are unexpected. Using your dataset HAVE the code below creates the table you want:

data want;
set have;
if randvar='c' then mean+(-1);
pct80=quantile('normal', 0.8, mean, std);
run;

proc print data=want noobs;
format pct80 best11.;
run;

(I used an IF-THEN statement to modify the third mean value according to your table. Maybe it was just a typo.)

Re: how to use variable value as parameter value in quantile function?

grace999 — Sun, 27 Jan 2019 23:54:20 GMT

Thank you very much!