Desktop productivity for business analysts and programmers

Categorising a continuous variable into quantiles

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

Categorising a continuous variable into quantiles

I would need to categorize continuous variables in tertiles.

How can I do this in Enterprise Guide with the Query Builder,

computing columns interface?


Accepted Solutions
Solution
‎02-04-2013 07:58 AM
Community Manager
Posts: 2,691

Re: Categorising a continuous variable into quantiles

I think the easiest method is to use the Tasks->Data->Rank Data task.  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.

rankdata.png

This will produce an output data set with your original variables, plus a new "rank" variable that indicates 1, 2, or 3.

Chris

View solution in original post


All Replies
Solution
‎02-04-2013 07:58 AM
Community Manager
Posts: 2,691

Re: Categorising a continuous variable into quantiles

I think the easiest method is to use the Tasks->Data->Rank Data task.  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.

rankdata.png

This will produce an output data set with your original variables, plus a new "rank" variable that indicates 1, 2, or 3.

Chris

Occasional Contributor
Posts: 6

Re: Categorising a continuous variable into quantiles

Great, thank you!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 670 views
  • 0 likes
  • 2 in conversation