Proc univariate : Conf intervals for percentiles

kaet78ha — Tue, 01 Jun 2021 09:39:38 GMT

I'm trying to calculate the following stats :

25th percentile (95% CI)
Median (Weeks) (95% CI)
75th percentile (95% CI)

by using proc univariate

And I'm getting the results:

But I'm a little bit confused with output CI to the datset, I'm trying like:

ods select Quantiles;
proc univariate data=Sashelp.Cars ciquantnormal(alpha=.1 );
var MPG_City;
output out=a1 q1=q25 q3=q75 median=median min=min max=max lclm=lci uclm=dfd;
run;

But I'm getting an error :

ERROR 22-322: Syntax error, expecting one of the following: CSS, CV, GEOMEAN, GINI, KURTOSIS, MAD, MAX, MEAN, MEDIAN, MIN, MODE,
MSIGN, N, NMISS, NOBS, NORMAL, P1, P10, P5, P90, P95, P99, PCTLNAME, PCTLPRE, PROBM, PROBN, PROBS, PROBT, Q1, Q3, QN,
QRANGE, RANGE, SIGNRANK, SKEWNESS, SN, STD, STDMEAN, STD_GINI, STD_MAD, STD_QN, STD_QRANGE, STD_SN, SUM, SUMWGT, T,
USS, VAR.

I suppose I'm using the wrong way for output CI, can somebody help?

Re: Proc univariate : Conf intervals for percentiles

FreelanceReinh — Tue, 01 Jun 2021 10:23:38 GMT

Hello @kaet78ha,

Replace the OUTPUT statement with an ODS OUTPUT statement to get what you want:

ods output Quantiles=want;

Also, if you want 95% CIs, then omit the ALPHA= option (or use ALPHA=.05 explicitly).

topic Re: Proc univariate : Conf intervals for percentiles in SAS Procedures

Proc univariate : Conf intervals for percentiles

Re: Proc univariate : Conf intervals for percentiles