Understanding Society User Support: Issueshttps://iserredex.essex.ac.uk/support/https://iserredex.essex.ac.uk/support/support/favicon.ico?15995719382013-06-12T17:07:43ZUnderstanding Society User Support
Redmine Understanding Society User Support - Support #158 (Closed): Derived income variables in the BHPShttps://iserredex.essex.ac.uk/support/issues/1582013-06-12T17:07:43ZSara Watson
<p>Hi,</p>
<p>We've noticed some discrepancies in the construction of derived income variables. Any thoughts would be most appreciated.</p>
<p>1. According to the User's Manual, household income fihhyr sums income from fiyr. However, we find a sizable difference between the two measures.</p>
<p>gen newinc=fiyr if fiyr>=0 // Exclude missings, proxies, etc<br />bysort hid: egen check_fihhyr = sum(newinc) // Summing household income from fiyr<br />gen diff_fihhyr=check_fihhyr-fihhyr if fihhyr>=0</p>
<p>*This is most easily seen when we focus on single-member households:<br />bysort hid : egen count_hid=count(hid)<br />gen diff_fihhyr_singletons=newinc-fihhyr if count_hid==1 & fihhyr>=0</p>
<p>The difference between the two measures is most often zero, but for 10 percent of obs is negative. These differences can be quite large, so that the mean is over 3000 pounds.</p>
<p>Do you have any advice? Is there anything we are missing--for instance, is there an additional income source that fihhyr includes? Does it use imputation from across waves?</p>
<p>2. According to the User's Manual, fiyrb sums income from ficodes 1,5,6,16-22,31-41 (dividing joint income by two when appropriate). </p>
<pre><code>a) It seems that other benefits outside this list of ficodes have been included in fiyrb. The ones we have noticed are the job seeker's allowance and the child tax credit. Is this correct, and are there other benefits summed in fiyrb?</code></pre>
<pre><code>b) There are several obs, most of which arise in wave 6, for which fiyrb does not count certain benefits. For instance, to implement the following code we have previously used ficode to total each type of benefit income (dividing joint income by 2 when flagged).</code></pre>
<p>local fiyrblist pensioner widowpension widowmom severe_disab invalid_pens ind_injury attendance mobility_allow invalidcare wardisability /*<br />*/ ub_is incomesupport ub ni_sickness childben loneparentben_a wf_taxcredit maternity housingben counciltax_ben other_stateben <br />gen tag2=.<br />foreach var of local firyblist {<br /> replace tag2=1 if fiyrb<`var'-1 & !missing(`var') & fiyrb>=0<br />}</p>
<p>This is a stark test, as it only counts cases when the total fiyrb is less than any given component, but even here we flag 169 obs. Is there anything we are missing here---for instance, is there an additional rule that determines whether fiyrb will include a certain income source?</p>
<p>3. Are we correct in our perception that fiyr sums fiyrl and fiyrnl where both are non-missing?</p>
<p>Here we can reproduce fiyr almost exactly with the following:<br />gen check_fiyr=fiyrl+fiyrnl if fiyrl>=0 & fiyrnl>=0 <br />gen tag=1 if (fiyr-1>check_fiyr | fiyr+1<check_fiyr) & !missing(fiyr) & !missing(check_fiyr) // Allows for rounding error</p>
<p>The sole exception (tag==1) is an individual in wave 3 whose nonlabor income is for some reason not<br />included in fiyr.</p>
<p>Thanks so much for your help with these questions!</p>
<p>All the best,<br />Sara Watson<br />--------------------------------------<br />Dr. Sara Watson<br />Assistant Professor<br />Department of Political Science, The Ohio State University<br />2140 Derby Hall, 154 North Oval Mall<br />Columbus, OH 43210-1373</p>
<p><a class="email" href="mailto:watson.584@osu.edu">watson.584@osu.edu</a>; <a class="email" href="mailto:watson.584@polisci.osu.edu">watson.584@polisci.osu.edu</a></p> Understanding Society User Support - Support #152 (Closed): Question about ficodehttps://iserredex.essex.ac.uk/support/issues/1522013-05-24T15:22:58ZSara Watson
<p>Hello,</p>
<p>I have a question about the ficode variable in the UKHLS. The codebook says that if a respondent reports receiving the "in work tax credit for lone parents", then ficode==36. And yet when I tab the variable, there is no ficode==36 listed for either wave 1 or wave 2. I did find ficode=35 and 37, but not 36. Am I doing something wrong? And if not, is there a way this information can be recovered?</p>
<p>Thanks for your help.</p>
<p>All the best,<br />Sara Watson<br />---------------------------------------<br />Dr. Sara Watson<br />Assistant Professor<br />Department of Political Science, The Ohio State University<br />2140 Derby Hall, 154 North Oval Mall<br />Columbus, OH 43210-1373</p>
<p><a class="email" href="mailto:watson.584@osu.edu">watson.584@osu.edu</a>; <a class="email" href="mailto:watson.584@polisci.osu.edu">watson.584@polisci.osu.edu</a></p>