Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: Best way to construct panel dataset from mutiple cross sectional files.


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Best way to construct panel dataset from mutiple cross sectional files.
Date   Mon, 14 Jun 2010 21:21:25 +0200

<>

It is not clear that this is a -merge- job, in spite of the constant
position within the datasets. You could also -append- them and save yourself
the trouble of -reshape-ing...


HTH
Martin


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Jason Hecht
Sent: Montag, 14. Juni 2010 21:13
To: statalist@hsphsun2.harvard.edu
Subject: st: Best way to construct panel dataset from mutiple cross
sectional files.

I have separate datasets for each year from 1998 through 2008.  Within
each dataset, each observation represents a single firm that maintains
the exact same observation number across all eleven years (e.g., GM is
obs. #9 in the 1998, 1999, 2000, etc. dataset).  I would like to
create a panel for all 14,247 firms.  I think I need to first merge
all the datasets and then use the reshape command to go from wide to
long form.  Is this the best to way to go?

Thanks so much.  Jason
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index