Project

General

Profile

Support #2066 » 1. 2066.log

 
1
----------------------------------------------------------------------------------
2
      name:  <unnamed>
3
       log:  D:\USF\issues\2066\2066.log
4
  log type:  text
5
 opened on:   7 Mar 2024, 21:18:29
6

    
7
. do "C:\Users\rc22989\AppData\Local\Temp\STD2434_000000.tmp"
8

    
9
. /*  Note: The data file produced will be at the individual level and cover all a
10
> ges, irrespective of the variables requested. 
11
>  In this current version of the tool, it is not possible to select variables by 
12
> wave - though you may edit the code below to do so. */
13
. 
14
. /*******************************************************************************
15
> *********
16
> * Sample Code for your request:  f52ac44389924ce3bd30cf41399e35fd       *
17
> ********************************************************************************
18
> *********/
19
. clear all
20

    
21
. set more off
22

    
23
. 
24
. // Replace "where" with the filepath of the working folder (where any temporary 
25
> files created by this programme will be stored)   eg:  c:\ukhls\temp
26
. cd "D:\USF\issues\2066" 
27
D:\USF\issues\2066
28

    
29
. 
30
. // Replace "where" with the folderpath where the data has been downloaded and un
31
> zipped   eg:   c:\ukhls_data\UKDA-6614-stata\stata\stata13_se\ukhls
32
. global ukhls "D:\UKHLS\w13\UKDA-6614-stata\stata\stata13_se\ukhls"
33

    
34
. 
35
. // Replace "where" with the filepath of the folder where you want to store the f
36
> inal dataset produced by this programme.  eg:  c:\ukhls\results
37
. global outputpath "D:\USF\issues\2066"
38

    
39
. 
40
. // The file produced by this programme will be named as below. If you want to ch
41
> ange the name do it here.
42
. local outputfilename "UKHLS_2066"
43

    
44
. 
45
. // By default the data will be extracted from the waves whose letter prefixes ar
46
> e written below, and merged. If you want to a different selection of waves, make
47
>  the change here
48
. local allWaves = "h i j"
49

    
50
. 
51
. // These variables from the indall files will be included. These include some ke
52
> y variables as determined by us PLUS any variables requested by you. 
53
. local indallvars "age_dv country ethn_dv gor_dv hhsize hidp mastat_dv nchild_dv 
54
> pidp pno psnen01_lw psnen01_xw psnen91_lw psnen91_xw psnen99_lw psnen99_xw psnen
55
> ub_lw psnenub_xw psnenui_lw psnenui_xw psnenus_lw psnenus_xw psu racel_dv sex_dv
56
>  strata urban_dv"
57

    
58
. 
59
. // These variables from the indresp files will be included. These include some k
60
> ey variables as determined by us PLUS any variables requested by you. 
61
. local indvars "age_dv country ethn_dv gor_dv hhsize hhtype_dv hidp ind5mus_lw in
62
> d5mus_xw indbd91_lw indbdub_lw indin01_lw indin01_xw indin91_lw indin91_xw indin
63
> 99_lw indin99_xw indinub_lw indinub_xw indinui_lw indinui_xw indinus_lw indinus_
64
> xw indns91_lw indnsub_lw indpxub_lw indpxub_xw indpxui_lw indpxui_xw indpxus_lw 
65
> indpxus_xw indscub_lw indscub_xw indscui_lw indscui_xw indscus_lw indscus_xw jbb
66
> gy jbsat jbsemp jbstat jsboss jspart jssize mastat_dv nchild_dv pidp pno psu rac
67
> el_dv sclfsato sex_dv strata tenure_dv ukborn urban_dv wkaut1 wkaut2 wkaut3 wkau
68
> t4 wkaut5"
69

    
70
. 
71
. // These variables from the child files will be included. These include some key
72
>  variables as determined by us PLUS any variables requested by you. 
73
. local chvars "age_dv chddvub_lw chddvub_xw chddvui_lw chddvui_xw country gor_dv 
74
> hhsize hidp pidp pno psnen01_lw psnen91_lw psnenub_lw psnenub_xw psnenui_lw psne
75
> nui_xw psnenus_lw psnenus_xw psu sex_dv strata urban_dv"
76

    
77
. 
78
. // These variables from the hhresp files will be included. These include some ke
79
> y variables as determined by us PLUS any variables requested by you. 
80
. local hhvars "country fihhmnnet1_dv gor_dv hhden01_xw hhden91_xw hhden99_xw hhde
81
> nub_xw hhdenui_xw hhdenus_xw hhsize hhtype_dv hidp ieqmoecd_dv nkids_dv psu stra
82
> ta tenure_dv urban_dv"
83

    
84
. 
85
. // These variables from the youth files will be included. These include some key
86
>  variables as determined by us PLUS any variables requested by you. 
87
. local youthvars "age_dv country ethn_dv gor_dv hidp pidp pno psu racel_dv sex_dv
88
>  strata urban_dv ythscub_xw ythscui_xw ythscus_xw"
89

    
90
. 
91
. 
92
. ////////////////////////////////////////////////////////////////////////////////
93
> /////////////////////////////////////////////////////////////////////////
94
> // Anything below this line should not be changed! Any changes to the selection 
95
> of variables and waves, and location of folders, should be made above. //
96
. ////////////////////////////////////////////////////////////////////////////////
97
> /////////////////////////////////////////////////////////////////////////
98
> 
99
. // this program returns all variable names with the wave prefix
100
. program define getVars, rclass
101
  1.     version 14.0
102
  2.         if ("`1'" != "") {
103
  3.                 local wavemyvars = " `1'"
104
  4.                 local wavemyvars = subinstr("`wavemyvars'"," "," `2'_",.)
105
  5.                 local wavemyvars = substr("`wavemyvars'",2,.)
106
  6.         }
107
  7.         else local wavemyvars = ""
108
  8.         return local fixedVars "`wavemyvars'"
109
  9. end
110

    
111
. 
112
. // this program to returns  which variables exist in this wave
113
. program define getExistingVars, rclass
114
  1.     version 14.0
115
  2.         local all = ""
116
  3.         foreach var in `1' {
117
  4.                 capture confirm variable `var'
118
  5.                 if !_rc {
119
  6.                         local all = "`all' `var'"
120
  7.                 }
121
  8.         }
122
  9.         return local existingVars "`all'"
123
 10. end  
124

    
125
. 
126
. //loop through each wave
127
. foreach wave in `allWaves' {
128
  2.         // find the wave number
129
.         local waveno=strpos("abcdefghijklmnopqrstuvwxyz","`wave'")
130
  3. 
131
.         // find the wave household vars
132
.         getVars "`hhvars'" `wave'
133
  4.         local wavehhvars = "`r(fixedVars)'"
134
  5.         
135
.         // find the wave individual vars
136
.         getVars "`indvars'" `wave'
137
  6.         local waveindvars = "`r(fixedVars)'"
