Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

Common questions and answers.

Entire collection of data resources.

Latest Data News

RSS Feed icon

U.S. Department of Education Releases College Scorecard Data

Big changes coming to IRBs . . . . still time to comment

Will this be an election issue in the US?

U.S. and World Population Clock Has Been Updated with New Features

2013 Income, Poverty, and Health Insurance data

Data Services Knowledge Base


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?


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

Annotated Resources:

Direct Links:

Related Question Groups: