********************************************************************************************************** **************This program trims the data and constructs all indicators used in the analyses************** ********************************************************************************************************** clear use E:\Data\workdata\705830\zic\sha\replication\data\samlet_gini_family_histaug2020 /*selecting G1 on the basis of birth year*/ keep if inrange(fodaar,1974,1984) /*dropping immigrants*/ drop if ie_type==2 /*identifying and deleting G2 individuals with no information on G1 parents in the registers*/ gen far_indk=0 replace far_indk=1 if fodaar_far!=. gen mor_indk=0 replace mor_indk=1 if fodaar_mor!=. gen sum_indk=mor_indk+far_indk drop if sum_indk==0 drop if mor_id==. drop if far_id==. /*calculating G1 mother and father's age at the time G2 is born*/ gen alder_far=fodaar-fodaar_far gen alder_mor=fodaar-fodaar_mor /*deleting G2 observations with G1 parents younger than 13 at childbirth*/ drop if alder_far>0 & alder_far<13 drop if alder_mor>0 & alder_mor<13 /*replacing missing information on service use with 0*/ forva x=1991/2016{ replace indlag`x'=0 if indlag`x'==. replace indlag_mor`x'=0 if indlag_mor`x'==. replace indlag_far`x'=0 if indlag_far`x'==. replace y2_samlet`x'=0 if y2_samlet`x'==. replace y2_samlet_mor`x'=0 if y2_samlet_mor`x'==. replace y2_samlet_far`x'=0 if y2_samlet_far`x'==. replace samlet_con`x'=0 if samlet_con`x'==. replace samlet_con_mor`x'=0 if samlet_con_mor`x'==. replace samlet_con_far`x'=0 if samlet_con_far`x'==. replace sum_psyk`x'=0 if sum_psyk`x'==. replace sum_psyk_mor`x'=0 if sum_psyk_mor`x'==. replace sum_psyk_far`x'=0 if sum_psyk_far`x'==. } forva x=1991/2015{ replace sum_af`x'=0 if sum_af`x'==. replace sum_af_mor`x'=0 if sum_af_mor`x'==. replace sum_af_far`x'=0 if sum_af_far`x'==. } *************G2 high need service use, 2006-2016 gen indlag_sum=indlag2006+indlag2007+indlag2008+indlag2009+indlag2010+indlag2011+indlag2012+indlag2013+indlag2014+indlag2015+indlag2016 gen ydelse_sum=y2_samlet2006+y2_samlet2007+y2_samlet2008+y2_samlet2009+y2_samlet2010+y2_samlet2011+y2_samlet2012+y2_samlet2013+y2_samlet2014+y2_samlet2015+y2_samlet2016 gen conv_sum=samlet_con2006+samlet_con2007+samlet_con2008+samlet_con2009+samlet_con2010+samlet_con2011+samlet_con2012+samlet_con2013+samlet_con2014+samlet_con2015+samlet_con2016 gen foster_sum=sum_af2006+sum_af2007+sum_af2008+sum_af2009+sum_af2010+sum_af2011+sum_af2012+sum_af2013+sum_af2014+sum_af2015 gen psyk_sum=sum_psyk2006+sum_psyk2007+sum_psyk2008+sum_psyk2009+sum_psyk2010+sum_psyk2011+sum_psyk2012+sum_psyk2013+sum_psyk2014+sum_psyk2015+sum_psyk2016 *************G1 high need service use, 2006-2016, mother gen indlag_sum_mor0616=indlag_mor2006+indlag_mor2007+indlag_mor2008+indlag_mor2009+indlag_mor2010+indlag_mor2011+indlag_mor2012+indlag_mor2013+indlag_mor2014+indlag_mor2015+indlag_mor2016 gen ydelse_sum_mor0616=y2_samlet_mor2006+y2_samlet_mor2007+y2_samlet_mor2008+y2_samlet_mor2009+y2_samlet_mor2010+y2_samlet_mor2011+y2_samlet_mor2012+y2_samlet_mor2013+y2_samlet_mor2014+y2_samlet_mor2015+y2_samlet_mor2016 gen conv_sum_mor0616=samlet_con_mor2006+samlet_con_mor2007+samlet_con_mor2008+samlet_con_mor2009+samlet_con_mor2010+samlet_con_mor2011+samlet_con_mor2012+samlet_con_mor2013+samlet_con_mor2014+samlet_con_mor2015+samlet_con_mor2016 gen psyk_sum_mor0616=sum_psyk_mor2006+sum_psyk_mor2007+sum_psyk_mor2008+sum_psyk_mor2009+sum_psyk_mor2010+sum_psyk_mor2011+sum_psyk_mor2012+sum_psyk_mor2013+sum_psyk_mor2014+sum_psyk_mor2015+sum_psyk_mor2016 *************G1 high need service use, 2006-2016, father gen indlag_sum_far0616=indlag_far2006+indlag_far2007+indlag_far2008+indlag_far2009+indlag_far2010+indlag_far2011+indlag_far2012+indlag_far2013+indlag_far2014+indlag_far2015+indlag_far2016 gen ydelse_sum_far0616=y2_samlet_far2006+y2_samlet_far2007+y2_samlet_far2008+y2_samlet_far2009+y2_samlet_far2010+y2_samlet_far2011+y2_samlet_far2012+y2_samlet_far2013+y2_samlet_far2014+y2_samlet_far2015+y2_samlet_far2016 gen conv_sum_far0616=samlet_con_far2006+samlet_con_far2007+samlet_con_far2008+samlet_con_far2009+samlet_con_far2010+samlet_con_far2011+samlet_con_far2012+samlet_con_far2013+samlet_con_far2014+samlet_con_far2015+samlet_con_far2016 gen psyk_sum_far0616=sum_psyk_far2006+sum_psyk_far2007+sum_psyk_far2008+sum_psyk_far2009+sum_psyk_far2010+sum_psyk_far2011+sum_psyk_far2012+sum_psyk_far2013+sum_psyk_far2014+sum_psyk_far2015+sum_psyk_far2016 *************G1 high need service use, 1984-1994, mother gen psyk_sum_mor=sum_psyk_mor1984+sum_psyk_mor1985+sum_psyk_mor1986+sum_psyk_mor1987+sum_psyk_mor1988+sum_psyk_mor1989+sum_psyk_mor1990+sum_psyk_mor1991+sum_psyk_mor1992+sum_psyk_mor1993+sum_psyk_mor1994 gen indlag_sum_mor=samlet_hosp_84_94_mor gen ydelse_sum_mor=samlet_shss_84_94_mor gen conv_sum_mor=samlet_con_84_94_mor *************G1 high need service use, 1984-1994, father gen psyk_sum_far=sum_psyk_far1984+sum_psyk_far1985+sum_psyk_far1986+sum_psyk_far1987+sum_psyk_far1988+sum_psyk_far1989+sum_psyk_far1990+sum_psyk_far1991+sum_psyk_far1992+sum_psyk_far1993+sum_psyk_far1994 gen indlag_sum_far=samlet_hosp_84_94_far gen ydelse_sum_far=samlet_shss_84_94_far gen conv_sum_far=samlet_con_84_94_far gen mor_mis=0 replace mor_mis=1 if fodaar_mor==. ****Binary indicator of service use *G2 gen ind_d=0 gen con_d=0 gen ydel_d=0 gen foster_d=0 gen psyk_d=0 replace ind_d=1 if indlag_sum>0 replace ind_d=0 if indlag_sum==. replace con_d=1 if conv_sum>0 replace con_d=0 if conv_sum==. replace ydel_d=1 if ydelse_sum>0 replace ydel_d=0 if ydelse_sum==. replace foster_d=1 if foster_sum>0 replace foster_d=1 if foster_sum==. replace psyk_d=1 if psyk_sum>0 replace psyk_d=1 if psyk_sum==. *G1 mother gen ind_d_mor=0 gen con_d_mor=0 gen ydel_d_mor=0 gen psyk_d_mor=0 replace ind_d_mor=1 if indlag_sum_mor>0 replace ind_d_mor=0 if indlag_sum_mor==. replace con_d_mor=1 if conv_sum_mor>0 replace con_d_mor=0 if conv_sum_mor==. replace ydel_d_mor=1 if ydelse_sum_mor>0 replace ydel_d_mor=0 if ydelse_sum_mor==. replace psyk_d_mor=1 if psyk_sum_mor>0 replace psyk_d_mor=1 if psyk_sum_mor==. gen ind_d_mor0616=0 gen con_d_mor0616=0 gen ydel_d_mor0616=0 gen psyk_d_mor0616=0 replace ind_d_mor0616=1 if indlag_sum_mor0616>0 replace ind_d_mor0616=0 if indlag_sum_mor0616==. replace con_d_mor0616=1 if conv_sum_mor0616>0 replace con_d_mor0616=0 if conv_sum_mor0616==. replace ydel_d_mor0616=1 if ydelse_sum_mor0616>0 replace ydel_d_mor0616=0 if ydelse_sum_mor0616==. replace psyk_d_mor0616=1 if psyk_sum_mor0616>0 replace psyk_d_mor0616=1 if psyk_sum_mor0616==. *G1 father gen ind_d_far=0 gen con_d_far=0 gen ydel_d_far=0 gen foster_d_far=0 gen psyk_d_far=0 replace ind_d_far=1 if indlag_sum_far>0 replace ind_d_far=0 if indlag_sum_far==. replace con_d_far=1 if conv_sum_far>0 replace con_d_far=0 if conv_sum_far==. replace ydel_d_far=1 if ydelse_sum_far>0 replace ydel_d_far=0 if ydelse_sum_far==. replace psyk_d_far=1 if psyk_sum_far>0 replace psyk_d_far=1 if psyk_sum_far==. gen ind_d_far0616=0 gen con_d_far0616=0 gen ydel_d_far0616=0 gen foster_d_far0616=0 gen psyk_d_far0616=0 replace ind_d_far0616=1 if indlag_sum_far0616>0 replace ind_d_far0616=0 if indlag_sum_far0616==. replace con_d_far0616=1 if conv_sum_far0616>0 replace con_d_far0616=0 if conv_sum_far0616==. replace ydel_d_far0616=1 if ydelse_sum_far0616>0 replace ydel_d_far0616=0 if ydelse_sum_far0616==. replace psyk_d_far0616=1 if psyk_sum_far0616>0 replace psyk_d_far0616=1 if psyk_sum_far0616==. *generating aggregated measure of service use egen agg_indlag=sum(indlag_sum) egen agg_ydelse=sum(ydelse_sum) egen agg_conv=sum(conv_sum) egen agg_foster=sum(foster_sum) egen agg_psyk=sum(psyk_sum) egen agg_indlag_mor=sum(indlag_sum_mor) egen agg_ydelse_mor=sum(ydelse_sum_mor) egen agg_conv_mor=sum(conv_sum_mor) egen agg_psyk_mor=sum(psyk_sum_mor) egen agg_indlag_far=sum(indlag_sum_far) egen agg_ydelse_far=sum(ydelse_sum_far) egen agg_conv_far=sum(conv_sum_far) egen agg_psyk_far=sum(psyk_sum_far) egen agg_indlag_mor0616=sum(indlag_sum_mor0616) egen agg_ydelse_mor0616=sum(ydelse_sum_mor0616) egen agg_conv_mor0616=sum(conv_sum_mor0616) egen agg_psyk_mor0616=sum(psyk_sum_mor0616) egen agg_indlag_far0616=sum(indlag_sum_far0616) egen agg_ydelse_far0616=sum(ydelse_sum_far0616) egen agg_conv_far0616=sum(conv_sum_far0616) egen agg_psyk_far0616=sum(psyk_sum_far0616) *formatting generating aggregated measure of service use format agg_ydelse %15.0f format agg_indlag %15.0f format agg_foster %15.0f format agg_psyk %15.0f format agg_conv %15.0f format agg_ydelse_mor %15.0f format agg_indlag_mor %15.0f format agg_psyk_mor %15.0f format agg_conv_mor %15.0f format agg_ydelse_far %15.0f format agg_indlag_far %15.0f format agg_psyk_far %15.0f format agg_conv_far %15.0f format agg_ydelse_mor0616 %15.0f format agg_indlag_mor0616 %15.0f format agg_psyk_mor0616 %15.0f format agg_conv_mor0616 %15.0f format agg_ydelse_far0616 %15.0f format agg_indlag_far0616 %15.0f format agg_psyk_far0616 %15.0f format agg_conv_far0616 %15.0f *Calculating G1 mother and G1 fathers age in 2016 gen mor_alder2016=2016-fodaar_mor gen far_alder2016=2016-fodaar_far *creating subcategories of G1 mother and G1 father on the basis of age gen mor_alder_kat=0 replace mor_alder_kat=1 if mor_alder2016<60 replace mor_alder_kat=2 if inrange(mor_alder2016,60,74) replace mor_alder_kat=3 if mor_alder2016>74 gen far_alder_kat=0 replace far_alder_kat=1 if far_alder2016<60 replace far_alder_kat=2 if inrange(far_alder2016,60,74) replace far_alder_kat=3 if far_alder2016>74 save E:\Data\workdata\705830\zic\sha\replication\data\samlet_gini2_hist_aug2020, replace clear use E:\Data\workdata\705830\zic\sha\replication\data\samlet_gini2_hist_aug2020 ************************************************************************************************************ ********************defining high need user in G1 and G2, the 5 pct. cut off point ************************* ************************************************************************************************************ *determining the 95th percentile for service use, G2 egen p95_indlag=pctile(indlag_sum), p(95) egen p95_con=pctile(conv_sum), p(96) egen p95_ydelse=pctile(ydelse_sum), p(95) egen p95_anbr=pctile(foster_sum), p(95) egen p95_psyk=pctile(psyk_sum), p(95) *determining the 95th percentile for service use, G1 mothers bysort mor_alder_kat: egen p95_indlag_mor=pctile(indlag_sum_mor), p(95) bysort mor_alder_kat: egen p95_con_mor=pctile(conv_sum_mor), p(95) bysort mor_alder_kat: egen p95_ydelse_mor=pctile(ydelse_sum_mor), p(95) bysort mor_alder_kat: egen p95_psyk_mor=pctile(psyk_sum_mor), p(95) *determining the 95th percentile for service use, G1 fathers bysort far_alder_kat: egen p95_indlag_far=pctile(indlag_sum_far), p(95) bysort far_alder_kat: egen p95_con_far=pctile(conv_sum_far), p(95) bysort far_alder_kat: egen p95_ydelse_far=pctile(ydelse_sum_far), p(95) bysort far_alder_kat: egen p95_psyk_far=pctile(psyk_sum_far), p(95) *Defining the G2 high need groups on the basis of the 95th percentile cut off point gen p95_indlag_per=0 gen p95_con_per=0 gen p95_ydelse_per=0 gen p95_anbr_per=0 gen p95_psyk_per=0 replace p95_indlag_per=1 if indlag_sum>=p95_indlag replace p95_con_per=1 if conv_sum>=p95_con replace p95_ydelse_per=1 if ydelse_sum>=p95_ydelse replace p95_anbr_per=1 if foster_sum>p95_anbr replace p95_psyk_per=1 if psyk_sum>p95_psyk *Defining the G1 high need groups (mothers) on the basis of the 95th percentile cut off point gen p95_indlag_per_mor=0 gen p95_con_per_mor=0 gen p95_ydelse_per_mor=0 gen p95_psyk_per_mor=0 replace p95_indlag_per_mor=1 if indlag_sum_mor>=p95_indlag_mor replace p95_con_per_mor=1 if conv_sum_mor>p95_con_mor replace p95_ydelse_per_mor=1 if ydelse_sum_mor>=p95_ydelse_mor replace p95_psyk_per_mor=1 if psyk_sum_mor>p95_psyk_mor *Defining the G1 high need groups (mothers) on the basis of the 95th percentile cut off point gen p95_indlag_per_far=0 gen p95_con_per_far=0 gen p95_ydelse_per_far=0 gen p95_psyk_per_far=0 replace p95_indlag_per_far=1 if indlag_sum_far>=p95_indlag_far replace p95_con_per_far=1 if conv_sum_far>=p95_con_far replace p95_ydelse_per_far=1 if ydelse_sum_far>=p95_ydelse_far replace p95_psyk_per_far=1 if psyk_sum_far>p95_psyk_far *calculating the service use on the high need and non-high need groups, G2 bysort p95_indlag_per: egen sum_indlag95=sum(indlag_sum) bysort p95_con_per: egen sum_con95=sum(conv_sum) bysort p95_ydelse_per: egen sum_ydelse95=sum(ydelse_sum) bysort p95_anbr_per: egen sum_anbr95=sum(foster_sum) bysort p95_psyk_per: egen sum_psyk95=sum(psyk_sum) *calculating the service use on the high need and non-high need groups, G1 mothers bysort p95_indlag_per_mor: egen sum_indlag95_mor=sum(indlag_sum_mor) bysort p95_con_per_mor: egen sum_con95_mor=sum(conv_sum_mor) bysort p95_ydelse_per_mor: egen sum_ydelse95_mor=sum(ydelse_sum_mor) bysort p95_psyk_per_mor: egen sum_psyk95_mor=sum(psyk_sum_mor) *calculating the service use on the high need and non-high need groups, G1 fathers bysort p95_indlag_per_far: egen sum_indlag95_far=sum(indlag_sum_far) bysort p95_con_per_far: egen sum_con95_far=sum(conv_sum_far) bysort p95_ydelse_per_far: egen sum_ydelse95_far=sum(ydelse_sum_far) bysort p95_psyk_per_far: egen sum_psyk95_far=sum(psyk_sum_far) format sum_ydelse95 %15.0f format sum_ydelse95_mor %15.0f format sum_ydelse95_far %15.0f ******************************************************************************* ***************defining G1 service use for the period 2006 to 2016************* ******************************************************************************* *determining the 95th percentile for service use, G1 mothers bysort mor_alder_kat: egen p95_indlag_mor0616=pctile(indlag_sum_mor0616), p(95) bysort mor_alder_kat: egen p95_con_mor0616=pctile(conv_sum_mor0616), p(95) bysort mor_alder_kat: egen p95_ydelse_mor0616=pctile(ydelse_sum_mor0616), p(95) bysort mor_alder_kat: egen p95_psyk_mor0616=pctile(psyk_sum_mor0616), p(95) *determining the 95th percentile for service use, G1 fathers bysort far_alder_kat: egen p95_indlag_far0616=pctile(indlag_sum_far0616), p(95) bysort far_alder_kat: egen p95_con_far0616=pctile(conv_sum_far0616), p(95) bysort far_alder_kat: egen p95_ydelse_far0616=pctile(ydelse_sum_far0616), p(95) bysort far_alder_kat: egen p95_psyk_far0616=pctile(psyk_sum_far0616), p(95) *Defining the G1 high need groups (mothers) on the basis of the 95th percentile cut off point gen p95_indlag_per_mor0616=0 gen p95_con_per_mor0616=0 gen p95_ydelse_per_mor0616=0 gen p95_psyk_per_mor0616=0 replace p95_indlag_per_mor0616=1 if indlag_sum_mor0616>=p95_indlag_mor0616 replace p95_con_per_mor0616=1 if conv_sum_mor0616>p95_con_mor0616 replace p95_ydelse_per_mor0616=1 if ydelse_sum_mor0616>=p95_ydelse_mor0616 replace p95_psyk_per_mor0616=1 if psyk_sum_mor0616>p95_psyk_mor0616 *Defining the G1 high need groups (mothers) on the basis of the 95th percentile cut off point gen p95_indlag_per_far0616=0 gen p95_con_per_far0616=0 gen p95_ydelse_per_far0616=0 gen p95_psyk_per_far0616=0 replace p95_indlag_per_far0616=1 if indlag_sum_far0616>=p95_indlag_far0616 replace p95_con_per_far0616=1 if conv_sum_far0616>=p95_con_far0616 replace p95_ydelse_per_far0616=1 if ydelse_sum_far0616>=p95_ydelse_far0616 replace p95_psyk_per_far0616=1 if psyk_sum_far0616>p95_psyk_far0616 *calculating the service use on the high need and non-high need groups, G1 mothers bysort p95_indlag_per_mor0616: egen sum_indlag95_mor0616=sum(indlag_sum_mor0616) bysort p95_con_per_mor0616: egen sum_con95_mor0616=sum(conv_sum_mor0616) bysort p95_ydelse_per_mor0616: egen sum_ydelse95_mor0616=sum(ydelse_sum_mor0616) bysort p95_psyk_per_mor0616: egen sum_psyk95_mor0616=sum(psyk_sum_mor0616) *calculating the service use on the high need and non-high need groups, G1 fathers bysort p95_indlag_per_far0616: egen sum_indlag95_far0616=sum(indlag_sum_far0616) bysort p95_con_per_far0616: egen sum_con95_far0616=sum(conv_sum_far0616) bysort p95_ydelse_per_far0616: egen sum_ydelse95_far0616=sum(ydelse_sum_far0616) bysort p95_psyk_per_far0616: egen sum_psyk95_far0616=sum(psyk_sum_far0616) format sum_ydelse95 %15.0f format sum_ydelse95_mor0616 %15.0f format sum_ydelse95_far0616 %15.0f ************************************************************************************************************ ********************defining high need user in G1 and G2, the 90 pct. cut off point ************************* ************************************************************************************************************ *determining the 90th percentile for service use, G2 egen p90_indlag=pctile(indlag_sum), p(90) egen p90_con=pctile(conv_sum), p(90) egen p90_ydelse=pctile(ydelse_sum), p(90) egen p90_anbr=pctile(foster_sum), p(90) egen p90_psyk=pctile(psyk_sum), p(90) *determining the 90th percentile for service use, G1 mothers bysort mor_alder_kat: egen p90_indlag_mor=pctile(indlag_sum_mor), p(90) bysort mor_alder_kat: egen p90_con_mor=pctile(conv_sum_mor), p(90) bysort mor_alder_kat: egen p90_ydelse_mor=pctile(ydelse_sum_mor), p(90) bysort mor_alder_kat: egen p90_psyk_mor=pctile(psyk_sum_mor), p(90) *determining the 90th percentile for service use, G1 fathers bysort far_alder_kat: egen p90_indlag_far=pctile(indlag_sum_far), p(90) bysort far_alder_kat: egen p90_con_far=pctile(conv_sum_far), p(90) bysort far_alder_kat: egen p90_ydelse_far=pctile(ydelse_sum_far), p(90) bysort far_alder_kat: egen p90_psyk_far=pctile(psyk_sum_far), p(90) *Defining the G2 high need groups on the basis of the 90th percentile cut off point gen p90_indlag_per=0 gen p90_con_per=0 gen p90_ydelse_per=0 gen p90_anbr_per=0 gen p90_psyk_per=0 replace p90_indlag_per=1 if indlag_sum>=p90_indlag replace p90_con_per=1 if conv_sum>=p90_con replace p90_ydelse_per=1 if ydelse_sum>=p90_ydelse replace p90_anbr_per=1 if foster_sum>p90_anbr replace p90_psyk_per=1 if psyk_sum>p90_psyk *Defining the G1 high need groups (mothers) on the basis of the 90th percentile cut off point gen p90_indlag_per_mor=0 gen p90_con_per_mor=0 gen p90_ydelse_per_mor=0 gen p90_psyk_per_mor=0 replace p90_indlag_per_mor=1 if indlag_sum_mor>=p90_indlag_mor replace p90_con_per_mor=1 if conv_sum_mor>p90_con_mor replace p90_ydelse_per_mor=1 if ydelse_sum_mor>=p90_ydelse_mor replace p90_psyk_per_mor=1 if psyk_sum_mor>p90_psyk_mor *Defining the G1 high need groups (mothers) on the basis of the 90th percentile cut off point gen p90_indlag_per_far=0 gen p90_con_per_far=0 gen p90_ydelse_per_far=0 gen p90_psyk_per_far=0 replace p90_indlag_per_far=1 if indlag_sum_far>=p90_indlag_far replace p90_con_per_far=1 if conv_sum_far>=p90_con_far replace p90_ydelse_per_far=1 if ydelse_sum_far>=p90_ydelse_far replace p90_psyk_per_far=1 if psyk_sum_far>p90_psyk_far *calculating the service use on the high need and non-high need groups, G2 bysort p90_indlag_per: egen sum_indlag90=sum(indlag_sum) bysort p90_con_per: egen sum_con90=sum(conv_sum) bysort p90_ydelse_per: egen sum_ydelse90=sum(ydelse_sum) bysort p90_anbr_per: egen sum_anbr90=sum(foster_sum) bysort p90_psyk_per: egen sum_psyk90=sum(psyk_sum) *calculating the service use on the high need and non-high need groups, G1 mothers bysort p90_indlag_per_mor: egen sum_indlag90_mor=sum(indlag_sum_mor) bysort p90_con_per_mor: egen sum_con90_mor=sum(conv_sum_mor) bysort p90_ydelse_per_mor: egen sum_ydelse90_mor=sum(ydelse_sum_mor) bysort p90_psyk_per_mor: egen sum_psyk90_mor=sum(psyk_sum_mor) *calculating the service use on the high need and non-high need groups, G1 fathers bysort p90_indlag_per_far: egen sum_indlag90_far=sum(indlag_sum_far) bysort p90_con_per_far: egen sum_con90_far=sum(conv_sum_far) bysort p90_ydelse_per_far: egen sum_ydelse90_far=sum(ydelse_sum_far) bysort p90_psyk_per_far: egen sum_psyk90_far=sum(psyk_sum_far) format sum_ydelse90 %15.0f format sum_ydelse90_mor %15.0f format sum_ydelse90_far %15.0f save E:\Data\workdata\705830\zic\sha\replication\data\samlet_gini_est_hist_aug2020_replication, replace