138
  7.         
139
.         // find the wave all individual vars
140
.         getVars "`indallvars'" `wave'
141
  8.         local waveindallvars = "`r(fixedVars)'"
142
  9.         
143
.         // find the wave child vars
144
.         getVars "`chvars'" `wave'
145
 10.         local wavechvars = "`r(fixedVars)'"
146
 11.         
147
.         // find the wave youth vars
148
.         getVars "`youthvars'" `wave'
149
 12.         local waveyouthvars = "`r(fixedVars)'"
150
 13.         
151
.         // open the the household level file with the required variables
152
.         use "$ukhls/`wave'_hhresp", clear
153
 14.         getExistingVars "`wave'_hidp `wavehhvars'"
154
 15.         keep `r(existingVars)'
155
 16.         
156
.         // if only household variables are required, skip this part and return a
157
> ll households
158
.         if ("`indvars'" != "" || "`chvars'" != "" || "`youthvars'" != "") {
159
 17.                 // if any individual variable is required, first  merge INDAL
160
> L keeping the pipd (and possibly some default variables?), so that other files c
161
> an merge on it.
162
.                 merge 1:m `wave'_hidp using "$ukhls/`wave'_indall"
163
 18.                 drop _merge
164
 19.                 // drop loose households with no individuals
165
.                 drop if (pidp == .)
166
 20.                 
167
.                 // keep only variables that were requested and exist in this wav
168
> e
169
.                 getExistingVars "pidp `wave'_hidp `wavehhvars' `waveindallvars'"
170
 21.                 keep `r(existingVars)'
171
 22.                 
172
.                 // add any requested individual variables
173
.                 if ("`indvars'" != "") {
174
 23.                         merge 1:1 pidp using "$ukhls/`wave'_indresp"
175
 24.                         drop _merge
176
 25.                         // keep only variables that were requested and exist 
177
> in this wave
178
.                         getExistingVars "pidp `wave'_hidp `wavehhvars' `waveindv
179
> ars' `waveyouthvars' `wavechvars' `waveindallvars'"
180
 26.                         keep `r(existingVars)'
181
 27.                 }
182
 28.                 // add any requested youth variables
183
.                 if ("`waveyouthvars'" != "") {
184
 29.                         merge 1:1 pidp using "$ukhls/`wave'_youth"
185
 30.                         drop _merge
186
 31.                         // keep only variables that were requested and exist 
187
> in this wave
188
.                         getExistingVars "pidp `wave'_hidp `wavehhvars' `waveindv
189
> ars' `waveyouthvars' `wavechvars' `waveindallvars'"
190
 32.                         keep `r(existingVars)'
191
 33.                 }
192
 34.                 // add any requested child variables
193
.                 if ("`wavechvars'" != "") {
194
 35.                         merge 1:1 pidp using "$ukhls/`wave'_child"
195
 36.                         drop _merge
196
 37.                         // keep only variables that were requested and exist 
197
> in this wave
198
.                         getExistingVars "pidp `wave'_hidp `wavehhvars' `waveindv
199
> ars' `waveyouthvars' `wavechvars' `waveindallvars'"
200
 38.                         keep `r(existingVars)'
201
 39.                 }
202
 40.         }
203
 41. 
204
.         // create a wave variable
205
.         gen wavename=`waveno'
206
 42. 
207
.         // drop the wave prefix from all variables
208
.         rename `wave'_* *
209
 43. 
210
.         // save the file that was created
211
.         save temp_`wave', replace
212
 44.         
213
. }
214
(Substantive data from responding households)
215
(label h_hrpno already defined)
216
(label h_hrpid already defined)
217
(label h_hhresp_dv already defined)
218
(label h_urban_dv already defined)
219
(label h_gor_dv already defined)
220
(label h_country already defined)
221
(label h_npensioner_dv already defined)
222
(label h_hhsize already defined)
223
(label h_ringfence already defined)
224
(label h_hhlang already defined)
225
(label h_hglitrans already defined)
226
(label h_hglieng already defined)
227
(label h_ivfho already defined)
228
(label h_quarter already defined)
229
(label h_month already defined)
230
(label h_strata already defined)
231
(label h_psu already defined)
232
(label h_hhorig already defined)
233

    
234
    Result                      Number of obs
235
    -----------------------------------------
236
    Not matched                         1,830
237
        from master                         0  (_merge==1)
238
        from using                      1,830  (_merge==2)
239

    
240
    Matched                            54,778  (_merge==3)
241
    -----------------------------------------
242
(0 observations deleted)
243
(label pid already defined)
244
(label h_pno already defined)
245
(label h_hhorig already defined)
246
(label h_memorig already defined)
247
(label h_psu already defined)
248
(label h_strata already defined)
249
(label h_sampst already defined)
250
(label h_month already defined)
251
(label h_quarter already defined)
252
(label h_ivfio already defined)
253
(label h_ioutcome already defined)
254
(label h_sex already defined)
255
(label h_dvage already defined)
256
(label h_birthy already defined)
257
(label h_marstat already defined)
258
(label h_livesp already defined)
259
(label h_livewith already defined)
260
(label h_employ already defined)
261
(label h_lingua already defined)
262
(label h_hgpart already defined)
263
(label h_hgbiom already defined)
264
(label h_hgbiof already defined)
265
(label h_hgadoptm already defined)
266
(label h_hgadoptf already defined)
267
(label h_respm16 already defined)
268
(label h_respf16 already defined)
269
(label h_ringfence already defined)
270
(label h_origadd already defined)
271
(label h_intdatd_if already defined)
272
(label h_intdatm_if already defined)
273
(label h_intdaty_if already defined)
274
(label h_doby_if already defined)
275
(label h_age_if already defined)
276
(label h_ppsex already defined)
277
(label h_fnpid already defined)
278
(label h_mnpid already defined)
279
(label h_pn1pid already defined)
280
(label h_pn1pno already defined)
281
(label h_pn1sex already defined)
282
(label h_pn2pid already defined)
283
(label h_pn2pno already defined)
284
(label h_pn2sex already defined)
285
(label h_pns1pid already defined)
286
(label h_pns1pno already defined)
287
(label h_pns1sex already defined)
288
(label h_pns2pid already defined)
289
(label h_pns2pno already defined)
290
(label h_pns2sex already defined)
291
(label h_grfpid already defined)
292
(label h_grmpid already defined)
293
(label h_hhsize already defined)
294
(label h_ff_ivlolw already defined)
295
(label h_sex_dv already defined)
296
(label h_age_dv already defined)
297
(label h_intdatd_dv already defined)
298
(label h_intdatm_dv already defined)
299
(label h_intdaty_dv already defined)
300
(label h_doby_dv already defined)
301
(label h_pensioner_dv already defined)
302
(label h_marstat_dv already defined)
303
(label h_npn_dv already defined)
304
(label h_npns_dv already defined)
305
(label h_ngrp_dv already defined)
306
(label h_nnsib_dv already defined)
307
(label h_nnssib_dv already defined)
308
(label h_npensioner_dv already defined)
309
(label h_ethn_dv already defined)
310
(label h_racel_dv already defined)
311
(label h_country already defined)
312
(label h_gor_dv already defined)
313
(label h_urban_dv already defined)
314
(label h_hhresp_dv already defined)
315
(label h_agegr5_dv already defined)
316
(label h_agegr10_dv already defined)
317
(label h_agegr13_dv already defined)
318
(label h_livesp_dv already defined)
319
(label h_cohab_dv already defined)
320
(label h_single_dv already defined)
321
(label h_mastat_dv already defined)
322
(label h_hhtype_dv already defined)
323
(label h_buno_dv already defined)
324
(label h_depchl_dv already defined)
325
(label h_nchild_dv already defined)
326
(label h_ndepchl_dv already defined)
327
(label h_adresp15_dv already defined)
328
(label h_respm16_dv already defined)
329
(label h_respf16_dv already defined)
330
(label h_rach16_dv already defined)
331
(label h_hrpid already defined)
332
(label h_hrpno already defined)
333
(label h_ppid already defined)
334
(label h_ppno already defined)
335
(label h_sppid already defined)
336
(label h_sppno already defined)
337
(label h_fnpno already defined)
338
(label h_fnspid already defined)
339
(label h_fnspno already defined)
340
(label h_mnpno already defined)
341
(label h_mnspid already defined)
342
(label h_mnspno already defined)
343
(label h_grfpno already defined)
344
(label h_grmpno already defined)
345
(label h_scflag_dv already defined)
346

    
347
    Result                      Number of obs
