Re: st: Merging data

["Ezell, Mike" <mike.ezell@vanderbilt.edu>]

Unless I am misunderstanding something, -append- is what you want.

--On Monday, March 31, 2003 5:32 PM -0600 Reka Sundaram-Stukel 
<rsundara@wisc.edu> wrote:


> Dear statalist,
>
> I am trying to create a panel dataset and I need to merge several
> datasets in a particular way but don't know how to. See example
> below.
>
> I have 2 data sets
>
> 1999.dta contains
>
> id 	income	year
> 1       $		1999
> 2 	$		1999
> 3	$		1999
>
> 2000.dta has the same info.
>
> I want to merge these two datasets to look like
>
> id 	year 		income
> 1	1999	$
> 1	2000	$
> 2	1999	$
> 2	2000	$
> 3	1999	$
> 3	2000	$
>
> I would really appreciate any help on this.
>
> Reka
>
> *
> *   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/


---------------------------------------
Michael E. Ezell, Ph.D.
Assistant Professor
Department of Sociology
Vanderbilt University
Email: mike.ezell@vanderbilt.edu
---------------------------------------
*
*   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/