The database contains variables for father’s and mother’s birth identification number respectively, which makes it possible to link parental information with an individual based dataset.
merge makes it possible to link datasets. The key unit identification variable of the target dataset is used by default, unless customised through an
In this example, a separate dataset is made for fathers and mothers, which are linked to a personal level dataset via the key-link variables idnr_father and idnr_mother.
//Connect to datastore require no.ssb.fdb:23 as db //Create a main dataset with links to fathers and mothers create-dataset persondata import db/INNTEKT_WYRKINNT 2021-01-01 as workincome import db/BEFOLKNING_KJOENN as gender import db/NUDB_BU 2021-01-01 as edu import db/BEFOLKNING_FAR_FNR as idnr_father import db/BEFOLKNING_MOR_FNR as idnr_mother //Import data on parents and merge into main dataset create-dataset parents import db/INNTEKT_WYRKINNT 2021-01-01 as workincome_father import db/NUDB_BU 2021-01-01 as edu_father clone-variables workincome_father -> workincome_mother clone-variables edu_father -> edu_mother merge workincome_father edu_father into persondata on idnr_father merge workincome_mother edu_mother into persondata on idnr_mother //Perform basic linear regression analysis to test for covariation with parental income use persondata generate male = 0 replace male = 1 if gender == '1' destring edu generate high_edu = 0 replace high_edu = 1 if edu >= 700000 & edu < 900000 replace high_edu = edu if sysmiss(edu) destring edu_father generate high_edu_father = 0 replace high_edu_father = 1 if edu_father >= 700000 & edu_father < 900000 replace high_edu_father = edu_father if sysmiss(edu_father) destring edu_mother generate high_edu_mother = 0 replace high_edu_mother = 1 if edu_mother >= 700000 & edu_mother < 900000 replace high_edu_mother = edu_mother if sysmiss(edu_mother) summarize workincome workincome_father workincome_mother histogram workincome_father, percent histogram workincome_mother, percent correlate workincome_father workincome_mother tabulate high_edu_father high_edu_mother regress workincome male workincome_father workincome_mother high_edu high_edu_father high_edu_mother