348
    -----------------------------------------
349
    Not matched                        17,314
350
        from master                    17,314  (_merge==1)
351
        from using                          0  (_merge==2)
352

    
353
    Matched                            39,294  (_merge==3)
354
    -----------------------------------------
355
(label pid already defined)
356
(label h_pno already defined)
357
(label h_hhorig already defined)
358
(label h_memorig already defined)
359
(label h_psu already defined)
360
(label h_strata already defined)
361
(label h_sampst already defined)
362
(label h_ivfio already defined)
363
(label h_sex already defined)
364
(label h_dvage already defined)
365
(label h_ypsocweb already defined)
366
(label h_ypnetcht already defined)
367
(label h_ypnpal already defined)
368
(label h_ypesta already defined)
369
(label h_ypesti already defined)
370
(label h_ypestb already defined)
371
(label h_ypestj already defined)
372
(label h_ypestc already defined)
373
(label h_ypestk already defined)
374
(label h_ypeste already defined)
375
(label h_ypestf already defined)
376
(label h_ypamar already defined)
377
(label h_ypapar already defined)
378
(label h_ringfence already defined)
379
(label h_intdatd_if already defined)
380
(label h_intdatm_if already defined)
381
(label h_intdaty_if already defined)
382
(label h_doby_if already defined)
383
(label h_age_if already defined)
384
(label h_fnpid already defined)
385
(label h_mnpid already defined)
386
(label h_pn1pid already defined)
387
(label h_pn1pno already defined)
388
(label h_pn1sex already defined)
389
(label h_pn2pid already defined)
390
(label h_pn2pno already defined)
391
(label h_pn2sex already defined)
392
(label h_pns1pid already defined)
393
(label h_pns1pno already defined)
394
(label h_pns1sex already defined)
395
(label h_pns2pid already defined)
396
(label h_pns2pno already defined)
397
(label h_pns2sex already defined)
398
(label h_grfpid already defined)
399
(label h_grmpid already defined)
400
(label h_sex_dv already defined)
401
(label h_age_dv already defined)
402
(label h_intdatd_dv already defined)
403
(label h_intdatm_dv already defined)
404
(label h_intdaty_dv already defined)
405
(label h_doby_dv already defined)
406
(label h_npn_dv already defined)
407
(label h_npns_dv already defined)
408
(label h_ngrp_dv already defined)
409
(label h_nnsib_dv already defined)
410
(label h_nnssib_dv already defined)
411
(label h_ethn_dv already defined)
412
(label h_racel_dv already defined)
413
(label h_country already defined)
414
(label h_gor_dv already defined)
415
(label h_urban_dv already defined)
416
(label h_hhresp_dv already defined)
417
(label h_agegr5_dv already defined)
418
(label h_agegr10_dv already defined)
419
(label h_agegr13_dv already defined)
420
(label h_buno_dv already defined)
421
(label h_adresp15_dv already defined)
422
(label h_rach16_dv already defined)
423
(label h_hrpid already defined)
424
(label h_hrpno already defined)
425
(label h_fnpno already defined)
426
(label h_fnspid already defined)
427
(label h_fnspno already defined)
428
(label h_mnpno already defined)
429
(label h_mnspid already defined)
430
(label h_mnspno already defined)
431
(label h_grfpno already defined)
432
(label h_grmpno already defined)
433

    
434
    Result                      Number of obs
435
    -----------------------------------------
436
    Not matched                        53,336
437
        from master                    53,336  (_merge==1)
438
        from using                          0  (_merge==2)
439

    
440
    Matched                             3,272  (_merge==3)
441
    -----------------------------------------
