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

[grace999]

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

[FreelanceReinh · Accepted solution]

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.)

[grace999]

Thank you very much!