Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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


From   Ronnie Babigumira <rb.glists@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: constructing an unbalanced panel data set based on existingrange variables
Date   Wed, 29 Mar 2006 17:51:31 +0200

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/



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