442
(label h_grmpno already defined)
443
(label h_grfpno already defined)
444
(label h_mnspno already defined)
445
(label h_mnspid already defined)
446
(label h_mnpno already defined)
447
(label h_fnspno already defined)
448
(label h_fnspid already defined)
449
(label h_fnpno already defined)
450
(label h_hrpno already defined)
451
(label h_hrpid already defined)
452
(label h_adresp15_dv already defined)
453
(label h_depchl_dv already defined)
454
(label h_buno_dv already defined)
455
(label h_agegr13_dv already defined)
456
(label h_agegr10_dv already defined)
457
(label h_agegr5_dv already defined)
458
(label h_hhresp_dv already defined)
459
(label h_urban_dv already defined)
460
(label h_gor_dv already defined)
461
(label h_country already defined)
462
(label h_nnssib_dv already defined)
463
(label h_nnsib_dv already defined)
464
(label h_ngrp_dv already defined)
465
(label h_npns_dv already defined)
466
(label h_npn_dv already defined)
467
(label h_doby_dv already defined)
468
(label h_intdaty_dv already defined)
469
(label h_intdatm_dv already defined)
470
(label h_intdatd_dv already defined)
471
(label h_age_dv already defined)
472
(label h_sex_dv already defined)
473
(label h_grmpid already defined)
474
(label h_grfpid already defined)
475
(label h_pns2sex already defined)
476
(label h_pns2pno already defined)
477
(label h_pns2pid already defined)
478
(label h_pns1sex already defined)
479
(label h_pns1pno already defined)
480
(label h_pns1pid already defined)
481
(label h_pn2sex already defined)
482
(label h_pn2pno already defined)
483
(label h_pn2pid already defined)
484
(label h_pn1sex already defined)
485
(label h_pn1pno already defined)
486
(label h_pn1pid already defined)
487
(label h_mnpid already defined)
488
(label h_fnpid already defined)
489
(label h_age_if already defined)
490
(label h_doby_if already defined)
491
(label h_intdaty_if already defined)
492
(label h_intdatm_if already defined)
493
(label h_intdatd_if already defined)
494
(label h_ringfence already defined)
495
(label h_newentrant already defined)
496
(label h_region already defined)
497
(label h_hhlang already defined)
498
(label h_hglitrans already defined)
499
(label h_hglieng already defined)
500
(label h_lingua already defined)
501
(label h_reasref97 already defined)
502
(label h_reasref96 already defined)
503
(label h_reasref32 already defined)
504
(label h_reasref31 already defined)
505
(label h_reasref30 already defined)
506
(label h_reasref26 already defined)
507
(label h_reasref25 already defined)
508
(label h_reasref24 already defined)
509
(label h_reasref23 already defined)
510
(label h_reasref22 already defined)
511
(label h_reasref21 already defined)
512
(label h_reasref20 already defined)
513
(label h_reasref15 already defined)
514
(label h_reasref14 already defined)
515
(label h_reasref13 already defined)
516
(label h_reasref12 already defined)
517
(label h_reasref11 already defined)
518
(label h_reasref10 already defined)
519
(label h_newdad already defined)
520
(label h_newmum already defined)
521
(label h_hgadoptf already defined)
522
(label h_hgadoptm already defined)
523
(label h_hgbioad2 already defined)
524
(label h_hgbioad1 already defined)
525
(label h_hgbiof already defined)
526
(label h_hgbiom already defined)
527
(label h_livpar already defined)
528
(label h_pensioner already defined)
529
(label h_rjrflag already defined)
530
(label h_bedsits already defined)
531
(label h_purposeblt already defined)
532
(label h_housebun already defined)
533
(label h_dwltype already defined)
534
(label h_hhelig already defined)
535
(label h_respemail already defined)
536
(label h_respemailconf already defined)
537
(label h_hhemail already defined)
538
(label h_ctitle already defined)
539
(label h_newper already defined)
540
(label h_curstat already defined)
541
(label h_movctry already defined)
542
(label h_moveyr already defined)
543
(label h_movemth already defined)
544
(label h_lvwhy already defined)
545
(label h_mothr already defined)
546
(label h_stillres already defined)
547
(label h_includ already defined)
548
(label h_dieprisyr already defined)
549
(label h_dieprismth already defined)
550
(label h_more already defined)
551
(label h_ageif already defined)
552
(label h_nebirthy already defined)
553
(label h_nesex already defined)
554
(label h_jnyear already defined)
555
(label h_jnmnth already defined)
556
(label h_rejoinero already defined)
557
(label h_rejoiner already defined)
558
(label h_joiner already defined)
559
(label h_ynew already defined)
560
(label h_prishome already defined)
561
(label h_abspris already defined)
562
(label h_unihome already defined)
563
(label h_absun already defined)
564
(label h_birthy already defined)
565
(label h_dvage already defined)
566
(label h_sex already defined)
567
(label h_ivfho already defined)
568
(label h_ivfio already defined)
569
(label h_quarter already defined)
570
(label h_month already defined)
571
(label h_sampst already defined)
572
(label h_strata already defined)
573
(label h_psu already defined)
574
(label h_memorig already defined)
575
(label h_hhorig already defined)
576
(label h_pno already defined)
577
(label pid already defined)
578

    
579
    Result                      Number of obs
580
    -----------------------------------------
581
    Not matched                        45,059
582
        from master                    45,059  (_merge==1)
583
        from using                          0  (_merge==2)
584

    
585
    Matched                            11,549  (_merge==3)
586
    -----------------------------------------
587
(file temp_h.dta not found)
588
file temp_h.dta saved
589
(Substantive data from responding households)
590
(label i_hhorig already defined)
591
(label i_psu already defined)
592
(label i_strata already defined)
593
(label i_month already defined)
594
(label i_quarter already defined)
595
(label i_ivfho already defined)
596
(label i_hglieng already defined)
597
(label i_hglitrans already defined)
598
(label i_hhlang already defined)
599
(label i_ringfence already defined)
600
(label i_hhsize already defined)
601
(label i_npensioner_dv already defined)
602
(label i_country already defined)
603
(label i_gor_dv already defined)
604
(label i_urban_dv already defined)
605
(label i_hhresp_dv already defined)
606
(label i_hrpid already defined)
607
(label i_hrpno already defined)
608

    
609
    Result                      Number of obs
610
    -----------------------------------------
611
    Not matched                         2,682
612
        from master                         0  (_merge==1)
613
        from using                      2,682  (_merge==2)
614

    
615
    Matched                            50,012  (_merge==3)
616
    -----------------------------------------
