topic Re: Percentiles in proc univariate in SAS Procedures

Re: Percentiles in proc univariate

anilgvdbm — Tue, 29 Apr 2014 06:09:55 GMT

Dear All,

Here my problem is i need percentiles of weight and age_months for 0-60 months. so here i need results like weight for Age. in graph X axies age_months and Y axies weight.

For this i tried

proc univariate data=child766;

class Age_months sex;

var weight_kg;

output out=perplts pctlpre=_Pwt P_Age p

pctlpts=6 12 24 36 48 60 ;run;

please suggest me how to go with this??/

Regards,

Anil

Re: Percentiles in proc univariate

sudi — Tue, 29 Apr 2014 11:34:02 GMT

can you please provide the dataset which you are reffering to.

Re: Percentiles in proc univariate

djmangen — Tue, 29 Apr 2014 23:50:23 GMT

Try this:

proc univariate data=child766;

class Age_months sex;

var weight_kg;

output out=perplts pctlpre= Pwt_

pctlpts=6 12 24 36 48 60 ;

run;

I suspect that you were specifying too many prefixes.

Re: Percentiles in proc univariate

SteveDenham — Wed, 30 Apr 2014 16:37:40 GMT

What is up with the weird pctlpts values? This is going to give the sixth, twelfth, etc. percentile of all of the data within each month.

And if my hunch is correct, the 60 corresponds to 1he 100th percentile or the maximum. I would ask the original poster what percentiles of the data they are interested in at each month.

Steve Denham

Re: Percentiles in proc univariate

anilgvdbm — Thu, 01 May 2014 04:59:44 GMT

Dear SteveDenham,

Here i am looking for child growth rate from the age and weight so i need percentiles of each year child's weight. because i cont calculate bmi for child so the from the percentiles i can separate the under weight and normal obese.

Thank you ..

regards,

Anil

Re: Percentiles in proc univariate

Ksharp — Thu, 01 May 2014 07:40:47 GMT

pctlpts=1 to 100 by 1 ;

Xia Keshan

Re: Percentiles in proc univariate

SteveDenham — Thu, 01 May 2014 12:16:14 GMT

Follow 's recommendation, and get all of the percentiles for each sex and month. Then you can separate more easily.

However, I think you may want to look at the documentation for PROC QUANTREG, if you are looking for predictors of the various quantiles/percentiles.

Steve Denham