creating quantiles of adherence

[Chiara Paoletti]

Dear all,

I am not an expert in stata, since I am just a student, so if my problem might seem really simple to you I would still really appreciate feedback and help.

So my issue is this:I am working on a dietary score, which I have already computed into one single variable. Now I would like to have a variable that shows me those adhering the most (scoring highest) and those adhering the least (scoring the lowest). But I don't want this variable to be binomial but categorial, showing me quantiles of adherence (ex. 25, 50, 75, 85, etc).

I have tried playing around with the commands xtiles and pctiles but either they don't show me what I want or I have computed my code wrong...
Also, I can't make the command "tabulate varlist, row" because the dataset is large and stata sends me an error that there are too many observations..

If anyone has any recommendations please let me know! Thank you!!

[Nick Cox]

Cross-posted at https://www.reddit.com/r/stata/comme..._of_adherence/

Please note our policy on cross-posting, explicit in the FAQ Advice which you're asked to read before posting. https://www.statalist.org/forums/help#crossposting

The folks at Reddit must shift for themselves but telling people about cross-posting anywhere is always a good idea. That way, people who might answer can check to see if advice as good or better has already been given. People who don't know the answer but would like to read any posted can also check in the same way.

A bigger deal is the lack of a data example and the lack of code to discuss. Having a big dataset is neither here nor there: an example is what we need. https://www.statalist.org/forums/help#stata is key here. Commands just reported as "they don't show me what I want" can't be discussed. That's on all fours with "I can't get my car, washing machine or partner working the way i want".

Perhaps what you want is just a percentile rank, plotting position or similar. That's an FAQ https://www.stata.com/support/faqs/s...ing-positions/