617
(0 observations deleted)
618
(label i_scflag_dv already defined)
619
(label i_grmpno already defined)
620
(label i_grfpno already defined)
621
(label i_mnspno already defined)
622
(label i_mnspid already defined)
623
(label i_mnpno already defined)
624
(label i_fnspno already defined)
625
(label i_fnspid already defined)
626
(label i_fnpno already defined)
627
(label i_sppno already defined)
628
(label i_sppid already defined)
629
(label i_ppno already defined)
630
(label i_ppid already defined)
631
(label i_hrpno already defined)
632
(label i_hrpid already defined)
633
(label i_rach16_dv already defined)
634
(label i_respf16_dv already defined)
635
(label i_respm16_dv already defined)
636
(label i_adresp15_dv already defined)
637
(label i_ndepchl_dv already defined)
638
(label i_nchild_dv already defined)
639
(label i_depchl_dv already defined)
640
(label i_buno_dv already defined)
641
(label i_hhtype_dv already defined)
642
(label i_mastat_dv already defined)
643
(label i_single_dv already defined)
644
(label i_cohab_dv already defined)
645
(label i_livesp_dv already defined)
646
(label i_agegr13_dv already defined)
647
(label i_agegr10_dv already defined)
648
(label i_agegr5_dv already defined)
649
(label i_hhresp_dv already defined)
650
(label i_urban_dv already defined)
651
(label i_gor_dv already defined)
652
(label i_country already defined)
653
(label i_racel_dv already defined)
654
(label i_ethn_dv already defined)
655
(label i_npensioner_dv already defined)
656
(label i_nnssib_dv already defined)
657
(label i_nnsib_dv already defined)
658
(label i_ngrp_dv already defined)
659
(label i_npns_dv already defined)
660
(label i_npn_dv already defined)
661
(label i_marstat_dv already defined)
662
(label i_pensioner_dv already defined)
663
(label i_doby_dv already defined)
664
(label i_intdaty_dv already defined)
665
(label i_intdatm_dv already defined)
666
(label i_intdatd_dv already defined)
667
(label i_age_dv already defined)
668
(label i_sex_dv already defined)
669
(label i_ff_ivlolw already defined)
670
(label i_hhsize already defined)
671
(label i_grmpid already defined)
672
(label i_grfpid already defined)
673
(label i_pns2sex already defined)
674
(label i_pns2pno already defined)
675
(label i_pns2pid already defined)
676
(label i_pns1sex already defined)
677
(label i_pns1pno already defined)
678
(label i_pns1pid already defined)
679
(label i_pn2sex already defined)
680
(label i_pn2pno already defined)
681
(label i_pn2pid already defined)
682
(label i_pn1sex already defined)
683
(label i_pn1pno already defined)
684
(label i_pn1pid already defined)
685
(label i_mnpid already defined)
686
(label i_fnpid already defined)
687
(label i_ppsex already defined)
688
(label i_age_if already defined)
689
(label i_doby_if already defined)
690
(label i_intdaty_if already defined)
691
(label i_intdatm_if already defined)
692
(label i_intdatd_if already defined)
693
(label i_origadd already defined)
694
(label i_ringfence already defined)
695
(label i_respf16 already defined)
696
(label i_respm16 already defined)
697
(label i_hgadoptf already defined)
698
(label i_hgadoptm already defined)
699
(label i_hgbiof already defined)
700
(label i_hgbiom already defined)
701
(label i_hgpart already defined)
702
(label i_lingua already defined)
703
(label i_employ already defined)
704
(label i_livewith already defined)
705
(label i_livesp already defined)
706
(label i_marstat already defined)
707
(label i_birthy already defined)
708
(label i_dvage already defined)
709
(label i_sex already defined)
710
(label i_ioutcome already defined)
711
(label i_ivfio already defined)
712
(label i_quarter already defined)
713
(label i_month already defined)
714
(label i_sampst already defined)
715
(label i_strata already defined)
716
(label i_psu already defined)
717
(label i_memorig already defined)
718
(label i_hhorig already defined)
719
(label pid already defined)
720

    
721
    Result                      Number of obs
722
    -----------------------------------------
723
    Not matched                        16,636
724
        from master                    16,636  (_merge==1)
725
        from using                          0  (_merge==2)
726

    
727
    Matched                            36,058  (_merge==3)
728
    -----------------------------------------
729
(label pid already defined)
730
(label i_hhorig already defined)
731
(label i_memorig already defined)
732
(label i_psu already defined)
733
(label i_strata already defined)
734
(label i_sampst already defined)
735
(label i_ivfio already defined)
736
(label i_sex already defined)
737
(label i_dvage already defined)
738
(label i_ringfence already defined)
739
(label i_intdatd_if already defined)
740
(label i_intdatm_if already defined)
741
(label i_intdaty_if already defined)
742
(label i_doby_if already defined)
743
(label i_age_if already defined)
744
(label i_fnpid already defined)
745
(label i_mnpid already defined)
746
(label i_pn1pid already defined)
747
(label i_pn1pno already defined)
748
(label i_pn1sex already defined)
749
(label i_pn2pid already defined)
750
(label i_pn2pno already defined)
751
(label i_pn2sex already defined)
752
(label i_pns1pid already defined)
753
(label i_pns1pno already defined)
754
(label i_pns1sex already defined)
755
(label i_pns2pid already defined)
756
(label i_pns2pno already defined)
757
(label i_pns2sex already defined)
758
(label i_grfpid already defined)
759
(label i_grmpid already defined)
760
(label i_sex_dv already defined)
761
(label i_age_dv already defined)
762
(label i_intdatd_dv already defined)
763
(label i_intdatm_dv already defined)
764
(label i_intdaty_dv already defined)
765
(label i_doby_dv already defined)
766
(label i_npn_dv already defined)
767
(label i_npns_dv already defined)
768
(label i_ngrp_dv already defined)
769
(label i_nnsib_dv already defined)
770
(label i_nnssib_dv already defined)
771
(label i_ethn_dv already defined)
772
(label i_racel_dv already defined)
773
(label i_country already defined)
774
(label i_gor_dv already defined)
775
(label i_urban_dv already defined)
776
(label i_hhresp_dv already defined)
777
(label i_agegr5_dv already defined)
778
(label i_agegr10_dv already defined)
779
(label i_agegr13_dv already defined)
780
(label i_buno_dv already defined)
781
(label i_adresp15_dv already defined)
782
(label i_rach16_dv already defined)
783
(label i_hrpid already defined)
784
(label i_hrpno already defined)
785
(label i_fnpno already defined)
786
(label i_fnspid already defined)
787
(label i_fnspno already defined)
788
(label i_mnpno already defined)
789
(label i_mnspid already defined)
790
(label i_mnspno already defined)
791
(label i_grfpno already defined)
792
(label i_grmpno already defined)
793

    
794
    Result                      Number of obs
795
    -----------------------------------------
796
    Not matched                        49,873
797
        from master                    49,873  (_merge==1)
798
        from using                          0  (_merge==2)
799

    
800
    Matched                             2,821  (_merge==3)
801
    -----------------------------------------
