Search Data Services
Meta Search
search across all the following databases:
Data Catalog
Data and documentation
KnowledgeBase
Common questions and answers.
Resources
Entire collection of data resources.
Latest Data News
Measuring Marriage & Divorce among Same-Sex Couples
Data Services Knowledge Base
Q:
I downloaded the separate Cape Area Study Panel Waves 1-2-3 Household and Waves 1-2-3 Young Adult data and now I would like to merge them. How do I do that?
A:
The Waves 1-2-3 Household and Waves 1-2-3 Young Adult data can be merged on the unique individual identifier personid, as can all other CAPS Waves 1-2-3 datasets. STATA code below:
/*open the Household data (replace 'filepath' with the relevant mapping)*/
use \filepath\capsw123.h.merge.v0612.dta,clear
/*sort on personid before merging*/
sort personid
/*merge with the Young Adult data by personid (replace 'filepath' with the relevant mapping)
merge personid using \filepath\capsw123.y.wide.v0612.dta
The Cape Area Panel Study downloaded from: www.caps.uct.ac.za
More questions about CAPS? email: caps@umich.edu