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]

From |
Tim Wade <wadetj@gmail.com> |

To |
"statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |

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 <jamesstatalist@gmail.com> 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/

**Follow-Ups**:**Re: st: Using -exapand***From:*James Bernard <jamesstatalist@gmail.com>

**References**:**st: Using -exapand***From:*James Bernard <jamesstatalist@gmail.com>

- Prev by Date:
**Re: st: Plot probability function after xtlogit, re - how to interpret constant?** - Next by Date:
**Re: st: Using -exapand** - Previous by thread:
**Re: st: Using -exapand** - Next by thread:
**Re: st: Using -exapand** - Index(es):