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

STATA program to create wide longitudinal file

*/*Example STATA program to create Unbalanced and Balanced Wide File

Created by: Alison Goode 27/09/06 (Updated by: Nicole Watson)*/

*/**********************************************************************************************************/

*/*Please note - uses all variables. If not all variables required, select and save as a separate file,

then proceed.

Please note: same variables for each consecutive wave NOT next to one another. To organise variables this way. If required, use the AORDER or ORDER command.

***********************************************************************************************************/

set maxvar 15000

*/Before merging the master file and combined files, sort xwaveid in each file and save each of them*/

use "E:\Release 6.0\Masterfile_f60c.dta"

sort xwaveid

merge xwaveid using "E:\Release 6.0\Combined_a60c.dta"

sort xwaveid

drop _merge

merge xwaveid using "E:\Release 6.0\Combined_b60c.dta"

sort xwaveid

drop _merge

merge xwaveid using "E:\Release 6.0\Combined_c60c.dta"

sort xwaveid

drop _merge

merge xwaveid using "E:\Release 6.0\Combined_d60c.dta"

sort xwaveid

drop _merge

merge xwaveid using "E:\Release 6.0\Combined_e60c.dta"

sort xwaveid

drop _merge

merge xwaveid using "E:\Release 6.0\Combined_f60c.dta"

sort xwaveid

drop _merge

save "E:\Release 6.0\Wide-UNBALANCED_6waves.dta"

*/***********************************************************************

*Section 2: To convert to a balanced wide file

n==8864

***********************************************************************/

use "E:\Release 6.0\Wide-UNBALANCED_6waves.dta"

sum afstatus bfstatus cfstatus dfstatus efstatus ffstatus

sort xwaveid

#delimit ;

#delimit cr

sum afstatus bfstatus cfstatus dfstatus efstatus ffstatus

save "E:\Release 6.0\Wide-BALANCED_6waves.dta"

drop _all

top of page

HILDA User Manual

HILDA User Manual

STATA program to create wide longitudinal file