*********************************************************************************** *Paper Title: Nursing Home–Based Care for Children Younger Than 18 Years: 2012–2019 *Authors: Seiyoun Kim, PhD, Nurah Koney-Laryea, BA,Ziwei Pan, MS, Hye-Young Jung, PhD, *Jaya Aysola, MD, MPH, Sophia Jan, MD, MPH, Kira L. Ryskina, MD, MSHP *********************************************************************************** *********************************************************************************** *Table 1. Children Admitted to Nursing Homes from 2012 to 2019: Demographic, Treatment, and Facility Characteristics *********************************************************************************** *Long Stay clear use "/project/Ryskina_SNFists/Selina_working/HBCS/MDS/combined_longstay_7_21_clean.dta" *Drop Puerto Rico and Virgin Islands drop if STATE_CD == "PR" drop if STATE_CD == "VI" *Only keep residents under 18 drop if C_RSDNT_AGE_NUM==18 *Clean up variables replace O0100D2_SCTNG_POST_CD = "0" if O0100D2_SCTNG_POST_CD == "-" | O0100D2_SCTNG_POST_CD == "^" replace O0100E2_TRCHOSTMY_POST_CD = "0" if O0100E2_TRCHOSTMY_POST_CD == "-" | O0100E2_TRCHOSTMY_POST_CD == "^" replace O0100F2_VNTLTR_POST_CD = "0" if O0100F2_VNTLTR_POST_CD == "-" | O0100F2_VNTLTR_POST_CD == "^" replace O0100G2_CPAP_POST_CD = "0" if O0100G2_CPAP_POST_CD == "-" | O0100G2_CPAP_POST_CD == "^" | O0100G2_CPAP_POST_CD == "" replace O0100H2_IV_MDCTN_POST_CD = "0" if O0100H2_IV_MDCTN_POST_CD == "-" | O0100H2_IV_MDCTN_POST_CD == "^" replace O0100J2_DLYS_POST_CD = "0" if O0100J2_DLYS_POST_CD == "-" | O0100J2_DLYS_POST_CD == "^" replace O0100K2_HOSPC_POST_CD = "0" if O0100K2_HOSPC_POST_CD == "-" | O0100K2_HOSPC_POST_CD == "^" gen RACE2=RACE replace RACE2=5 if RACE>4 replace RACE2=3 if A1000D_HSPNC_CD=="1" gen HH_median_missing=0 replace HH_median_missing=1 if HH_median_income_2==. destring totbeds, replace gen Facility_size=. replace Facility_size=1 if totbeds<50 replace Facility_size=2 if totbeds>=50 & totbeds<100 replace Facility_size=3 if totbeds>=100 & totbeds!=. gen not_for_profit=. replace not_for_profit=0 if profit=="Yes" replace not_for_profit=1 if profit=="No" gen multi_chain=. replace multi_chain=0 if multifac=="No" replace multi_chain=1 if multifac=="Yes" destring paymcaid , replace destring paymcare , replace gen paymcaid_missing=0 replace paymcaid_missing=1 if paymcaid==. gen paymcare_missing=0 replace paymcare_missing=1 if paymcare==. destring acuindex2, replace gen Medicaid=0 replace Medicaid=1 if A0310A_FED_OBRA_CD=="01" | A0310A_FED_OBRA_CD=="02" | A0310A_FED_OBRA_CD=="03"| A0310A_FED_OBRA_CD=="04" | A0310A_FED_OBRA_CD=="05" | A0310A_FED_OBRA_CD=="06" gen Medicare=0 replace Medicare=1 if A0310B_PPS_CD=="01" | A0310B_PPS_CD=="02" | A0310B_PPS_CD=="03" | A0310B_PPS_CD=="04" | A0310B_PPS_CD=="05" | A0310B_PPS_CD=="06" | A0310B_PPS_CD=="07"| A0310C_PPS_OMRA_CD=="1" | A0310C_PPS_OMRA_CD=="2" | A0310C_PPS_OMRA_CD=="3"| A0310C_PPS_OMRA_CD=="4" | A2400A_MDCR_STAY_CD=="1" gen Insurance=. replace Insurance=1 if Medicaid==1 & Medicare==0 replace Insurance=2 if Medicaid==0 & Medicare==1 replace Insurance=3 if Medicaid==0 & Medicare==0 replace Insurance=4 if Medicaid==1 & Medicare==1 count if PROV1680=="" | paymcare_missing==1 | paymcaid_missing==1 | HH_median_missing==1 *Get Table table1 if C_RSDNT_AGE_NUM<18, vars (A0800_GNDR_CD cat\ RACE2 cat\ O0100D2_SCTNG_POST_CD cat\ O0100E2_TRCHOSTMY_POST_CD cat\ O0100F2_VNTLTR_POST_CD cat\ O0100G2_CPAP_POST_CD cat\ O0100H2_IV_MDCTN_POST_CD cat\ O0100J2_DLYS_POST_CD cat\ O0100K2_HOSPC_POST_CD cat\Insurance cat ) miss format(%10.2f) cformat(%10.2f) table1 if C_RSDNT_AGE_NUM<18, vars (HH_median_income_2 contn\ HH_median_missing cat\ Facility_size cat\ not_for_profit cat\ multi_chain cat\ paymcaid contn \ paymcaid_missing cat\ paymcare contn\ paymcare_missing cat\ acuindex2 contn\) miss format(%10.2f) cformat(%10.2f) *Short Stay clear use "/project/Ryskina_SNFists/Selina_working/HBCS/MDS/MDS.short_stays_7_22_clean.dta" *Drop Puerto Rico and Virgin Islands drop if STATE_CD == "PR" drop if STATE_CD == "VI" *Only keep residents under 18 drop if C_RSDNT_AGE_NUM==18 *Clean up variables replace O0100D2_SCTNG_POST_CD = "0" if O0100D2_SCTNG_POST_CD == "-" | O0100D2_SCTNG_POST_CD == "^" | O0100D2_SCTNG_POST_CD == "" replace O0100E2_TRCHOSTMY_POST_CD = "0" if O0100E2_TRCHOSTMY_POST_CD == "-" | O0100E2_TRCHOSTMY_POST_CD == "^" replace O0100F2_VNTLTR_POST_CD = "0" if O0100F2_VNTLTR_POST_CD == "-" | O0100F2_VNTLTR_POST_CD == "^" replace O0100G2_CPAP_POST_CD = "0" if O0100G2_CPAP_POST_CD == "-" | O0100G2_CPAP_POST_CD == "^" | O0100G2_CPAP_POST_CD == "" replace O0100H2_IV_MDCTN_POST_CD = "0" if O0100H2_IV_MDCTN_POST_CD == "-" | O0100H2_IV_MDCTN_POST_CD == "^" replace O0100J2_DLYS_POST_CD = "0" if O0100J2_DLYS_POST_CD == "-" | O0100J2_DLYS_POST_CD == "^" replace O0100K2_HOSPC_POST_CD = "0" if O0100K2_HOSPC_POST_CD == "-" | O0100K2_HOSPC_POST_CD == "^" gen RACE2=RACE replace RACE2=5 if RACE>4 replace RACE2=3 if A1000D_HSPNC_CD=="1" gen HH_median_missing=0 replace HH_median_missing=1 if HH_median_income_2==. destring totbeds, replace gen Facility_size=. replace Facility_size=1 if totbeds<50 replace Facility_size=2 if totbeds>=50 & totbeds<100 replace Facility_size=3 if totbeds>=100 & totbeds!=. gen not_for_profit=. replace not_for_profit=0 if profit=="Yes" replace not_for_profit=1 if profit=="No" gen multi_chain=. replace multi_chain=0 if multifac=="No" replace multi_chain=1 if multifac=="Yes" destring paymcaid , replace destring paymcare , replace gen paymcaid_missing=0 replace paymcaid_missing=1 if paymcaid==. gen paymcare_missing=0 replace paymcare_missing=1 if paymcare==. destring acuindex2, replace gen Medicaid=0 replace Medicaid=1 if A0310A_FED_OBRA_CD=="01" | A0310A_FED_OBRA_CD=="02" | A0310A_FED_OBRA_CD=="03"| A0310A_FED_OBRA_CD=="04" | A0310A_FED_OBRA_CD=="05" | A0310A_FED_OBRA_CD=="06" gen Medicare=0 replace Medicare=1 if A0310B_PPS_CD=="01" | A0310B_PPS_CD=="02" | A0310B_PPS_CD=="03" | A0310B_PPS_CD=="04" | A0310B_PPS_CD=="05" | A0310B_PPS_CD=="06" | A0310B_PPS_CD=="07"| A0310C_PPS_OMRA_CD=="1" | A0310C_PPS_OMRA_CD=="2" | A0310C_PPS_OMRA_CD=="3"| A0310C_PPS_OMRA_CD=="4" | A2400A_MDCR_STAY_CD=="1" gen Insurance=. replace Insurance=1 if Medicaid==1 & Medicare==0 replace Insurance=2 if Medicaid==0 & Medicare==1 replace Insurance=3 if Medicaid==0 & Medicare==0 replace Insurance=4 if Medicaid==1 & Medicare==1 count if PROV1680=="" | paymcare_missing==1 | paymcaid_missing==1 |HH_median_missing==1 *Get Table table1 if C_RSDNT_AGE_NUM<18 , vars (A0800_GNDR_CD cat\ RACE2 cat\ O0100D2_SCTNG_POST_CD cat\ O0100E2_TRCHOSTMY_POST_CD cat\ O0100F2_VNTLTR_POST_CD cat\ O0100G2_CPAP_POST_CD cat\ O0100H2_IV_MDCTN_POST_CD cat\ O0100J2_DLYS_POST_CD cat\ O0100K2_HOSPC_POST_CD cat\ Insurance cat ) miss format(%10.2f) cformat(%10.2f) table1 if C_RSDNT_AGE_NUM<18 , vars (HH_median_income_2 contn\ HH_median_missing cat\ Facility_size cat\ not_for_profit cat\ multi_chain cat\ paymcaid contn \ paymcaid_missing cat\ paymcare contn\ paymcare_missing cat\ acuindex2 contn) miss format(%10.2f) cformat(%10.2f) *********************************************************************************** *Figure 1, 2, and 3 *********************************************************************************** clear use "/project/Ryskina_SNFists/Selina_working/HBCS/MDS/combined_longstay_7_21_clean.dta" *Drop Puerto Rico and Virgin Islands drop if STATE_CD == "PR" drop if STATE_CD == "VI" *Only keep residents under 18 drop if C_RSDNT_AGE_NUM==18 *Clean race/ethnicity category gen RACE2=RACE replace RACE2=5 if RACE>4 replace RACE2=3 if A1000D_HSPNC_CD=="1" *Obtain number of residents in each racial/ethnicity category and export result to excel *(Figures were consturcted using excel) tab MDS_YEAR RACE2 *Short Stay clear use "/project/Ryskina_SNFists/Selina_working/HBCS/MDS/MDS.short_stays_7_22_clean.dta" *Drop Puerto Rico and Virgin Islands drop if STATE_CD == "PR" drop if STATE_CD == "VI" *Only keep residents under 18 drop if C_RSDNT_AGE_NUM==18 *Clean race/ethnicity category gen RACE2=RACE replace RACE2=5 if RACE>4 replace RACE2=3 if A1000D_HSPNC_CD=="1" *Obtain number of residents in each racial/ethnicity category and export result to excel *(Figures were consturcted using excel) tab MDS_YEAR RACE2