tertiles

[peiy5920]

Hello,

Codes for find 20%, 40%, 60%, and 80% percentile for the variable PCR_URINE_COMBINED.
proc univariate data=PROJECT.PAPER_CRIC; var PCR_URINE_COMBINED; output out=perc pctlpre=P_ pctlpts= 20 40 60 80; run;

But how to define tertiles, I did not figure out. Can someone help me? Thank you.
proc univariate data=PROJECT.PAPER_CRIC; var PCR_URINE_COMBINED; output out=tert tertpre=T_ tertpts= 30 60 90; run;

[PaigeMiller · Accepted solution]

use the option in PROC UNIVARIATE

pctlpts=33.33 66.67

[peiy5920]

Thank you so much  for your help.

[peiy5920]

I already knew 2 points of the variable according to 33.33 and 66.67, then how can I create 3 parts of this variables, that is from continuous variable to categorical variable. Can you show me some example codes? Thanks.