Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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


From   Gary Longton <[email protected]>
To   [email protected]
Subject   Re: st: Re: RE: expand an agrregated file
Date   Wed, 27 Aug 2003 15:58:25 -0700

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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index