https://iserredex.essex.ac.uk/support/https://iserredex.essex.ac.uk/support/support/favicon.ico?15995719382020-02-21T21:18:30ZUnderstanding Society User SupportUnderstanding Society User Support - Support #1316: birthyear of all first born child and vocational qualificaitonshttps://iserredex.essex.ac.uk/support/issues/1316?journal_id=49412020-02-21T21:18:30ZStephanie Autys.auty@essex.ac.uk
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Feedback</i></li><li><strong>Assignee</strong> set to <i>Maria Petrillo</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>60</i></li></ul><p>Dear Maria,</p>
<p>It is not necessary to change mnpid to mnpid_bh, as all individuals from BHPS now have a pidp in the harmonised data. What I do notice you will need to change in Alita's code is every time is says `w' you will need to write b`w'. Also, as the files are now downloaded into separate folders for each wave, you will either need to edit the file path to take account of this (using strpos) or putting all the files into one folder.</p>
<p>hiqual_dv is the best qualification variable to use and is available for all waves.</p>
<p>We have collected the data for isced in Wave 9, but it is not yet derived. You would be able to derive it yourself but all the information needed is not available in the waves before Wave 9.</p>
<p>Best wishes,<br />Stephanie</p> Understanding Society User Support - Support #1316: birthyear of all first born child and vocational qualificaitonshttps://iserredex.essex.ac.uk/support/issues/1316?journal_id=49422020-02-21T21:18:36ZStephanie Autys.auty@essex.ac.uk
<ul><li><strong>Private</strong> changed from <i>Yes</i> to <i>No</i></li></ul> Understanding Society User Support - Support #1316: birthyear of all first born child and vocational qualificaitonshttps://iserredex.essex.ac.uk/support/issues/1316?journal_id=49442020-02-22T09:44:17ZMaria Petrillo
<ul></ul><p>Dear Stephanie<br />thank you for your quick reply. However, I have already tried to change Alina's code by adding b before `w' (and I have already put all the files into one folder), but when I run the do file I have a problem with the variable "bm_birthy". In particular, the commands generate a variable "bm_birthy" with all missing values. So i end up having no information on the year of birth of the mother.</p>
<p>For how it concern hiqual_dv I don't understand how to derive the vocational background from this variable. If I am not wrong hiqual_dv is a categorical variable with the following categories:<br /><del>Degree<br />-Other higher<br />-A level etc<br /></del> GSCE etc<br />- Other qual<br />-No qual</p>
<p>which does not tell me much about the vocational background. Ideally, I would like to derive a variable like qfvoc or isced in the HBPS.</p>
<p>Any suggestions will be very much appreciated.</p>
<p>Thank you,<br />Maria</p> Understanding Society User Support - Support #1316: birthyear of all first born child and vocational qualificaitonshttps://iserredex.essex.ac.uk/support/issues/1316?journal_id=49512020-03-02T18:15:20ZStephanie Autys.auty@essex.ac.uk
<ul></ul><p>Dear Maria,</p>
<p>We have w_qfvoc1-16 in Understanding Society, which could be used to derive a variable similar to bw_qfvoc, but please check the question wording, universe and available responses are close enough for your purposes.</p>
<p>I'm not sure what could cause the problem you have with bw_birthy. Does it only happen in Wave 13?</p>
<p>Best wishes,<br />Stephanie</p> Understanding Society User Support - Support #1316: birthyear of all first born child and vocational qualificaitonshttps://iserredex.essex.ac.uk/support/issues/1316?journal_id=49532020-03-09T15:11:02ZMaria Petrillo
<ul></ul><p>Dear Stephanie,<br />thank you for your reply.<br />I tried to generate a variable from w_qfvoc1-16 and it worked. I was able to create a dummy variable equal to 1 if the individual has a vocational qualification, zero otherwise. Do you have any suggestions on which variable should be compared with this new generated variable in order to generate another variable that takes value one whether the HIGHEST qualification achieve by the individual is a vocational qualification rather than academic?</p>
<p>For how it concerns the year of birth for children, I don't think I can use the variable mnpid for the Harmonized BHPS since only mnpid_bh is available in indall.dta. However, while mnpid in the Understanding Society is the natural mother pidp, mnpid_bh (HBHPS) is the natural mother pid. The latter should be the personal identifier, while the pidp is the cross-wave identifier. I think this is the reason why Alina's code is not working with the harmonized version (My problem with bw_birthy was for all the waves).<br />So probably instead of using pidp w_birthy and mnpid as for the Understanding Society, for the Harmonized BHPS i should use pid w_birthy and mnpid_bh, doing the following (I tried to keep even the pidp variable so that I would be able to match the new dta with indiresp.dta.):</p>
<p>foreach w in a b c d e f g h i j k l m n o p q r {<br /> use pidp pid b`w'_birthy b`w'_mnpid_bh using b`w'_indall, clear<br /> save temp, replace<br /> use temp, clear<br /> keep pid b`w'_mnpid_bh<br /> keep if b`w'_mnpid_bh>0 & b`w'_mnpid_bh<.<br /> rename pid kpid<br /> rename b`w'_mnpid_bh pid</p>
<pre><code>merge m:1 pid using temp, keepus(b`w'_birthy pidp)<br /> drop if _m==2<br /> drop _m</code></pre>
<pre><code>rename b`w'_birthy b`w'_mbirthy<br /> keep pid kpid b`w'_mbirthy<br /> rename pid b`w'_mnpid_bh<br /> rename kpid pid<br /> merge 1:1 pid using temp<br /> drop if _m==2<br /> drop _m</code></pre>
<pre><code>rename b`w'_birthy b`w'_kbirthy<br /> rename pid kpid<br /> rename b`w'_mnpid_bh pid<br /> save b`w'_mother_child, replace<br />}</code></pre>
<p>Any comments are more than appreciated.</p>
<p>Thank you very much</p>
<p>Maria</p> Understanding Society User Support - Support #1316: birthyear of all first born child and vocational qualificaitonshttps://iserredex.essex.ac.uk/support/issues/1316?journal_id=49542020-03-09T17:39:09ZStephanie Autys.auty@essex.ac.uk
<ul><li><strong>% Done</strong> changed from <i>60</i> to <i>70</i></li></ul><p>Dear Maria,</p>
<p>You may want to compare your created variable or w_qfvoc1-16 with either w_hiqual_dv or w_qfhigh_dv, but you will need to investigate which vocational qualifications are a higher qualification than the academic qualifications.</p>
<p>I see now that the family identifiers have not yet been harmonised, so yes, using pid and bw_mnpid_bh is one solution. You could also use xwavedat (or indall within a wave) to merge the mother's pidp using the mother's pid, if you wanted to work with pidp.</p>
<p>Are you now getting results that make sense for the birth year?</p>
<p>Best wishes,<br />Stephanie</p> Understanding Society User Support - Support #1316: birthyear of all first born child and vocational qualificaitonshttps://iserredex.essex.ac.uk/support/issues/1316?journal_id=64582021-10-13T10:59:17ZUnderstanding Society User Support Teamusersupport@understandingsociety.ac.uk
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Resolved</i></li><li><strong>Assignee</strong> deleted (<del><i>Maria Petrillo</i></del>)</li><li><strong>% Done</strong> changed from <i>70</i> to <i>100</i></li></ul>