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 #1128 (Resolved): How to match husbands and wives in...https://iserredex.essex.ac.uk/support/issues/11282019-01-14T14:05:55ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Stephanie, it is me again. I need your help with the following. I try to match husbands and wives (spouses) in USoc. This is what I am doing which is based on a previous suggestion from your team quite a while ago.</p>
<p>*manipulate data set to find age, UK arrival year etc. of spouse (sppno) <br />sort hidp pno<br />gen partnum=cond(pno < sppno, pno, sppno) if sppno>0</p>
<p>drop if sppno == 0 | sppno<0</p>
<p>bysort hidp partnum: egen numinpart = sum(sppno > 0)<br />tab numinpart</p>
<p>keep if numinpart 2</p>
<p>bysort hidp partnum: ge sp_age = cond(_n2,age(1),age(2),.) /// where age brackets 1 and age brackets 2, i.e.[] if I place a number within brackets, I get a goofy preview. <br /> if partnum<.</p>
<p>bysort hidp partnum: ge sp_yr2uk4 = cond(_n==2,yr2uk4(1),yr2uk4(2),.) /// where yr2uk4 brackets 1 and yr2uk4 brackets 2, i.e.[] <br /> if partnum<.</p>
<p>bysort hidp partnum: drop if (sex==1 & _n==2) | (sex==1 & _n==1) // drop females (2) or males (1), here I drop males so all variables defined are for wives and all sp_variables are for husbands.</p>
<p>Unfortunately, for my research question, I need to have husbands and wives matched, have variable characteristics for say wives and sp_characteristics for husbands WITHOUT having the dropping procedure of the previous line (i.e., bysort hidp partnum: drop if (sex==1 & _n==2) | (sex==1 & _n==1)). I hope I am making sense, I need to match wives and husbands and generate characteristics of both without dropping wives or husbands. The data should look like this:<br />hidp education_wife education_husband age_wife age_husband etc. <br />1 postgrad bachelor 50 60 etc.</p>
<p>I hope this is clear, if not please feel free to ask me.</p>
<p>Once again, I would very much appreciate your help and support.</p>
<p>Best wishes from Manchester.</p>
<p>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 #1079 (Resolved): How do I match adult respondents o...https://iserredex.essex.ac.uk/support/issues/10792018-10-21T13:57:15ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Alita,</p>
<p>I would like to have some labor market outcome information of children whose parents participated in the survey. I want this because I would like to have both labor market outcomes of parents and their children. For instance the wage of children and the wage of their associated father or mother. Not sure if this is feasible.</p>
<p>Any suggestions from you are as usual very much appreciated.</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 #945 (Resolved): total number of siblings of a give...https://iserredex.essex.ac.uk/support/issues/9452018-03-25T15:59:24ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Support Team,</p>
<p>I am looking for the total number of siblings of a given respondent (gender is irrelevant).</p>
<p>I could not find it, and I am not sure if there is information available to derive such a variable.</p>
<p>Your help is much appreciated.</p>
<p>Best wishes.</p>
<p>Nico</p> Understanding Society User Support - Support #906 (Resolved): Highest educational qualification u...https://iserredex.essex.ac.uk/support/issues/9062018-01-29T13:04:50ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear support-team,</p>
<p>I am wondering about the qfhigh_dv variable and immigrants who got their degree outside the UK. It seems to me that there is no problems with immigrants who got their degree in the UK. However, immigrants who hold a foreign degree might not find the equivalent in the questionnaire for the qfhigh_dv variable and simply report 'none of the above' (96). In my estimation sample, immigrants who got a foreign degree are well distributed across all of the listed degrees in the questionnaire. I use qualoc and imputation methods to infer the location of the degree. My question to you is if I should be concerned about the '96' entries for immigrants. It seems to me that as long as the entries are not systematically towards highly educated or low-educated or any other group, I should be fine. I realize that this question might go beyond the purpose of this forum, but if it does not, I would appreciate a reply.</p> Understanding Society User Support - Support #877 (Resolved): weights for pooled cross-sections ...https://iserredex.essex.ac.uk/support/issues/8772017-11-10T14:55:16ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Peter, <br />I have a few more questions with regard to my original 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 />1. When I generate my new weighting variable, newwgt, 600 observations in my estimation sample are assigned a zero meaning they are dropped. Why do you guys assign zero weights in w_indinus, w_indinub, etc. ? <br />2. The sample mean of my newwgt is 1.1 with a s.d. of 0.58. Does this look reasonable to you as in theory the mean should be 1. <br />3. Does USoc normalize weights so that N observations in weighted data equal N observations in unweighted data? It seems to me that you guys do that. <br />4. Given the normalization, how would I find the number of weighted and unweighted observations with Stata for my estimation sample?</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 #829 (Closed): What is the difference between qualoc...https://iserredex.essex.ac.uk/support/issues/8292017-08-03T17:46:13ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Alita,</p>
<p>I have been using the qualoc variable for the different waves. However, I am curious about the derived variable. When I check on qualoc_dv, I get more people receiving a degree abroad than in the UK. <br />When using qualoc from the different waves, I get what I expect, large number of folks obtained their degree in the UK. So what is qualoc_dv all about?</p>
<p>I appreciate your insights.</p>
<p>Thanks.</p>
<p>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 #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 #666 (Closed): gender of the children under 16 years...https://iserredex.essex.ac.uk/support/issues/6662016-11-27T20:43:28ZNico Ochmannnico.ochmann@postgrad.manchester.ac.uk
<p>Dear Ladies and Gentlemen,</p>
<p>I am trying to find the gender of the children in a given household.</p>
<p>The children should ideally be under 16 years of age and be the biological kids of the father. I understand that the fertility history variable in the indrep data file gives me the info on the biological father. I am not sure where to look for the gender of all the kids though, if it is available at all. I checked in the _child file where there is a _sex info. Would that be it?</p>
<p>I would appreciate your help.</p>
<p>Thanks a lot in advance.</p>
<p>Nico</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>