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]
st: RE: Best way to construct panel dataset from mutiple cross sectional files.
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
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: [email protected]
[mailto:[email protected]] On Behalf Of Jason Hecht
Sent: Montag, 14. Juni 2010 21:13
To: [email protected]
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/