topic Re: tertiles in SAS Programming

tertiles

peiy5920 — Sun, 19 Jan 2020 23:06:32 GMT

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;

Re: tertiles

PaigeMiller — Sun, 19 Jan 2020 23:09:21 GMT

use the option in PROC UNIVARIATE

pctlpts=33.33 66.67

Re: tertiles

peiy5920 — Sun, 19 Jan 2020 23:25:20 GMT

Thank you so much for your help.

Re: tertiles

peiy5920 — Mon, 20 Jan 2020 21:17:02 GMT

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.