Re: st: xtile and "by" question

[Edgard Alfonso Polanco Aguilar <e-polanc@uniandes.edu.co>]

Hi everybody,

Sergio, your hack was very helpful, it works great but in some dates it 
skips a quantile in some specific cities. For example, in the last 
period it "jumps" from quantile 4 to quantile 6. Don't you know why 
something like this would happen? I'm not very accustomed to macros and 
some of the syntax you used.

Thanks

Sergio Correia escribi�:

> 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 <e-polanc@uniandes.edu.co> 
> 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/
begin:vcard
fn:Edgard Alfonso Polanco Aguilar
n:Polanco Aguilar;Edgard Alfonso
tel;work:339 4949 ext: 2104
tel;cell:316 577 9895
version:2.1
end:vcard