Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Using -exapand
From
Tim Wade <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: Using -exapand
Date
Thu, 23 May 2013 09:29:46 -0400
Is something like this what you are looking for?
input id year n
1 1990 2
2 1945 5
3 1980 6
end
expand n
bysort id: gen year2=year+_n-1
Tim
On Thu, May 23, 2013 at 8:31 AM, James Bernard <[email protected]> wrote:
> Hi,
>
> I am trying to use -expand to replicate observations:
>
> Focalfirm Technology year n
> ------------- -------------- --------- -------------
>
> Toyota XYZ 1990 1
> Toyota XYZ 1991 4
> Toyota ZZZ 1990 --
> VW ABC 1999 2
> VW CDE 1998 3
>
>
> The idea is that I want to repeat each observation n times. However,
> the new observation must have an updated year number too. That is, the
> second observation must be repeated 4 times (including the original
> observation, of course), but the year must be updated. So, the next
> observations would be identical to the original one, except that their
> year will be 1992, 1993 and 1994.
>
> Using -expand,
>
> -expand n, generate(id)
>
> this is what I get
>
>
> Focalfirm Technology year n id
> Toyota XYZ 1990 1 0
> Toyota XYZ 1991 4 0
> Toyota ZZZ 1990 0
> VW ABC 1999 2 0
> VW CDE 1998 3 0
> Toyota XYZ 1991 4 1
> Toyota XYZ 1991 4 1
> Toyota XYZ 1991 4 1
> VW ABC 1999 2 1
> VW CDE 1998 3 1
> VW CDE 1998 3 1
>
>
>
> This is fine, except that the years are not updated. Any idea how I can do this?
>
> Thanks,
> James
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/faqs/resources/statalist-faq/
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/