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
James Bernard <[email protected]>
To
[email protected]
Subject
Re: st: Using -exapand
Date
Thu, 23 May 2013 21:37:48 +0800
Thanks Nick and Tim,
Your tips solved the issue
Regards,
James
On Thu, May 23, 2013 at 9:29 PM, Tim Wade <[email protected]> wrote:
> 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/
*
* 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/