802
(label i_grmpno already defined)
803
(label i_grfpno already defined)
804
(label i_mnspno already defined)
805
(label i_mnspid already defined)
806
(label i_mnpno already defined)
807
(label i_fnspno already defined)
808
(label i_fnspid already defined)
809
(label i_fnpno already defined)
810
(label i_hrpno already defined)
811
(label i_hrpid already defined)
812
(label i_adresp15_dv already defined)
813
(label i_depchl_dv already defined)
814
(label i_buno_dv already defined)
815
(label i_agegr13_dv already defined)
816
(label i_agegr10_dv already defined)
817
(label i_agegr5_dv already defined)
818
(label i_hhresp_dv already defined)
819
(label i_urban_dv already defined)
820
(label i_gor_dv already defined)
821
(label i_country already defined)
822
(label i_nnssib_dv already defined)
823
(label i_nnsib_dv already defined)
824
(label i_ngrp_dv already defined)
825
(label i_npns_dv already defined)
826
(label i_npn_dv already defined)
827
(label i_doby_dv already defined)
828
(label i_intdaty_dv already defined)
829
(label i_intdatm_dv already defined)
830
(label i_intdatd_dv already defined)
831
(label i_age_dv already defined)
832
(label i_sex_dv already defined)
833
(label i_grmpid already defined)
834
(label i_grfpid already defined)
835
(label i_pns2sex already defined)
836
(label i_pns2pno already defined)
837
(label i_pns2pid already defined)
838
(label i_pns1sex already defined)
839
(label i_pns1pno already defined)
840
(label i_pns1pid already defined)
841
(label i_pn2sex already defined)
842
(label i_pn2pno already defined)
843
(label i_pn2pid already defined)
844
(label i_pn1sex already defined)
845
(label i_pn1pno already defined)
846
(label i_pn1pid already defined)
847
(label i_mnpid already defined)
848
(label i_fnpid already defined)
849
(label i_age_if already defined)
850
(label i_doby_if already defined)
851
(label i_intdaty_if already defined)
852
(label i_intdatm_if already defined)
853
(label i_intdatd_if already defined)
854
(label i_ringfence already defined)
855
(label i_instdet_code already defined)
856
(label i_newentrant already defined)
857
(label i_region already defined)
858
(label i_hhlang already defined)
859
(label i_hglitrans already defined)
860
(label i_hglieng already defined)
861
(label i_reasref97 already defined)
862
(label i_reasref96 already defined)
863
(label i_reasref32 already defined)
864
(label i_reasref31 already defined)
865
(label i_reasref30 already defined)
866
(label i_reasref26 already defined)
867
(label i_reasref25 already defined)
868
(label i_reasref24 already defined)
869
(label i_reasref23 already defined)
870
(label i_reasref22 already defined)
871
(label i_reasref21 already defined)
872
(label i_reasref20 already defined)
873
(label i_reasref15 already defined)
874
(label i_reasref14 already defined)
875
(label i_reasref13 already defined)
876
(label i_reasref12 already defined)
877
(label i_reasref11 already defined)
878
(label i_reasref10 already defined)
879
(label i_lingua already defined)
880
(label i_newdad already defined)
881
(label i_newmum already defined)
882
(label i_hgadoptf already defined)
883
(label i_hgadoptm already defined)
884
(label i_hgbioad2 already defined)
885
(label i_hgbioad1 already defined)
886
(label i_hgbiof already defined)
887
(label i_hgbiom already defined)
888
(label i_livpar already defined)
889
(label i_pensioner already defined)
890
(label i_rjrflag already defined)
891
(label i_bedsits already defined)
892
(label i_purposeblt already defined)
893
(label i_housebun already defined)
894
(label i_dwltype already defined)
895
(label i_hhelig already defined)
896
(label i_respemail already defined)
897
(label i_respemailconf already defined)
898
(label i_hhemail already defined)
899
(label i_ctitle already defined)
900
(label i_newper already defined)
901
(label i_curstat already defined)
902
(label i_movctry already defined)
903
(label i_moveyr already defined)
904
(label i_movemth already defined)
905
(label i_lvwhy already defined)
906
(label i_mothr already defined)
907
(label i_stillres already defined)
908
(label i_includ already defined)
909
(label i_dieprisyr already defined)
910
(label i_dieprismth already defined)
911
(label i_more already defined)
912
(label i_ageif already defined)
913
(label i_nebirthy already defined)
914
(label i_nesex already defined)
915
(label i_jnyear already defined)
916
(label i_jnmnth already defined)
917
(label i_rejoinero already defined)
918
(label i_rejoiner already defined)
919
(label i_joiner already defined)
920
(label i_ynew already defined)
921
(label i_prishome already defined)
922
(label i_abspris already defined)
923
(label i_unihome already defined)
924
(label i_absun already defined)
925
(label i_birthy already defined)
926
(label i_dvage already defined)
927
(label i_sex already defined)
928
(label i_ivfho already defined)
929
(label i_ivfio already defined)
930
(label i_quarter already defined)
931
(label i_month already defined)
932
(label i_sampst already defined)
933
(label i_strata already defined)
934
(label i_psu already defined)
935
(label i_memorig already defined)
936
(label i_hhorig already defined)
937
(label pid already defined)
938

    
939
    Result                      Number of obs
940
    -----------------------------------------
941
    Not matched                        42,388
942
        from master                    42,388  (_merge==1)
943
        from using                          0  (_merge==2)
944

    
945
    Matched                            10,306  (_merge==3)
946
    -----------------------------------------
947
(file temp_i.dta not found)
948
file temp_i.dta saved
949
(Substantive data from responding households)
950
(label j_hhorig already defined)
951
(label j_psu already defined)
952
(label j_strata already defined)
953
(label j_month already defined)
954
(label j_quarter already defined)
955
(label j_ivfho already defined)
956
(label j_hglieng already defined)
957
(label j_hglitrans already defined)
958
(label j_hhlang already defined)
959
(label j_ringfence already defined)
960
(label j_hhsize already defined)
961
(label j_npensioner_dv already defined)
962
(label j_country already defined)
963
(label j_gor_dv already defined)
964
(label j_urban_dv already defined)
965
(label j_hhresp_dv already defined)
966
(label j_hrpid already defined)
967
(label j_hrpno already defined)
968

    
969
    Result                      Number of obs
970
    -----------------------------------------
971
    Not matched                         2,316
972
        from master                         0  (_merge==1)
973
        from using                      2,316  (_merge==2)
974

    
975
    Matched                            47,797  (_merge==3)
976
    -----------------------------------------
