Re: st: Re: RE: expand an agrregated file

[Gary Longton <glongton@fhcrc.org>]

ann fitzmaurice wrote:

> i have a file in the following format
>
> region lgd pop_lgd pop_region
> 1 1 20 65
> 1 2 45 65
> 2 1 10 25
> 2 2 15 25
>  There are other variables and populations with the
> variables but this is
> just a small example
>
> i would like to create a data set that is case based so
> instead of 4 lines
> in the above example will have 90 lines - i have looked at
> expand but am
> not sure if this is the command to use
Scott Merryman replied:

> I take it when you say you want 90 observations, you want to expand each region
> + lgd by its population?
>
> If so, one way would be to:
>
> forvalue i = 1/4 {
>     local num = pop_lgd[`i']
>     expand `num' in `i'
>     }
or more simply,

   expand pop_lgd

- Gary


*
*   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/