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

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

RSS Feed icon

Expansion of Free Lunch Could Have a Negative Effect on Research Data

You’ll live longer than you think you will [HRS data]

Federal Register Notice: Some ACS questions on the chopping block

Political Science: A self-inflicted wound?

Sage Stats and CQ Political Stats Trial

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

Annotated Resources:

Direct Links:

Related Question Groups: