Bookmark and Share

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: Data manipulation issue


From   Kenisha Russell <[email protected]>
To   "[email protected]" <[email protected]>
Subject   st: Data manipulation issue
Date   Thu, 16 Aug 2012 07:50:48 +0000

Hi All, 
I have the following three data sets.

Dataset 1
ID	year	month	educ	age
A	2005	8	Secondary 	21
A	2005	9	Secondary	21
A	2005	10	Secondary	21
A	2005	11	Secondary	21
A	2005	12	Secondary	21
A	2006	1	Secondary	22
A	2006	2	Secondary	22

Dataset 2
ID	Reg_year	Reg_month	Reg_day
A	2002	8	1

Dataset 3
ID          status-year         status_ month	status_ day	emp_status
A	2005	9	3	internship
A	2006	2	1	employed


What I would like to do is create one  large dataset organized as below. I would appreciate any ideas and or suggestions on how to do this. 

ID	year	month	educ	Reg_year	Reg_month	Reg_day   status_year  status_ month  status__ day    emp_status
A	.	.	.	2002	8	1	.	.	.	.
A	2005	8	Secondary 				.	.	.	.
A	2005	9	Secondary				2005	9	3	internship
A	2005	10	Secondary				.	.	.	.
A	2005	11	Secondary				.	.	.	.
A	2005	12	Secondary				.	.	.	.
A	2006	1	Secondary				.	.	.	.
A	2006	2	Secondary				2006	2	1	employed

Thanks for your time and advice beforehand.
Kenisha



*
*   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index