977
(0 observations deleted)
978
(label j_scflag_dv already defined)
979
(label j_grmpno already defined)
980
(label j_grfpno already defined)
981
(label j_mnspno already defined)
982
(label j_mnspid already defined)
983
(label j_mnpno already defined)
984
(label j_fnspno already defined)
985
(label j_fnspid already defined)
986
(label j_fnpno already defined)
987
(label j_sppno already defined)
988
(label j_sppid already defined)
989
(label j_ppno already defined)
990
(label j_ppid already defined)
991
(label j_hrpno already defined)
992
(label j_hrpid already defined)
993
(label j_rach16_dv already defined)
994
(label j_respf16_dv already defined)
995
(label j_respm16_dv already defined)
996
(label j_adresp15_dv already defined)
997
(label j_ndepchl_dv already defined)
998
(label j_nchild_dv already defined)
999
(label j_depchl_dv already defined)
1000
(label j_buno_dv already defined)
1001
(label j_hhtype_dv already defined)
1002
(label j_mastat_dv already defined)
1003
(label j_single_dv already defined)
1004
(label j_cohab_dv already defined)
1005
(label j_livesp_dv already defined)
1006
(label j_agegr13_dv already defined)
1007
(label j_agegr10_dv already defined)
1008
(label j_agegr5_dv already defined)
1009
(label j_hhresp_dv already defined)
1010
(label j_urban_dv already defined)
1011
(label j_gor_dv already defined)
1012
(label j_country already defined)
1013
(label j_racel_dv already defined)
1014
(label j_ethn_dv already defined)
1015
(label j_npensioner_dv already defined)
1016
(label j_nnssib_dv already defined)
1017
(label j_nnsib_dv already defined)
1018
(label j_ngrp_dv already defined)
1019
(label j_npns_dv already defined)
1020
(label j_npn_dv already defined)
1021
(label j_marstat_dv already defined)
1022
(label j_pensioner_dv already defined)
1023
(label j_doby_dv already defined)
1024
(label j_intdaty_dv already defined)
1025
(label j_intdatm_dv already defined)
1026
(label j_intdatd_dv already defined)
1027
(label j_age_dv already defined)
1028
(label j_sex_dv already defined)
1029
(label j_ff_ivlolw already defined)
1030
(label j_hhsize already defined)
1031
(label j_grmpid already defined)
1032
(label j_grfpid already defined)
1033
(label j_pns2sex already defined)
1034
(label j_pns2pno already defined)
1035
(label j_pns2pid already defined)
1036
(label j_pns1sex already defined)
1037
(label j_pns1pno already defined)
1038
(label j_pns1pid already defined)
1039
(label j_pn2sex already defined)
1040
(label j_pn2pno already defined)
1041
(label j_pn2pid already defined)
1042
(label j_pn1sex already defined)
1043
(label j_pn1pno already defined)
1044
(label j_pn1pid already defined)
1045
(label j_mnpid already defined)
1046
(label j_fnpid already defined)
1047
(label j_ppsex already defined)
1048
(label j_age_if already defined)
1049
(label j_doby_if already defined)
1050
(label j_intdaty_if already defined)
1051
(label j_intdatm_if already defined)
1052
(label j_intdatd_if already defined)
1053
(label j_origadd already defined)
1054
(label j_ringfence already defined)
1055
(label j_respf16 already defined)
1056
(label j_respm16 already defined)
1057
(label j_hgadoptf already defined)
1058
(label j_hgadoptm already defined)
1059
(label j_hgbiof already defined)
1060
(label j_hgbiom already defined)
1061
(label j_hgpart already defined)
1062
(label j_lingua already defined)
1063
(label j_employ already defined)
1064
(label j_livewith already defined)
1065
(label j_livesp already defined)
1066
(label j_marstat already defined)
1067
(label j_birthy already defined)
1068
(label j_dvage already defined)
1069
(label j_sex already defined)
1070
(label j_ioutcome already defined)
1071
(label j_ivfio already defined)
1072
(label j_quarter already defined)
1073
(label j_month already defined)
1074
(label j_sampst already defined)
1075
(label j_strata already defined)
1076
(label j_psu already defined)
1077
(label j_memorig already defined)
1078
(label j_hhorig already defined)
1079
(label pid already defined)
1080

    
1081
    Result                      Number of obs
1082
    -----------------------------------------
1083
    Not matched                        15,794
1084
        from master                    15,794  (_merge==1)
1085
        from using                          0  (_merge==2)
1086

    
1087
    Matched                            34,319  (_merge==3)
1088
    -----------------------------------------
1089
(label pid already defined)
1090
(label j_hhorig already defined)
1091
(label j_memorig already defined)
1092
(label j_psu already defined)
1093
(label j_strata already defined)
1094
(label j_sampst already defined)
1095
(label j_ivfio already defined)
1096
(label j_sex already defined)
1097
(label j_dvage already defined)
1098
(label j_ypsocweb already defined)
1099
(label j_ypnetcht already defined)
1100
(label j_ypnpal already defined)
1101
(label j_ypesta already defined)
1102
(label j_ypesti already defined)
1103
(label j_ypestb already defined)
1104
(label j_ypestj already defined)
1105
(label j_ypestc already defined)
1106
(label j_ypestk already defined)
1107
(label j_ypeste already defined)
1108
(label j_ypestf already defined)
1109
(label j_ypamar already defined)
1110
(label j_ypapar already defined)
1111
(label j_ringfence already defined)
1112
(label j_intdatd_if already defined)
1113
(label j_intdatm_if already defined)
1114
(label j_intdaty_if already defined)
1115
(label j_doby_if already defined)
1116
(label j_age_if already defined)
1117
(label j_fnpid already defined)
1118
(label j_mnpid already defined)
1119
(label j_pn1pid already defined)
1120
(label j_pn1pno already defined)
1121
(label j_pn1sex already defined)
1122
(label j_pn2pid already defined)
1123
(label j_pn2pno already defined)
1124
(label j_pn2sex already defined)
1125
(label j_pns1pid already defined)
1126
(label j_pns1pno already defined)
1127
(label j_pns1sex already defined)
1128
(label j_pns2pid already defined)
1129
(label j_pns2pno already defined)
1130
(label j_pns2sex already defined)
1131
(label j_grfpid already defined)
1132
(label j_grmpid already defined)
1133
(label j_sex_dv already defined)
1134
(label j_age_dv already defined)
1135
(label j_intdatd_dv already defined)
1136
(label j_intdatm_dv already defined)
1137
(label j_intdaty_dv already defined)
1138
(label j_doby_dv already defined)
1139
(label j_npn_dv already defined)
1140
(label j_npns_dv already defined)
1141
(label j_ngrp_dv already defined)
1142
(label j_nnsib_dv already defined)
1143
(label j_nnssib_dv already defined)
1144
(label j_ethn_dv already defined)
1145
(label j_racel_dv already defined)
1146
(label j_country already defined)
1147
(label j_gor_dv already defined)
1148
(label j_urban_dv already defined)
1149
(label j_hhresp_dv already defined)
1150
(label j_agegr5_dv already defined)
1151
(label j_agegr10_dv already defined)
1152
(label j_agegr13_dv already defined)
1153
(label j_buno_dv already defined)
1154
(label j_adresp15_dv already defined)
1155
(label j_rach16_dv already defined)
1156
(label j_hrpid already defined)
1157
(label j_hrpno already defined)
1158
(label j_fnpno already defined)
1159
(label j_fnspid already defined)
1160
(label j_fnspno already defined)
1161
(label j_mnpno already defined)
1162
(label j_mnspid already defined)
1163
(label j_mnspno already defined)
1164
(label j_grfpno already defined)
1165
(label j_grmpno already defined)
1166

    
1167
    Result                      Number of obs
1168
    -----------------------------------------
1169
    Not matched                        47,607
1170
        from master                    47,607  (_merge==1)
1171
        from using                          0  (_merge==2)
1172

    
1173
    Matched                             2,506  (_merge==3)
1174
    -----------------------------------------
