Home

HILDA User Manual
Overview The HILDA Data Users How to Order the Data Security Requirements How the Data Files are Provided Structure of the Data Files Identifiers Matching Files Creating Longitudinal Files PanelWhiz Variable Name Conventions Missing Value Conventions Data with Negative Values Confidentialisation Derived Variables Age and Sex History Spatial Current Education Current Marriage /Defacto Relationship Children Child Care Employment Calculating hourly wage rates Calendar Family Health Housing Time Use Household Expenditure Life – Personality Income and Income Imputation Wealth and Wealth Imputation Weights Documentation Data Quality Issues The HILDA Sample Data Collection Pilot Testing Questionnaire Length Interviewers Fieldwork Process Response Rates Attrition Bias Data Processing HILDA User Training Getting More Information References Appendices Summary of HILDA Survey content, waves 1 to 6 HILDA Survey Instrument Development and Sources Changes made to the data between releases Little and Su method About the HILDA User Manual HILDA Survey Home

SAS program to create wide longitudinal file

/Example SAS program to create unbalanced and balanced wide files/
/Created by Paul Agius 2/11/2006 (Updated by: Nicole Watson)/


/Setting libraries/
libname wave1 'E:\Release 6.0\a60c'; run;
libname wave2 'E:\Release 6.0\b60c'; run;
libname wave3 'E:\Release 6.0\c60c'; run;
libname wave4 'E:\Release 6.0\d60c'; run;
libname wave5 'E:\Release 6.0\e60c'; run;
libname wave6 'E:\Release 6.0\f60c'; run;


/Load the library of formats required for the datasets/
libname library 'E:\Release 6.0\formats'; run;

/Sorting files by xwaveid for merging/
proc sort data = wave1.combined_a60c out=w1;
by xwaveid;
proc sort data = wave2.combined_b60c out=w2;
by xwaveid;
proc sort data = wave3.combined_c60c out=w3;
by xwaveid;
proc sort data = wave4.combined_d60c out=w4;
by xwaveid;
proc sort data = wave5.combined_e60c out=w5;
by xwaveid;
proc sort data = wave6.combined_f60c out=w6;
by xwaveid;
proc sort data = wave6.master_f60c out=master;
by xwaveid;
run;


/Creating unbalanced data file/
data wide_UNBALANCED;
merge w1 w2 w3 w4 w5 w6 master;
by xwaveid;
run;

/Creating balanced data file for interviewed persons/
data wide_BALANCED;
set wide_UNBALANCED;
if	(afstatus = 1 or afstatus = 2) and
	(bfstatus = 1 or bfstatus = 2) and
	(cfstatus = 1 or cfstatus = 2) and
	(dfstatus = 1 or dfstatus = 2) and
	(efstatus = 1 or efstatus = 2) and
	(ffstatus = 1 or ffstatus = 2);
run;

HILDA User Manual