Project

General

Profile

Support #1769

missing values after merging household and individual dataset

Added by Shujun Liu over 1 year ago. Updated 8 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Data inconsistency
Start date:
09/09/2022
% Done:

100%


Description

Dear member of Understanding Society,

I am dealing with Inovation Panel data(wave10) and trying to merge the variables from the dataset of j_hhresp_ip with those from the dataset of j_indresp_ip.

Using the common variable j_indresp_ip, I can merge these two dataset successfully. But there exist 55 missing values, in which 49 from master dataset (i.e., j_hhresp_ip) and 6 from j_indresp_ip.

I just wonder is it normal? What cause the missing values?

The variables I tried to merge include:

"j_hidp j_hhsize j_xphsdb j_xphsdct j_xphsdba j_hhpc1 j_hhpc2 j_hhpc3 j_hhpc4 j_hhpc5 j_hhpc96 j_pcnet j_nemp_dv j_hhtype_dv j_fihhmngrs_dv j_fihhmngrs_if" from j_hhresp_ip.dta.

"pidp j_hidp j_pno j_jbstat j_twithave j_scbrowsesp j_scemailsp j_scphotosp j_scsmlooksp j_scsmpostsp j_scbuysp j_scbanksp j_scinstalsp j_scgpssp j_scblutthsp j_scgamessp j_scstreamsp j_scothersp j_scbrowsetb j_scemailtb j_scphototb j_scsmlooktb j_scsmposttb j_scbuytb j_scbanktb j_scinstaltb j_scgpstb j_scblutthtb j_scgamestb j_scstreamtb j_scothertb j_scskillsp j_scskilltb j_sex j_dvage j_marstat j_employ j_agegr10_dv j_qfhigh_dv j_jbseg_dv j_hhorig j_psu j_strata j_indpxip_xw j_indinip_xw j_indscip_xw j_fimngrs_dv" from j_hhresp_ip.

Many thanks for your help

Best wishes
Shujun Liu


Files

j_hhresp_ip.dta (594 KB) j_hhresp_ip.dta Shujun Liu, 09/09/2022 04:52 PM
j_indresp_ip.dta (795 KB) j_indresp_ip.dta Shujun Liu, 09/09/2022 04:52 PM
link.do (1.25 KB) link.do Shujun Liu, 09/13/2022 11:47 AM

Also available in: Atom PDF