Re: st: RE: constructing an unbalanced panel data set based on existingrange variables

[Ronnie Babigumira <rb.glists@gmail.com>]

Alex, this is it (Im laughing at myself for what I posted before, its good time for me to go home).

Arik, ignore my gibberish and my apologies for consuming bandwidth :-)

Ronnie

Alex Ogan wrote:
> expand ((End - Start) + 1)
> bysort ID: gen IDyear = string(ID) + string(Start + _n - 1)
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Arik
> Sent: Wednesday, March 29, 2006 9:59 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: constructing an unbalanced panel data set based on existing
> range variables
>
> Hi, I have a list of observations by unit (firm),
> which I would like to transfrom into a panle data set,
> by year/unit.
>
> Right now, the first variables of the observations
> look something like
>
> ID      Start      End      Industry
> 1       1985       1990        3
> 2       1988       1991        1
> 3       1982       1993        3
>
> And I'd like them to look like
>
> IDyear       Industry
> 11985            3
> 11986            3            
> 11987            3
> 11988            3
> 11989            3
> 11990            3
> 21988            1
> 21989            1
> 21990            1
> 21991            1
> 31982            3
> 31983            3
> ...
> 31993            3
>
> Reshape does not seem to help, as I have a
> (unbalnaced) range, rather then a fixed list of
> variables. Any ideas, what I can do?
>
> Cheers, 
> Arik
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> *
> *   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/
>
>
> This message is intended solely for the designated recipient(s). It may contain confidential or proprietary information and may be subject to confidentiality protections. If you are not a designated recipient, you may not review, copy, or distribute this message. If you receive this in error, please notify the sender by reply e-mail and delete this message. 
> Arrowstreet Capital, L.P. is an Equal Opportunity Employer. 
>
>
> *
> *   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/
*
*   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/