Well, it seems that you should hack around that problem.
Something like this may help
* 1) Let's create a variable with the levels, and save them on a local macro
egen levels = group(date city)
levelsof levels, local(levels)
* 2) Now let's run a loop
gen output = .
foreach l of local levels {
xtile temp=income if levels==`l'
replace output = temp if output==.
drop temp
}
I tried it on some dummy data and it appeared to work.
Best,
Sergio
On 5/8/07, Edgard Alfonso Polanco Aguilar <[email protected]> wrote:
Hello everybody,
I'm working with a database which consists on income by month and
region. I need to classify the income by percentiles by city and month
because there's a wide dispersion on income levels across cities, to the
point that the highest income in one is on the median of another. I know
the command of choice for this task is xtile, but Stata doesn't allow me
to use it with "by" like in "by city date: xtile var=income nq(10)". I'm
working in Stata 9 SE for Windows.
Thaks!
Edgard
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