1175
(label j_grmpno already defined)
1176
(label j_grfpno already defined)
1177
(label j_mnspno already defined)
1178
(label j_mnspid already defined)
1179
(label j_mnpno already defined)
1180
(label j_fnspno already defined)
1181
(label j_fnspid already defined)
1182
(label j_fnpno already defined)
1183
(label j_hrpno already defined)
1184
(label j_hrpid already defined)
1185
(label j_adresp15_dv already defined)
1186
(label j_depchl_dv already defined)
1187
(label j_buno_dv already defined)
1188
(label j_agegr13_dv already defined)
1189
(label j_agegr10_dv already defined)
1190
(label j_agegr5_dv already defined)
1191
(label j_hhresp_dv already defined)
1192
(label j_urban_dv already defined)
1193
(label j_gor_dv already defined)
1194
(label j_country already defined)
1195
(label j_nnssib_dv already defined)
1196
(label j_nnsib_dv already defined)
1197
(label j_ngrp_dv already defined)
1198
(label j_npns_dv already defined)
1199
(label j_npn_dv already defined)
1200
(label j_doby_dv already defined)
1201
(label j_intdaty_dv already defined)
1202
(label j_intdatm_dv already defined)
1203
(label j_intdatd_dv already defined)
1204
(label j_age_dv already defined)
1205
(label j_sex_dv already defined)
1206
(label j_grmpid already defined)
1207
(label j_grfpid already defined)
1208
(label j_pns2sex already defined)
1209
(label j_pns2pno already defined)
1210
(label j_pns2pid already defined)
1211
(label j_pns1sex already defined)
1212
(label j_pns1pno already defined)
1213
(label j_pns1pid already defined)
1214
(label j_pn2sex already defined)
1215
(label j_pn2pno already defined)
1216
(label j_pn2pid already defined)
1217
(label j_pn1sex already defined)
1218
(label j_pn1pno already defined)
1219
(label j_pn1pid already defined)
1220
(label j_mnpid already defined)
1221
(label j_fnpid already defined)
1222
(label j_age_if already defined)
1223
(label j_doby_if already defined)
1224
(label j_intdaty_if already defined)
1225
(label j_intdatm_if already defined)
1226
(label j_intdatd_if already defined)
1227
(label j_ringfence already defined)
1228
(label j_instdet_code already defined)
1229
(label j_newentrant already defined)
1230
(label j_region already defined)
1231
(label j_hhlang already defined)
1232
(label j_hglitrans already defined)
1233
(label j_hglieng already defined)
1234
(label j_reasref97 already defined)
1235
(label j_reasref96 already defined)
1236
(label j_reasref32 already defined)
1237
(label j_reasref31 already defined)
1238
(label j_reasref30 already defined)
1239
(label j_reasref26 already defined)
1240
(label j_reasref25 already defined)
1241
(label j_reasref24 already defined)
1242
(label j_reasref23 already defined)
1243
(label j_reasref22 already defined)
1244
(label j_reasref21 already defined)
1245
(label j_reasref20 already defined)
1246
(label j_reasref15 already defined)
1247
(label j_reasref14 already defined)
1248
(label j_reasref13 already defined)
1249
(label j_reasref12 already defined)
1250
(label j_reasref11 already defined)
1251
(label j_reasref10 already defined)
1252
(label j_lingua already defined)
1253
(label j_newdad already defined)
1254
(label j_newmum already defined)
1255
(label j_hgadoptf already defined)
1256
(label j_hgadoptm already defined)
1257
(label j_hgbioad2 already defined)
1258
(label j_hgbioad1 already defined)
1259
(label j_hgbiof already defined)
1260
(label j_hgbiom already defined)
1261
(label j_livpar already defined)
1262
(label j_pensioner already defined)
1263
(label j_rjrflag already defined)
1264
(label j_bedsits already defined)
1265
(label j_purposeblt already defined)
1266
(label j_housebun already defined)
1267
(label j_dwltype already defined)
1268
(label j_hhelig already defined)
1269
(label j_respemail already defined)
1270
(label j_respemailconf already defined)
1271
(label j_hhemail already defined)
1272
(label j_ctitle already defined)
1273
(label j_newper already defined)
1274
(label j_curstat already defined)
1275
(label j_movctry already defined)
1276
(label j_moveyr already defined)
1277
(label j_movemth already defined)
1278
(label j_lvwhy already defined)
1279
(label j_mothr already defined)
1280
(label j_stillres already defined)
1281
(label j_includ already defined)
1282
(label j_dieprisyr already defined)
1283
(label j_dieprismth already defined)
1284
(label j_more already defined)
1285
(label j_ageif already defined)
1286
(label j_nebirthy already defined)
1287
(label j_nesex already defined)
1288
(label j_jnyear already defined)
1289
(label j_jnmnth already defined)
1290
(label j_rejoinero already defined)
1291
(label j_rejoiner already defined)
1292
(label j_joiner already defined)
1293
(label j_ynew already defined)
1294
(label j_prishome already defined)
1295
(label j_abspris already defined)
1296
(label j_unihome already defined)
1297
(label j_absun already defined)
1298
(label j_birthy already defined)
1299
(label j_dvage already defined)
1300
(label j_sex already defined)
1301
(label j_ivfho already defined)
1302
(label j_ivfio already defined)
1303
(label j_quarter already defined)
1304
(label j_month already defined)
1305
(label j_sampst already defined)
1306
(label j_strata already defined)
1307
(label j_psu already defined)
1308
(label j_memorig already defined)
1309
(label j_hhorig already defined)
1310
(label pid already defined)
1311

    
1312
    Result                      Number of obs
1313
    -----------------------------------------
1314
    Not matched                        40,554
1315
        from master                    40,554  (_merge==1)
1316
        from using                          0  (_merge==2)
1317

    
1318
    Matched                             9,559  (_merge==3)
1319
    -----------------------------------------
1320
(file temp_j.dta not found)
1321
file temp_j.dta saved
1322

    
1323
. 
1324
. // open the file for the first wave (wave a_)
1325
. local firstWave = substr("`allWaves'", 1, 1)
1326

    
1327
. use temp_`firstWave', clear
1328
(Substantive data from responding households)
1329

    
1330
. 
1331
. // loop through the remaining waves appending them in the long format
1332
. local remainingWaves = substr("`allWaves'", 3, .)
1333

    
1334
. 
1335
. foreach w in `remainingWaves' {
1336
  2.         // append the files for the second wave onwards
1337
.         append using temp_`w'
1338
  3. }
1339

    
1340
. 
1341
. // check how many observations are available from each wave
1342
. tab wavename
1343

    
1344
   wavename |      Freq.     Percent        Cum.
1345
------------+-----------------------------------
1346
          8 |     56,608       35.51       35.51
1347
          9 |     52,694       33.05       68.56
1348
         10 |     50,113       31.44      100.00
1349
------------+-----------------------------------
1350
      Total |    159,415      100.00
1351

    
1352
. 
1353
. // move pidp to the beginning of the file
1354
. order pidp, first
1355

    
1356
. 
1357
. // save the long file
1358
. save "$outputpath/`outputfilename'", replace
1359
file D:\USF\issues\2066/UKHLS_2066.dta saved
1360

    
1361
. 
1362
. // erase temporary files
1363
. foreach w in `allWaves' {
1364
  2.         erase temp_`w'.dta
1365
  3. }
1366

    
1367
. 
1368
end of do-file
1369

    
1370
. log close
1371
      name:  <unnamed>
1372
       log:  D:\USF\issues\2066\2066.log
1373
  log type:  text
1374
 closed on:   7 Mar 2024, 21:23:18
1375
----------------------------------------------------------------------------------
(6-6/6)