/* *********************************************************************** */
/* Purpose: SPSS program to create unbalanced and balanced wide files      */
/************************************************************************* */
/* All of these files are supplied in the SPSS zip sorted by xwaveid */
match files
  file='X:\HILDA\Release 140\Files\SPSS 140c\Master n140c.sav'  /in=inmaster
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined a140c.sav'/in=inwave1
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined b140c.sav'/in=inwave2
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined c140c.sav'/in=inwave3
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined d140c.sav'/in=inwave4
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined e140c.sav'/in=inwave5
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined f140c.sav'/in=inwave6
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined g140c.sav'/in=inwave7
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined h140c.sav'/in=inwave8
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined i140c.sav'/in=inwave9
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined j140c.sav'/in=inwave10
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined k140c.sav'/in=inwave11
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined l140c.sav'/in=inwave12
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined m140c.sav'/in=inwave13
 /file='X:\HILDA\Release 140\Files\SPSS 140c\Combined n140c.sav'/in=inwave14
 /by xwaveid.
/* if you save the file here you get an unbalanced (enumerated) panel with 38510 cases.*/
/* This includes the wave 11 top-up sample which is excluded in the balanced panels below */
exe.
show n.
/* Option 1: balanced enumerated panel - enumerated in all 14 waves: 9457 cases */
select if (ahgenum) and (bhgenum) and (chgenum) and (dhgenum) and (ehgenum) and (fhgenum) 
      and (ghgenum) and (hhgenum) and (ihgenum) and (jhgenum) and (khgenum) and (lhgenum)
      and (mhgenum) and (nhgenum).
save outfile='c:\temp\w1w14enum.sav'.
show n.
/* Option 2: balanced interview panel - interviewed in all 14 waves: 6547 cases */
select if (ahgint) and (bhgint) and (chgint) and (dhgint) and (ehgint) and (fhgint) 
      and (ghgint) and (hhgint) and (ihgint) and (jhgint) and (khgint) and (lhgint)
      and (mhgint) and (nhgint).
save outfile='c:\temp\w1w14int.sav'.
show n.