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

["Martin Weiss" <martin.weiss1@gmx.de>]

<>

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/