topic Categorising a continuous variable into quantiles in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Categorising-a-continuous-variable-into-quantiles/m-p/96299#M8741 <HTML><HEAD></HEAD><BODY><P>I would need to categorize continuous variables in tertiles.</P><P>How can I do this in Enterprise Guide with the Query Builder,</P><P>computing columns interface?</P></BODY></HTML> Mon, 04 Feb 2013 09:29:21 GMT KekeK 2013-02-04T09:29:21Z Categorising a continuous variable into quantiles https://communities.sas.com/t5/SAS-Enterprise-Guide/Categorising-a-continuous-variable-into-quantiles/m-p/96299#M8741 <HTML><HEAD></HEAD><BODY><P>I would need to categorize continuous variables in tertiles.</P><P>How can I do this in Enterprise Guide with the Query Builder,</P><P>computing columns interface?</P></BODY></HTML> Mon, 04 Feb 2013 09:29:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Categorising-a-continuous-variable-into-quantiles/m-p/96299#M8741 KekeK 2013-02-04T09:29:21Z Re: Categorising a continuous variable into quantiles https://communities.sas.com/t5/SAS-Enterprise-Guide/Categorising-a-continuous-variable-into-quantiles/m-p/96300#M8742 <HTML><HEAD></HEAD><BODY><P>I think the easiest method is to use the Tasks-&gt;Data-&gt;Rank Data task.&nbsp; Select the column that you want to rank (the continuous variable of interest), and then on the Options page, select Group=N, and specify "3" for the Number of Groups value.</P><P></P><P><IMG alt="rankdata.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/3059_rankdata.png" width="450" /></P><P>This will produce an output data set with your original variables, plus a new "rank" variable that indicates 1, 2, or 3.</P><P></P><P>Chris</P></BODY></HTML> Mon, 04 Feb 2013 12:58:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Categorising-a-continuous-variable-into-quantiles/m-p/96300#M8742 ChrisHemedinger 2013-02-04T12:58:12Z Re: Categorising a continuous variable into quantiles https://communities.sas.com/t5/SAS-Enterprise-Guide/Categorising-a-continuous-variable-into-quantiles/m-p/96301#M8743 <HTML><HEAD></HEAD><BODY><P>Great, thank you! </P></BODY></HTML> Mon, 04 Feb 2013 13:11:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Categorising-a-continuous-variable-into-quantiles/m-p/96301#M8743 KekeK 2013-02-04T13:11:01Z