Project

General

Profile

Support #1889

Missing waves when merging UKHLS and BHPS datasets

Added by Neil Smith about 1 year ago. Updated 7 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Data documentation
Start date:
04/07/2023
% Done:

100%

Description

Hi there,

I have merged the UKHLS and BHPS datasets for a few data variables which were used in both datasets and some which were used in only the UKHLS dataset. I have used the online stata code provided for merging these 2 datasets. Whilst this has worked fine, when I aim to add the j1none variable (which had only been used in the UKHLS dataset), an error occurs as there was no j1none variable for the first wave of the UKHLS (wave a). Whilst j1none had not been used in the bhps, it is important I can still add it as a variable to the merged dataset produced for my research (where the j1none data values for the bhps waves will be 'inapplicable').

Is there any code i can add/modify to the provided code for merging the bhps and ukhls dataset that will allow it to work when the first wave of a ukhls variable (or any wave) had not been recorded?

I look forward to your response.

Kind Regards,
Neil Smith

Also available in: Atom PDF