Understanding Society User Support

07/17/2020

08:32 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

I will start with the second question:
- yes, you can use indinus_lw directly
- in the first option you assume that... Olena Kaminska

07/16/2020

07:21 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

Thanks for the suggestions, Olena.
Which variable would indicate those “interviews that took place (finished) in J... Abigail Dumalus

07:01 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

Oh, and with regard to your comment on 'it seems that I am still missing a step or two to generate average life satis... Olena Kaminska

06:58 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

Abigail,
The method I described earlier does not correspond to BHPS data (before UKHLS started). BHPS is normally ... Olena Kaminska

05:45 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

Hello Olena,
I am using indin91_lw for longitudinal regressions over time from 1996 to 2017 with life satisfaction... Abigail Dumalus

05:03 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

Abigail,
I think you have a few questions that I will try to answer below.
First, why are you using indin91_lw. I... Olena Kaminska

12:50 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

May I please get any advice on my queries above about item 11 in the weighting FAQ? Many thanks for your time and con... Abigail Dumalus

05:04 PM Understanding Society User Support Support #1380 (In Progress): Calendar month analysis [item 11, weighting FAQ] not making sense to recreate January 2014

Hi Abigail,
I have assigned this to Olena. This is similar to your question on the other post which also I have as... Alita Nandi

04:34 PM Understanding Society User Support Support #1380 (Resolved): Calendar month analysis [item 11, weighting FAQ] not making sense to recreate January 2014

Hello Alita,
I tried following item 11 for doing January 2014 as an example. When I filtered interviews from wave ... Abigail Dumalus

03:46 PM Understanding Society User Support Support #1379 (Resolved): Unmatched individuals when linking UKHLS to local authority data

