Understanding Society User Support: Issueshttps://iserredex.essex.ac.uk/support/https://iserredex.essex.ac.uk/support/support/favicon.ico?15995719382019-03-23T15:56:49ZUnderstanding Society User Support
Redmine Understanding Society User Support - Support #1171 (Resolved): How to match information of any tw...https://iserredex.essex.ac.uk/support/issues/11712019-03-23T15:56:49ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Stephanie, <br />the handout to the question about matching info of any two hh members states that I quote: "In this example we will be using data from Wave 1, but the method will work with data from any wave."</p>
<p>Question: Does the method also apply to an analysis across waves including all waves?</p>
<p>The reason I ask this is because if I look at my wage regression I have an estimation sample for married women with roughly 28,000 married females (given the control variables). When I follow the method described in the handout (example 7) and use the same control variables, I only have roughly 19,000 married (matched) females in my wage regression. I seemed to have lost quite a number of observations through the matching process.</p>
<p>Thanks.</p>
<p>I appreciate your thoughts on this issue.</p> Understanding Society User Support - Support #1155 (Resolved): What variables to use to construct...https://iserredex.essex.ac.uk/support/issues/11552019-03-06T10:58:36ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Hello Stephanie,</p>
<p>I want to construct hourly wages with w_paygu_dv which I assume include payments for overtime per month. For hours worked I got:<br />w_jbhrs, w_jbot (overtime in normal week which is paid and unpaid I assume), and w_jbotpaid (which is paid overtime). <br />If paygu_dv includes paid overtime, I guess the cleanest use would be adding up jbhrs and jbot? <br />Does jbot include the self_employed? <br />A short reply would be terrific. <br />Thanks. <br />Nico</p> Understanding Society User Support - Support #1124 (Resolved): A binary variable for children und...https://iserredex.essex.ac.uk/support/issues/11242018-12-26T11:51:39ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Alita, <br />I hope you had a good holiday season. When you get the chance please help me with this one. I would like to define a binary variable equal to one if there is a child or more than one under the age of seven in a given household. My main data set consists of female characteristics and the characteristics of her husband or spouse. Essentially, I have only wives in my main dataset with their characteristics plus their spouses'. <br />I guess I must look at the w_child files to get the pidp of the child, the birthy of the child and the mnpid, which is the identification of the mother. Now the fun starts. How do I match or merge the information from the w_child files to my main file with wives' pidp only? <br />Once again I would highly appreciate your help.</p>
<p>Best wishes.</p>
<p>Nico</p> Understanding Society User Support - Support #1011 (Resolved): merging main dataset (6933) with l...https://iserredex.essex.ac.uk/support/issues/10112018-07-26T19:00:48ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Hello Alita,</p>
<p>hope you are fine. I do have a question with regard to merging the above files. It is my understanding that in the districts (6666) data set I have household number and the variable for district in each wave file (in addition I generate the wave variable for a through g). I am not sure how to proceed. Do I produce and append all seven waves for the district data set first and then merge it with the main data set or do I merge each district data set (of each wave) individually with my main data set? If I appended all seven waves of the district data set first, I would suggest doing the following:</p>
<p>merge m:1 hidp wave using districts_appended_a-g</p>
<p>Now the thing that is not clear to me is that if I have two people with two different pidp's living in the same household (hence sharing the same hidp) in a given wave, how can they be uniquely identified in the using data set?</p>
<p>Once again, I would highly appreciate your suggestions.</p>
<p>Best wishes.</p>
<p>Nico</p> Understanding Society User Support - Support #1010 (Resolved): Cognition tests from wave 3 planne...https://iserredex.essex.ac.uk/support/issues/10102018-07-26T13:23:55ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Hello user support,</p>
<p>I am hoping to get data on cognition for the subsample introduced in wave 6 (IEMB). For that purpose, I am wondering if the planned cognition testing for wave 9 will be taking place and if it will cover the IEMB as well.</p>
<p>Thanks a lot for your support.</p> Understanding Society User Support - Support #947 (Resolved): the birthyear of all children (in a...https://iserredex.essex.ac.uk/support/issues/9472018-04-03T11:23:40ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Hi Alita,</p>
<p>this is my last question for you for a while, promised. I would like to get your general take on it though. It somewhat relates to my other open issue which you are working on.<br />I would like to have the number of all children born by a given female respondent (my open issue for which you are currently checking my suggestion) and in addition their birthyear.<br />I found this: <br /><16 in household: w_birthy from w_child <br />out of household: a_lchdoby, f_lchdoby (year of birth of non-resident biological child) from w_natchild <br />Now I would like to generate a variable call it birthyear_1_dv for first kid for all female respondents for all seven waves with birthyear_1_dv = 0 if the women is childless. <br />And then birthyear_2_dv for the second kid for all female respondents etc. or something like that. <br />If you happen to have some general suggestions as to how to go about generating such variables, I would highly appreciate your input.</p>
<p>Best wishes and thank you very much.</p>
<p>Nico</p> Understanding Society User Support - Support #917 (Resolved): how to merge xwavedat with data fro...https://iserredex.essex.ac.uk/support/issues/9172018-02-12T10:05:40ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Alita,</p>
<p>this seems an obvious procedure, but I obtain a fairly high number of non-matches (60,792), which kind of concerns me. <br />This is what I do and I cannot detect an obvious mistake. <br />Your suggestions are highly appreciated, as usual. <br />Best. Nico <br />use pidp hhorig sex birthy feend_dv ukborn plbornc_all using "$Stata11_se/xwavedat_protect", clear <br />save $Mergeddata_master2016/xwavedat, replace</p>
<p>foreach w in a b c d e f g {</p>
<pre><code>use pidp `w'_istrtdaty `w'_jbhrs `w'_qfhigh_dv `w'_dvage `w'_marstat `w'_jbstat /// <br /> `w'_paygu_dv `w'_fimnlabgrs_dv `w'_jbsize `w'_jbsect `w'_jbsemp `w'_nnatch /// <br /> `w'_gor_dv `w'_urban_dv `w'_jshrs `w'_jbnssec8_dv ///<br /> using "$Stata11_se/`w'_indresp_protect", clear</code></pre>
<pre><code>gen wave = strpos("abcdefg","`w'") <br /> renpfix `w'_</code></pre>
<pre><code>save $Mergeddata_master2016/`w'wave, replace<br /> }</code></pre>
<p>use $Mergeddata_master2016/awave, replace <br />foreach w in b c d e f g{</p>
<pre><code>append using $Mergeddata_master2016/`w'wave.dta<br /> }</code></pre>
<p>save $Mergeddata_master2016/abcdefg_long, replace</p>
<p>merge m:1 pidp using $Mergeddata_master2016/xwavedat, force generate(_wemerge_2) </p>
<pre><code>Result # of obs.<br /> -----------------------------------------<br /> not matched 60,792<br /> from master 0 (_wemerge_2==1)<br /> from using 60,792 (_wemerge_2==2)</code></pre>
<pre><code>matched 334,897 (_wemerge_2==3)<br /> -----------------------------------------</code></pre> Understanding Society User Support - Support #879 (Closed): macob_all and pacob_all in xwavedat_p...https://iserredex.essex.ac.uk/support/issues/8792017-11-12T14:54:20ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Alita,</p>
<p>I hope you are doing well. I have noticed that macob_all and pacob_all are not available in xwavedat_protect, but just macob and pacob. I am wondering why this is the case. I did notice that they are present for each individual wave in the special licence version. <br />Will you guys make these variables available in wave 7 for the protected dataset? <br />If not, what would be an elegant way to construct these two variables from the individual waves.</p>
<p>Thanks a lot for your help once again.</p>
<p>Nico</p> Understanding Society User Support - Support #843 (Closed): w_englang is not part of xwavedat, bu...https://iserredex.essex.ac.uk/support/issues/8432017-08-26T14:13:20ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Alita,</p>
<p>if I understand the variable description correctly, englang is unfortunately not part of xwavedat. Whether English is first language is asked both immigrants and natives in wave one, and the IEMB in wave 6. <br />For wave 5, the englang variable appears as well. I want to use all six waves in USoc, for the years 2009-2015. For that purpose, I need to impute the information I have on englang to the missing waves/years. <br />So far, I have used the information from all three waves and generated a new variable englang_dv which I then merged m:1 pidp with the rest of the data set. <br />In broad terms, am I doing this correctly? <br />Thanks a lot! <br />Best wishes.</p>
<p>Nico</p> Understanding Society User Support - Support #839 (Closed): Pooling data from all waves, 1-6, usi...https://iserredex.essex.ac.uk/support/issues/8392017-08-21T10:54:34ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Peter,</p>
<p>sorry to bother you again, but we had that exchange in support <a class="issue tracker-3 status-5 priority-4 priority-default closed" title="Support: weights for pooled cross-sections over waves (a)-(f) (Closed)" href="https://iserredex.essex.ac.uk/support/issues/758">#758</a>. <br />I have been implementing your suggestions as we discussed. I am contacting you now again because I would really appreciate you <br />having a quick look again at our previous exchange and this current issue. With the weighting scheme, my results change quite a bit (point estimates and standard errors), so I really want to make sure that I am doing things right. I do think I do, but I rather double check. <br />So I am using all subsamples of all six waves and I generate a new weighting variable accordingly (newwgt). I use these observations across waves as if they were repeated cross sections. For various reasons, I cannot utilize the panel data structure. The time dimension of the pooled cross sections is not the wave variable, but the year variable, istrtdaty, start of the individual interview. Given this information and the discussion we had in support <a class="issue tracker-3 status-5 priority-4 priority-default closed" title="Support: weights for pooled cross-sections over waves (a)-(f) (Closed)" href="https://iserredex.essex.ac.uk/support/issues/758">#758</a>, I would highly appreciate your verification of me doing things correctly. <br />Thank you very much in advance! <br />Nico</p> Understanding Society User Support - Support #802 (Closed): Construction of hourly wage with payg...https://iserredex.essex.ac.uk/support/issues/8022017-06-26T11:40:11ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Hello, <br />I would like to construct hourly wages with w_paygu_dv and w_jbhrs/w_jshrs for the employed and self-employed. <br />So far, I have taken paygu_dv and divided it by 4.33 and by either jbhrs and jshrs to obtain hourly wages. <br />I think I looked thoroughly enough, but I could not find the number of weeks worked per year in USoc. <br />I guess I could construct a cleaner hourly wage variable if I had that information. <br />So my short question is if there exists such a variable?</p> Understanding Society User Support - Support #758 (Closed): weights for pooled cross-sections ove...https://iserredex.essex.ac.uk/support/issues/7582017-03-29T17:32:21ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Hi there,</p>
<p>I am running hourly wage (constructed with w_paygu_dv) on a number of regressors in a pooled cross-section over all six waves. So far, I am using the whole sample based on GPS, EMBS, BHPS, IEMBS. I am not sure what kind of weights to use in this context given that I want to use all four samples. f_indinui_xw is available for all four for wave 6, so do I just go ahead and use that one? <br />Any piece of advice would be terrific. <br />Thanks a lot!</p> Understanding Society User Support - Support #709 (Closed): how to match spouses across waves https://iserredex.essex.ac.uk/support/issues/7092017-01-27T13:39:46ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Hi,</p>
<p>I would like to match partners for a given wave and ideally across waves. <br />There is _ppid, the cross wave person identifier of partner. <br />Where would I go from here? A very general description of what to consider or do next would be terrific.</p>
<p>Thanks a lot!</p> Understanding Society User Support - Support #692 (Closed): merging _indresp and _child across al...https://iserredex.essex.ac.uk/support/issues/6922017-01-03T17:37:02ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Ladies and Gentlemen,</p>
<p>I hope this question is USoc-specific enough to post it here. With Stata, I would like to merge the files _indresp and _child across all six waves. In the end, I would like to have the age and sex of the children, the biological father, his wage etc. in one panel data set (long format). So far, I have created two separate panel data files, the master file with numerous selected variables from _indresp and the using file from _child with a number of selected variables. So I have these two panel sets and I want to merge them. I went ahead and ran <br />merge 1:1 pidp wave using ........, gen(....). In the master set, I have roughtly 290 000 observations and in the using set 9 000. The number of matches were zero, though. My guess is that I cannot use pidp as common variable for both sets, but I am not sure which one to use. If you could give me a hint as to how to set this merging procedure up, I would highly appreciate that.</p> Understanding Society User Support - Support #613 (Closed): how do I transform waves as time meas...https://iserredex.essex.ac.uk/support/issues/6132016-08-02T20:47:07ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Hi everybody,</p>
<p>I have a quick question concerning the time dimension of the panel data set when using Understanding Society. Waves are defined from 1-5, but when I define some of my variables I need a calendar year, such as 2010. I found `w'_istrtdaty, which gives you the beginning year of the interview if I properly understand it. But when I write xtset pidp year I receive an error message telling me that there are repeated time values within panel. <br />I am afraid there are two questions I am raising here. First of all, why does the error message come up? Is it a measurement error in the `w'_istrtdaty variable? Secondly, how can I transform waves in USoc into years properly? I need an annual measure!</p>