/****************************************************************/ /* Created by: Simon Freidin (Updated by: Michelle Summerfield) */ /* */ /* Purpose of the program: */ /* This program merges wave 1 household and responding person */ /* files */ /* **************************************************************/ *Specify the release and the version of the data used; %let release=140; %let version=140; * Location of datasets (edit to reflect your paths); libname hilda "X:\HILDA\Release &release.\Files\SAS &version.c" access=readonly; data w1p; set hilda.rperson_a&version.c; run; * get the information from the household file; data w1h; set hilda.household_a&version.c (keep=ahhrhid ahifefn ahifefp ahifdip ahifdin); run; proc sort data = w1p; by ahhrhid; proc sort data = w1h; by ahhrhid; data w1p; merge w1p w1h; by ahhrhid; run; * now w1p file got personal level information and selected household level information from the household file;