Hello,
I have recently added local authority level unemployment rates to a panel of individual-level UKHLS data (w... Clara Mascaro

07/15/2020

05:05 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

Hello Olena,
I tried following item 11 for doing January 2014 as an example. When I filtered interviews from wave ... Abigail Dumalus

04:06 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

Abigail,
Yes, I can confirm that FAQ question 11 applies to 3-months analysis. We do not have a ready syntax for y... Olena Kaminska

03:06 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

I read item 11 in the weighting FAQ. It seems appropriate but I cannot be sure whether this applies for building 3-mo... Abigail Dumalus

02:14 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

I see. Yes, you can analyse by calendar year. Take a look at item 11 in the weighting FAQ and see if that is appropri... Alita Nandi

01:53 PM Understanding Society User Support Support #1378: Overlapping interview periods across waves?

Thanks so much, Alita, for your feedback. Does the 24-month wave period preclude me from using “year” as a panel time... Abigail Dumalus

01:36 PM Understanding Society User Support Support #1378 (Feedback): Overlapping interview periods across waves?

Yes, in Understanding Society the fieldwork period for any wave stretches over 24 months and is overlaps with the nex... Alita Nandi

01:28 PM Understanding Society User Support Support #1378 (Resolved): Overlapping interview periods across waves?

Hello Alita,
I noticed from browsing the dataset that wave periods from wave 2 until wave 9 have been overlapping.... Abigail Dumalus

01:39 PM Understanding Society User Support Support #1375: XTREG error: weight must be constant within pidp

Yes drop all the weight variables, then merge i_indin91_lw from i_indrsp onto the entire long format file (many to on... Alita Nandi

01:11 PM Understanding Society User Support Support #1375: XTREG error: weight must be constant within pidp

Hello Alita,
I apologise for not replying for almost a week. I have been ill. I currently have several weighting ... Abigail Dumalus

03:35 AM Understanding Society User Support Support #1375 (Feedback): XTREG error: weight must be constant within pidp

Alita Nandi

03:37 AM Understanding Society User Support Support #1241 (Resolved): Problem merging inderesp with children data

Alita Nandi

03:37 AM Understanding Society User Support Support #1337 (Resolved): w_jbnssec3_dv have more than 3 category

Alita Nandi

03:35 AM Understanding Society User Support Support #1374 (Resolved): Weights

Alita Nandi

03:35 AM Understanding Society User Support Support #1377 (Feedback): Weights in Covid-19 Study

Hello Darja,
ca_betaindin_xw = i_indinui_xw * non-response probability based on a model of non-response between m... Alita Nandi

07/14/2020

03:36 PM Understanding Society User Support Support #1377 (Resolved): Weights in Covid-19 Study

Dear Support Team,
I tsset (pidp wave) the April and May Study. Can I only use the weight (betaindin_xw) cross-sec... Darja Reuschke

01:47 PM Understanding Society User Support Support #1376: Top coding on h_fimnnet_dv (total net personal income - no deductions)

Hello,
Sorry the variable note for w_fimnnet_dv does not clearly explain how topcoding is done. There are 51 obser... Alita Nandi

07/10/2020

10:31 AM Understanding Society User Support Support #1374: Weights

Dear Olena,
This perfectly answers my question. Thanks so much for the clarification!
Best,
Maria Maria Cotofan

07/09/2020

02:47 PM Understanding Society User Support Support #1374: Weights

Maria,
Thank you for your questions. I am replying in order:
In your original message:
(1) Yes, your set up is c... Olena Kaminska

10:27 AM Understanding Society User Support Support #1374: Weights

ok. I am now assigning this to our Survey Statistican, Olena.
Alita Nandi

10:44 AM Understanding Society User Support Support #1376 (In Progress): Top coding on h_fimnnet_dv (total net personal income - no deductions)

Hello,
Thank you for your query. I have passed on your query to our income team and we will get back to you soon.
... Alita Nandi

09:44 AM Understanding Society User Support Support #1376 (Resolved): Top coding on h_fimnnet_dv (total net personal income - no deductions)

Hello there,
I'm working with h_fimnnet_dv, and trying to build a regression model to predict income based on a ra... Christopher Brown

10:26 AM Understanding Society User Support Support #1375: XTREG error: weight must be constant within pidp

Let's say your long file is, long.dta. Then you do this:
use long, clear
merge m:1 pidp using i_indresp, keepus(i... Alita Nandi

07/08/2020

04:44 PM Understanding Society User Support Support #1375: XTREG error: weight must be constant within pidp

Hello Alita,
I understand what you’re saying. but is there an extra step or specific code that I need to implement... Abigail Dumalus

06:01 AM Understanding Society User Support Support #1375: XTREG error: weight must be constant within pidp

Hi Abigail,
You need to take i_indin91_lw (as Wave 9 is the last wave you are including) and then attach that to a... Alita Nandi

11:43 AM Understanding Society User Support Support #1374: Weights

Dear Anita,
Thank you for your quick reply!
Regarding point (1), I was already familiar with item 12 in the FAQ... Maria Cotofan

06:05 AM Understanding Society User Support Support #1374: Weights

Hello,
(1) Take a look at item 12 in the weighting FAQ which discusses pooling waves for cross-sectional analysis.... Alita Nandi

07/07/2020

08:01 PM Understanding Society User Support Support #1375 (Resolved): XTREG error: weight must be constant within pidp

Dear Olena,
As I mentioned in a separate issue weeks ago, I am analysing life satisfaction and GHQ (using indresp ... Abigail Dumalus

10:50 AM Understanding Society User Support Support #1374 (Resolved): Weights

Dear Sir/Madame,
I have a question regarding the use of weights when pooling the 9 waves of Understanding Society.... Maria Cotofan

07/03/2020

02:17 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Yes, this happens sometimes, but only a few such cases. In the 9 UKHLS waves there are 13 such cases. In BHPS the cut... Alita Nandi

01:47 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

I will try your advice and see how it goes. Thanks so much, Alita.
I meant to raise this before: just looking at i... Abigail Dumalus

01:32 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

First check that that indall_longfile and indresp_longfile don't have repeated observations. Type
isid pidp wave
... Alita Nandi

11:12 AM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hello Alita,
It was a typo here. I used pidp. What I did was linking all indall files together for 26 waves (using... Abigail Dumalus

06:34 AM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

You said you ran the code "xtset pid wave" and got an error message. Did you use "pid" instead of "pidp" or this just... Alita Nandi

02:01 PM Understanding Society User Support Support #1372: Question about age of respondents based on age_dv, and racel_dv (Re-created as original was deleted)

For the 9 wave of UKHLS data:
The variable w_birthy was checked for consistency across the waves. After resolving ... Alita Nandi

01:24 PM Understanding Society User Support Support #1373 (Feedback): Child file a-j [ca_childdoba]

Hello,
Respondents to this survey, who reported at least one child below the age of 18 (hhcompa>0 or hhcomdb>0 or ... Alita Nandi

07/02/2020

02:16 PM Understanding Society User Support Support #1372: Question about age of respondents based on age_dv, and racel_dv (Re-created as original was deleted)

Hello Alita,
I have read this variable note. But one of the input variables, dob_dv, is based on birthy. That's wh... Abigail Dumalus

01:37 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hello Alita,
Kindly see above for my question about appending/merging indall files with indresp+xwavedat file. I h... Abigail Dumalus

07/01/2020

01:32 PM Understanding Society User Support Support #1373: Child file a-j [ca_childdoba]

If it is that child a was their first child, child b their second ect.. then why are the ones not represented in the ... leandra geyser

01:20 PM Understanding Society User Support Support #1373 (Resolved): Child file a-j [ca_childdoba]

I really tried to figure this one out before asking here, also had a scan of other questions but I cannot understand ... leandra geyser

01:18 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Thanks so much, Alita.
I was trying to append the indall longitudinal file (all 26 waves) with the indresp+xwaved... Abigail Dumalus

06/30/2020

04:34 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

I am responding to issue #17 above:
There are a few ways to do this. What you have suggested (first append all you... Alita Nandi

11:51 AM Understanding Society User Support Support #1370 (In Progress): BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hello Abigail,
I am sorry I deleted the issue 1371 that you had posted by mistake. As it is not possible for us to... Alita Nandi

04:08 PM Understanding Society User Support Support #1372: Question about age of respondents based on age_dv, and racel_dv (Re-created as original was deleted)

Hi Abigail,
Have you read the variable note and the input variables mentioned on the variable page? https://www.un... Alita Nandi

12:17 PM Understanding Society User Support Support #1372 (In Progress): Question about age of respondents based on age_dv, and racel_dv (Re-created as original was deleted)

Hello Abgail,
I am passing on your query about age_dv to the data team and will get back to you wth their response... Alita Nandi

11:42 AM Understanding Society User Support Support #1372 (Resolved): Question about age of respondents based on age_dv, and racel_dv (Re-created as original was deleted)

Hello Alita,
I am wondering why the age_dv variable is not consistent with birthy when the latter is read side by ... Alita Nandi

06/27/2020

11:15 AM Understanding Society User Support Support #1370 (Resolved): BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

This issue is now continuing via email. So, this post is set to resolved. Alita Nandi

11:07 AM Understanding Society User Support Support #1368: Unmatched households when merging hhresp with lsoa data

Hi Natalie,
These are the households without valid postcodes.
Best wishes,
Alita Alita Nandi

06/26/2020

05:54 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hi Olena,
I just sent an email request for creating a tailored weight.
About merging youth and child data file... Abigail Dumalus

05:35 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Abigail,
To understand the difference between '91' and 'ub' weight please see
https://www.understandingsociety.a... Olena Kaminska

05:22 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Great to hear from you, Olena...
I am interested with creating my own tailored weight base on W_psnen??_lw. If I u... Abigail Dumalus

04:43 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Abigali,
Yes, of course your analysis and research questions make sense, and indeed we do not have specific weight... Olena Kaminska

04:17 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Thanks so much, Alita!
Hello Olena,
Does it make sense to merge the youth sample (for the question/variable 'y... Abigail Dumalus

01:00 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

I am assigning this to our Survey Statistician, Dr. Kaminska, to answer your question on appropriate weights for this... Alita Nandi

12:37 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hello Alita,
Yes, I am especially interested in analysing life satisfaction and GHQ happiness. Thank you for shari... Abigail Dumalus

09:59 AM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

You're welcocme Abigail!
From your description it seems that you are planning to use the BHPS sample over 26 waves... Alita Nandi

01:31 AM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hello Alita,
I'm so glad to hear that you and Gundi are around to give advice!
I just have a follow up questio... Abigail Dumalus

01:03 AM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hi Abigail,
Following up on what Gundi has said, I took a look at the syntax file on our website and added Wave 9 ... Alita Nandi

04:38 PM Understanding Society User Support Support #1368: Unmatched households when merging hhresp with lsoa data

Sorry just to follow up so I can justify this later, could you confirm why those 2,898 cases are not in the LSOA file... Natalie Bennett

02:18 PM Understanding Society User Support Support #1368: Unmatched households when merging hhresp with lsoa data

Hi Alita and Gundi
Thanks both for your help, I understand the source of the non-matches now.
Thanks so much.
... Natalie Bennett

01:19 AM Understanding Society User Support Support #1368 (Feedback): Unmatched households when merging hhresp with lsoa data

To follow up on what Gundi has said,
All households in c_hhsamp who have a valid postcode for their addresses are ... Alita Nandi

02:02 PM Understanding Society User Support Support #1369: Link UK Household Longitudinal Study with other datasets - is it possible?

Thanks so much for all this information - I will explore these possibilities now.
Thanks again for your time and h... Daniela Rodrigues

01:46 PM Understanding Society User Support Support #1369: Link UK Household Longitudinal Study with other datasets - is it possible?

Thanks Gundi.
Hi Daniela,
I had simultaneously asked our data team to provide a response to your query. Below i... Alita Nandi

01:40 PM Understanding Society User Support Support #1369: Link UK Household Longitudinal Study with other datasets - is it possible?

Hi Daniela,
the list of geographical identifier data files we make available is complete. Via this route it is not p... Gundi Knies

01:24 PM Understanding Society User Support Support #1369: Link UK Household Longitudinal Study with other datasets - is it possible?

Hi Gundi
Many thanks for this information. I have been exploring the link to geo-coded data shared by Alita but I ... Daniela Rodrigues

01:03 PM Understanding Society User Support Support #1369: Link UK Household Longitudinal Study with other datasets - is it possible?

Hi Daniela,
Alita has described procedures to link to geo-coded data. Your query suggest you may instead be interest... Gundi Knies

12:27 PM Understanding Society User Support Support #1369: Link UK Household Longitudinal Study with other datasets - is it possible?

Hi Alita
Thanks for your feedback. I checked the link you shared. Can you please just confirm - Is it possible to ... Daniela Rodrigues

01:08 AM Understanding Society User Support Support #1369 (Feedback): Link UK Household Longitudinal Study with other datasets - is it possible?

Hello,
Matching of Understanding Society data with external datasets which are at different levels of geography is... Alita Nandi

06/25/2020

10:31 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Not sure why the code on the website only goes to wave 8; it is porbably a co-incidence and I would not expect the co... Gundi Knies

10:11 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Thanks for the advice, Gundi.
I will use the duplicates report command. Is this the main reason why the merging-i... Abigail Dumalus

09:36 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

the number of cases in wave 9 is suspicious because the sample size tends to reduce from wave to wave, due to non-res... Gundi Knies

07:49 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Why is the number of cases for UKHLS wave 9 suspicious? Does this mean there should only be 25 waves in the longitudi... Abigail Dumalus

07:31 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Try not to append UKHLS wave 9 to the data file that already has wave 9 data - the number of cases for w9 is suspicious. Gundi Knies

06:33 PM Understanding Society User Support Support #1370: BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hello Gundi,
I have been trying append all UKHLS waves, using the standard Stata syntax for looping through the wa... Abigail Dumalus

05:23 PM Understanding Society User Support Support #1370 (Feedback): BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hi Abigail,
it seems like you the wave values 1-9 twice - once for the BHPS and once for the UKHLS. Maybe treat UKHL... Gundi Knies

03:45 PM Understanding Society User Support Support #1370 (Resolved): BHPS+UKHLS (26 waves) Repeated Time Values Error in Stata

Hello,
I found that linking all 26 waves went without a hitch. Since I intend to do longitudinal analysis of life... Abigail Dumalus

05:28 PM Understanding Society User Support Support #1368: Unmatched households when merging hhresp with lsoa data

Hi Natalie,
the universe of cases in the geographical identifier datasets is sampled households with a valid postcod... Gundi Knies

11:32 AM Understanding Society User Support Support #1369 (Resolved): Link UK Household Longitudinal Study with other datasets - is it possible?

I am doing my PhD on the impact of digital-first models of care on a range of outcomes, including health inequalities... Daniela Rodrigues

06/24/2020

03:26 PM Understanding Society User Support Support #1366: Valid occupation code versus job hours

Thanks so much for looking into this. I think I have figured it now. I was looking at unique observations (i.e. by pi... C Josten

02:04 PM Understanding Society User Support Support #1366: Valid occupation code versus job hours

No problem. I have looked at the data again. Over the 18+9 waves of data:
jbhas=1|jboff=1 for 370979 cases
jbocc9... Alita Nandi

06/23/2020

08:18 PM Understanding Society User Support Support #1366: Valid occupation code versus job hours

Hi Alita! Sorry to bother you again but just to reiterate: the occupation code actually has more unique observations ... C Josten

04:42 PM Understanding Society User Support Support #1366: Valid occupation code versus job hours

Those who have a job in the week before the interview (jbhas=1 OR jboff =1), whether in paid employment or self-emplo... Alita Nandi

03:22 PM Understanding Society User Support Support #1366: Valid occupation code versus job hours

I am interested in employed and self-employed. This should match the number of individuals with a valid occupation co... C Josten

03:18 PM Understanding Society User Support Support #1366: Valid occupation code versus job hours

You're welcome.
jbsemp =1 for in paid employment and =2 for self-employed. So, you need to check for jbsemp=1 and ... Alita Nandi

03:16 PM Understanding Society User Support Support #1366: Valid occupation code versus job hours

Hi Alita!
Thanks for your fast and very helpful reply, which makes sense. The only follow up question - why is it ... C Josten

03:01 PM Understanding Society User Support Support #1366 (Feedback): Valid occupation code versus job hours

Hello,
Occupation question is asked of anyone who did paid work the week before the interview (jbhas=1 OR jboff=1)... Alita Nandi

09:55 AM Understanding Society User Support Support #1366 (Resolved): Valid occupation code versus job hours

Dear Understanding Society team,
I'm puzzled about the fact that in my data (all BHPS and US waves merged) I have ... C Josten

05:06 PM Understanding Society User Support Support #1367: Hourly wage (accounting for overtime)

basrate is a direct question asked of those who said that they are paid an hourly rate. So, this will be missing for ... Alita Nandi

03:34 PM Understanding Society User Support Support #1367: Hourly wage (accounting for overtime)

This does make sense. Thanks, Alita.
Adding to the above I was wondering how basrate can be defined? Is it gross h... C Josten

03:03 PM Understanding Society User Support Support #1367 (Feedback): Hourly wage (accounting for overtime)

Hello,
w_fimnlabgrs_dv is the gross monthly income from all labour market earnings = usual gross monthly wage from... Alita Nandi

01:07 PM Understanding Society User Support Support #1367: Hourly wage (accounting for overtime)

Adding to the above I was wondering how basrate can be defined? Is it gross hourly wage or income? Does it make sense... C Josten

10:46 AM Understanding Society User Support Support #1367 (Resolved): Hourly wage (accounting for overtime)

Hi!
I would like to calculate hourly wages across all waves and am now wondering whether to use fimnlabgrs_dv or p... C Josten

05:01 PM Understanding Society User Support Support #1368 (Resolved): Unmatched households when merging hhresp with lsoa data

Hi I am trying to distribute LSOA identifiers to household level data using wave 3. I have an issue when I merge the ... Natalie Bennett

04:03 PM Understanding Society User Support Support #1359: Using the EMB sample independently

Great thanks so much for your help Alita.
Many thanks
Natalie Natalie Bennett

06/22/2020

03:08 PM Understanding Society User Support Support #1365 (Feedback): Payment methods gas and electricity

Hello Antonia,
The respondents read these categories and responded to these based on how they interpreted these. S... Alita Nandi

02:30 PM Understanding Society User Support Support #1365 (Resolved): Payment methods gas and electricity

Hi,
is there any information how to sort your categories in "method of payment for electricity" or "method of pay... Antonia Schuster

06/20/2020

02:54 AM Understanding Society User Support Support #1362 (Feedback): Deriving own weights

Alita Nandi

02:42 AM Understanding Society User Support Support #1363 (Feedback): Covid weights

Hi Laura,
As it says in the user guide "or the purposes of weighting, the COVID-19 study is treated as an instrume... Alita Nandi

02:29 AM Understanding Society User Support Support #1364 (Feedback): Sample overlap with other studies

Hi Amy,
We have no restriction on our respondents participating in other surveys but we don't know who has partici... Alita Nandi