How can I calculate Inverse Cumulative Probability?

[alexim]

The math behind distribution tables is complicated. Does SAS University Edition provide the means to calculate such values without specifying all the mathematical details in a program.

For example calculate the critical value or Inverse Cumulative Probability for F distribution (for 2-Way ANOVA) given Numerator degrees of freedom = xx, Denominator degrees of freedom = xx, alpha = 0.05 (input constant = 0.95). Can you point me to a code example?

thanks,

Alexim

[Reeza · Accepted solution]

Check the functions under the probability section:

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n01f5qrjoh9h4hn1olbdpb5pr2td.htm...

---

@alexim wrote:

The math behind distribution tables is complicated. Does SAS University Edition provide the means to calculate such values without specifying all the mathematical details in a program.

For example calculate the critical value or Inverse Cumulative Probability for F distribution (for 2-Way ANOVA) given Numerator degrees of freedom = xx, Denominator degrees of freedom = xx, alpha = 0.05 (input constant = 0.95). Can you point me to a code example?

thanks,

Alexim

---

[alexim]

Thanks, haven't found exactly what I'm looking for but you've got me headed in the right direction I believe.

Alexim

[alexim]

The required function is QUANTILE.

data one;
x=quantile('F',0.95, 1, 4);
put x=;
run;

Alexim

[Reeza]

You want the Quantile function then 🙂

data demo;

CriticalValueNormal = quantile('Normal', 0.025);
CriticalValueF = quantile('F', 0.025, 2, 3);

run;

proc print data=demo;
run;

https://communities.sas.com/t5/General-SAS-Programming/alpha-and-z-value/td-p/254023

[alexim]

Yes I discovered QUANTILE just prior to your latest post, you did head me in the right direction, very much appreciate your assistance.

thanks,
Alexim