/* Published: 03/11/2024 */ /************************** COMMENTS *******************************/ /* THIS INPUT STATMENT IS FOR THE 2022 SEER-MEDICAID LINKAGE. */ /* IF YOU RECEIVED MEDICAID FILES BEFORE MAY 2023 THEN YOU WILL */ /* NEED A DIFFERENT INPUT STATEMENT. PLEASE CONTACT IMS VIA E-MAIL AT */ /* SEER-MEDICARE@IMSWEB.COM AND AN INPUT STATEMENT WILL BE SENT TO YOU */ /***********************************************************************/ /*************** IMPORTANT PROGRAMING NOTES ************************/ /* If you are using PC SAS to read in these files you will have to */ /* un-zip the files first and use the un-zipped filename statement, */ /* rather than using the zipped files and statement. */ /***********************************************************************/ *filename tafhhspo '/directory/taf.demog.hh.spo.2019.txt'; /* reading in an un-zipped file* / *filename tafhhspo pipe 'gunzip -c /directory/taf.demog.hh.spo.2019.txt.gz'; /* reading in a zipped file */ *filename tafhhspo pipe 'gunzip -c /directory/taf.demog.hh.spo.*.txt.gz'; /* using wildcard to match multiple files */ options nocenter validvarname=upcase; data taf_hhspo; length patient_ID $15 MSIS_ID $32 STATE_CD $2 SUBMTG_STATE_CD $2 HLTH_HOME_PRVDR_ID $30 HLTH_HOME_ENT_NAME $100 HLTH_HOME_MH_CC_IND $1 HLTH_HOME_SUD_CC_IND $1 HLTH_HOME_ASTHMA_CC_IND $1 HLTH_HOME_DBTS_CC_IND $1 HLTH_HOME_HRT_DISEASE_CC_IND $1 HLTH_HOME_OVRWT_CC_IND $1 HLTH_HOME_HIV_AIDS_CC_IND $1 HLTH_HOME_OTH_CC_IND $1 HLTH_HOME_PGM_IND_01 $1 HLTH_HOME_PGM_IND_02 $1 HLTH_HOME_PGM_IND_03 $1 HLTH_HOME_PGM_IND_04 $1 HLTH_HOME_PGM_IND_05 $1 HLTH_HOME_PGM_IND_06 $1 HLTH_HOME_PGM_IND_07 $1 HLTH_HOME_PGM_IND_08 $1 HLTH_HOME_PGM_IND_09 $1 HLTH_HOME_PGM_IND_10 $1 HLTH_HOME_PGM_IND_11 $1 HLTH_HOME_PGM_IND_12 $1 CFC_SPO_IND_01 $1 CFC_SPO_IND_02 $1 CFC_SPO_IND_03 $1 CFC_SPO_IND_04 $1 CFC_SPO_IND_05 $1 CFC_SPO_IND_06 $1 CFC_SPO_IND_07 $1 CFC_SPO_IND_08 $1 CFC_SPO_IND_09 $1 CFC_SPO_IND_10 $1 CFC_SPO_IND_11 $1 CFC_SPO_IND_12 $1 SPO_1915I_IND_01 $1 SPO_1915I_IND_02 $1 SPO_1915I_IND_03 $1 SPO_1915I_IND_04 $1 SPO_1915I_IND_05 $1 SPO_1915I_IND_06 $1 SPO_1915I_IND_07 $1 SPO_1915I_IND_08 $1 SPO_1915I_IND_09 $1 SPO_1915I_IND_10 $1 SPO_1915I_IND_11 $1 SPO_1915I_IND_12 $1 SPO_1915J_IND_01 $1 SPO_1915J_IND_02 $1 SPO_1915J_IND_03 $1 SPO_1915J_IND_04 $1 SPO_1915J_IND_05 $1 SPO_1915J_IND_06 $1 SPO_1915J_IND_07 $1 SPO_1915J_IND_08 $1 SPO_1915J_IND_09 $1 SPO_1915J_IND_10 $1 SPO_1915J_IND_11 $1 SPO_1915J_IND_12 $1 SPO_1932A_IND_01 $1 SPO_1932A_IND_02 $1 SPO_1932A_IND_03 $1 SPO_1932A_IND_04 $1 SPO_1932A_IND_05 $1 SPO_1932A_IND_06 $1 SPO_1932A_IND_07 $1 SPO_1932A_IND_08 $1 SPO_1932A_IND_09 $1 SPO_1932A_IND_10 $1 SPO_1932A_IND_11 $1 SPO_1932A_IND_12 $1 SPO_1915A_IND_01 $1 SPO_1915A_IND_02 $1 SPO_1915A_IND_03 $1 SPO_1915A_IND_04 $1 SPO_1915A_IND_05 $1 SPO_1915A_IND_06 $1 SPO_1915A_IND_07 $1 SPO_1915A_IND_08 $1 SPO_1915A_IND_09 $1 SPO_1915A_IND_10 $1 SPO_1915A_IND_11 $1 SPO_1915A_IND_12 $1 ABP_SPO_1937_IND_01 $1 ABP_SPO_1937_IND_02 $1 ABP_SPO_1937_IND_03 $1 ABP_SPO_1937_IND_04 $1 ABP_SPO_1937_IND_05 $1 ABP_SPO_1937_IND_06 $1 ABP_SPO_1937_IND_07 $1 ABP_SPO_1937_IND_08 $1 ABP_SPO_1937_IND_09 $1 ABP_SPO_1937_IND_10 $1 ABP_SPO_1937_IND_11 $1 ABP_SPO_1937_IND_12 $1 RFRNC_YR $4 ; infile tafhhspo lrecl=277 missover; input @00001 patient_id $CHAR15. /*encrypted*/ @00016 MSIS_ID $CHAR32. /*encrypted*/ @00048 STATE_CD $CHAR2. @00050 SUBMTG_STATE_CD $CHAR2. @00052 HLTH_HOME_PRVDR_ID $CHAR30. @00082 HLTH_HOME_ENT_NAME $CHAR100. @00182 HLTH_HOME_MH_CC_IND $CHAR1. @00183 HLTH_HOME_SUD_CC_IND $CHAR1. @00184 HLTH_HOME_ASTHMA_CC_IND $CHAR1. @00185 HLTH_HOME_DBTS_CC_IND $CHAR1. @00186 HLTH_HOME_HRT_DISEASE_CC_IND $CHAR1. @00187 HLTH_HOME_OVRWT_CC_IND $CHAR1. @00188 HLTH_HOME_HIV_AIDS_CC_IND $CHAR1. @00189 HLTH_HOME_OTH_CC_IND $CHAR1. @00190 HLTH_HOME_PGM_IND_01 $CHAR1. @00191 HLTH_HOME_PGM_IND_02 $CHAR1. @00192 HLTH_HOME_PGM_IND_03 $CHAR1. @00193 HLTH_HOME_PGM_IND_04 $CHAR1. @00194 HLTH_HOME_PGM_IND_05 $CHAR1. @00195 HLTH_HOME_PGM_IND_06 $CHAR1. @00196 HLTH_HOME_PGM_IND_07 $CHAR1. @00197 HLTH_HOME_PGM_IND_08 $CHAR1. @00198 HLTH_HOME_PGM_IND_09 $CHAR1. @00199 HLTH_HOME_PGM_IND_10 $CHAR1. @00200 HLTH_HOME_PGM_IND_11 $CHAR1. @00201 HLTH_HOME_PGM_IND_12 $CHAR1. @00202 CFC_SPO_IND_01 $CHAR1. @00203 CFC_SPO_IND_02 $CHAR1. @00204 CFC_SPO_IND_03 $CHAR1. @00205 CFC_SPO_IND_04 $CHAR1. @00206 CFC_SPO_IND_05 $CHAR1. @00207 CFC_SPO_IND_06 $CHAR1. @00208 CFC_SPO_IND_07 $CHAR1. @00209 CFC_SPO_IND_08 $CHAR1. @00210 CFC_SPO_IND_09 $CHAR1. @00211 CFC_SPO_IND_10 $CHAR1. @00212 CFC_SPO_IND_11 $CHAR1. @00213 CFC_SPO_IND_12 $CHAR1. @00214 SPO_1915I_IND_01 $CHAR1. @00215 SPO_1915I_IND_02 $CHAR1. @00216 SPO_1915I_IND_03 $CHAR1. @00217 SPO_1915I_IND_04 $CHAR1. @00218 SPO_1915I_IND_05 $CHAR1. @00219 SPO_1915I_IND_06 $CHAR1. @00220 SPO_1915I_IND_07 $CHAR1. @00221 SPO_1915I_IND_08 $CHAR1. @00222 SPO_1915I_IND_09 $CHAR1. @00223 SPO_1915I_IND_10 $CHAR1. @00224 SPO_1915I_IND_11 $CHAR1. @00225 SPO_1915I_IND_12 $CHAR1. @00226 SPO_1915J_IND_01 $CHAR1. @00227 SPO_1915J_IND_02 $CHAR1. @00228 SPO_1915J_IND_03 $CHAR1. @00229 SPO_1915J_IND_04 $CHAR1. @00230 SPO_1915J_IND_05 $CHAR1. @00231 SPO_1915J_IND_06 $CHAR1. @00232 SPO_1915J_IND_07 $CHAR1. @00233 SPO_1915J_IND_08 $CHAR1. @00234 SPO_1915J_IND_09 $CHAR1. @00235 SPO_1915J_IND_10 $CHAR1. @00236 SPO_1915J_IND_11 $CHAR1. @00237 SPO_1915J_IND_12 $CHAR1. @00238 SPO_1932A_IND_01 $CHAR1. @00239 SPO_1932A_IND_02 $CHAR1. @00240 SPO_1932A_IND_03 $CHAR1. @00241 SPO_1932A_IND_04 $CHAR1. @00242 SPO_1932A_IND_05 $CHAR1. @00243 SPO_1932A_IND_06 $CHAR1. @00244 SPO_1932A_IND_07 $CHAR1. @00245 SPO_1932A_IND_08 $CHAR1. @00246 SPO_1932A_IND_09 $CHAR1. @00247 SPO_1932A_IND_10 $CHAR1. @00248 SPO_1932A_IND_11 $CHAR1. @00249 SPO_1932A_IND_12 $CHAR1. @00250 SPO_1915A_IND_01 $CHAR1. @00251 SPO_1915A_IND_02 $CHAR1. @00252 SPO_1915A_IND_03 $CHAR1. @00253 SPO_1915A_IND_04 $CHAR1. @00254 SPO_1915A_IND_05 $CHAR1. @00255 SPO_1915A_IND_06 $CHAR1. @00256 SPO_1915A_IND_07 $CHAR1. @00257 SPO_1915A_IND_08 $CHAR1. @00258 SPO_1915A_IND_09 $CHAR1. @00259 SPO_1915A_IND_10 $CHAR1. @00260 SPO_1915A_IND_11 $CHAR1. @00261 SPO_1915A_IND_12 $CHAR1. @00262 ABP_SPO_1937_IND_01 $CHAR1. @00263 ABP_SPO_1937_IND_02 $CHAR1. @00264 ABP_SPO_1937_IND_03 $CHAR1. @00265 ABP_SPO_1937_IND_04 $CHAR1. @00266 ABP_SPO_1937_IND_05 $CHAR1. @00267 ABP_SPO_1937_IND_06 $CHAR1. @00268 ABP_SPO_1937_IND_07 $CHAR1. @00269 ABP_SPO_1937_IND_08 $CHAR1. @00270 ABP_SPO_1937_IND_09 $CHAR1. @00271 ABP_SPO_1937_IND_10 $CHAR1. @00272 ABP_SPO_1937_IND_11 $CHAR1. @00273 ABP_SPO_1937_IND_12 $CHAR1. @00274 RFRNC_YR $CHAR4. ; label PATIENT_ID = "Patient ID" MSIS_ID = "Encrypted State Assigned Beneficiary Unique Identifier" STATE_CD = "Submitting State Alpha Abbreviation" SUBMTG_STATE_CD = "Submitting State Entity Code" HLTH_HOME_PRVDR_ID = "Hlth Home Provider Identification Number - Ltst in Yr" HLTH_HOME_ENT_NAME = "Hlth Home Entity Name - Ltst in Yr" HLTH_HOME_MH_CC_IND = "Hlth Home Mental Hlth State-Reported Chronic Condition Ind - Ltst in Yr" HLTH_HOME_SUD_CC_IND = "Hlth Home Substance Abuse Disorders St-Rprtd Chronic Condition Ind - Ltst in Yr" HLTH_HOME_ASTHMA_CC_IND = "Hlth Home Asthma State-Reported Chronic Condition Ind - Ltst in Yr" HLTH_HOME_DBTS_CC_IND = "Hlth Home Diabetes State-Reported Chronic Condition Ind - Ltst in Yr" HLTH_HOME_HRT_DISEASE_CC_IND = "Hlth Home Heart Disease State-Reported Chronic Condition Ind - Ltst in Yr" HLTH_HOME_OVRWT_CC_IND = "Hlth Home Overweight State-Reported Chronic Condition Ind - Ltst in Yr" HLTH_HOME_HIV_AIDS_CC_IND = "Hlth Home HIV or AIDS State-Reported Chronic Condition Ind - Ltst in Yr" HLTH_HOME_OTH_CC_IND = "Hlth Home Other Condition State-Reported Chronic Condition Ind - Ltst in Yr" HLTH_HOME_PGM_IND_01 = "Hlth Home Program Participation Ind - January" HLTH_HOME_PGM_IND_02 = "Hlth Home Program Participation Ind - February" HLTH_HOME_PGM_IND_03 = "Hlth Home Program Participation Ind - March" HLTH_HOME_PGM_IND_04 = "Hlth Home Program Participation Ind - April" HLTH_HOME_PGM_IND_05 = "Hlth Home Program Participation Ind - May" HLTH_HOME_PGM_IND_06 = "Hlth Home Program Participation Ind - June" HLTH_HOME_PGM_IND_07 = "Hlth Home Program Participation Ind - July" HLTH_HOME_PGM_IND_08 = "Hlth Home Program Participation Ind - August" HLTH_HOME_PGM_IND_09 = "Hlth Home Program Participation Ind - September" HLTH_HOME_PGM_IND_10 = "Hlth Home Program Participation Ind - October" HLTH_HOME_PGM_IND_11 = "Hlth Home Program Participation Ind - November" HLTH_HOME_PGM_IND_12 = "Hlth Home Program Participation Ind - December" CFC_SPO_IND_01 = "Community First Choice State Plan Option Ind - January" CFC_SPO_IND_02 = "Community First Choice State Plan Option Ind - February" CFC_SPO_IND_03 = "Community First Choice State Plan Option Ind - March" CFC_SPO_IND_04 = "Community First Choice State Plan Option Ind - April" CFC_SPO_IND_05 = "Community First Choice State Plan Option Ind - May" CFC_SPO_IND_06 = "Community First Choice State Plan Option Ind - June" CFC_SPO_IND_07 = "Community First Choice State Plan Option Ind - July" CFC_SPO_IND_08 = "Community First Choice State Plan Option Ind - August" CFC_SPO_IND_09 = "Community First Choice State Plan Option Ind - September" CFC_SPO_IND_10 = "Community First Choice State Plan Option Ind - October" CFC_SPO_IND_11 = "Community First Choice State Plan Option Ind - November" CFC_SPO_IND_12 = "Community First Choice State Plan Option Ind - December" SPO_1915I_IND_01 = "1915(i) State Plan Option Ind - January" SPO_1915I_IND_02 = "1915(i) State Plan Option Ind - February" SPO_1915I_IND_03 = "1915(i) State Plan Option Ind - March" SPO_1915I_IND_04 = "1915(i) State Plan Option Ind - April" SPO_1915I_IND_05 = "1915(i) State Plan Option Ind - May" SPO_1915I_IND_06 = "1915(i) State Plan Option Ind - June" SPO_1915I_IND_07 = "1915(i) State Plan Option Ind - July" SPO_1915I_IND_08 = "1915(i) State Plan Option Ind - August" SPO_1915I_IND_09 = "1915(i) State Plan Option Ind - September" SPO_1915I_IND_10 = "1915(i) State Plan Option Ind - October" SPO_1915I_IND_11 = "1915(i) State Plan Option Ind - November" SPO_1915I_IND_12 = "1915(i) State Plan Option Ind - December" SPO_1915J_IND_01 = "1915(j) State Plan Option Ind - January" SPO_1915J_IND_02 = "1915(j) State Plan Option Ind - February" SPO_1915J_IND_03 = "1915(j) State Plan Option Ind - March" SPO_1915J_IND_04 = "1915(j) State Plan Option Ind - April" SPO_1915J_IND_05 = "1915(j) State Plan Option Ind - May" SPO_1915J_IND_06 = "1915(j) State Plan Option Ind - June" SPO_1915J_IND_07 = "1915(j) State Plan Option Ind - July" SPO_1915J_IND_08 = "1915(j) State Plan Option Ind - August" SPO_1915J_IND_09 = "1915(j) State Plan Option Ind - September" SPO_1915J_IND_10 = "1915(j) State Plan Option Ind - October" SPO_1915J_IND_11 = "1915(j) State Plan Option Ind - November" SPO_1915J_IND_12 = "1915(j) State Plan Option Ind - December" SPO_1932A_IND_01 = "1932(a) State Plan Option Ind - January" SPO_1932A_IND_02 = "1932(a) State Plan Option Ind - February" SPO_1932A_IND_03 = "1932(a) State Plan Option Ind - March" SPO_1932A_IND_04 = "1932(a) State Plan Option Ind - April" SPO_1932A_IND_05 = "1932(a) State Plan Option Ind - May" SPO_1932A_IND_06 = "1932(a) State Plan Option Ind - June" SPO_1932A_IND_07 = "1932(a) State Plan Option Ind - July" SPO_1932A_IND_08 = "1932(a) State Plan Option Ind - August" SPO_1932A_IND_09 = "1932(a) State Plan Option Ind - September" SPO_1932A_IND_10 = "1932(a) State Plan Option Ind - October" SPO_1932A_IND_11 = "1932(a) State Plan Option Ind - November" SPO_1932A_IND_12 = "1932(a) State Plan Option Ind - December" SPO_1915A_IND_01 = "1915(a) State Plan Option Ind - January" SPO_1915A_IND_02 = "1915(a) State Plan Option Ind - February" SPO_1915A_IND_03 = "1915(a) State Plan Option Ind - March" SPO_1915A_IND_04 = "1915(a) State Plan Option Ind - April" SPO_1915A_IND_05 = "1915(a) State Plan Option Ind - May" SPO_1915A_IND_06 = "1915(a) State Plan Option Ind - June" SPO_1915A_IND_07 = "1915(a) State Plan Option Ind - July" SPO_1915A_IND_08 = "1915(a) State Plan Option Ind - August" SPO_1915A_IND_09 = "1915(a) State Plan Option Ind - September" SPO_1915A_IND_10 = "1915(a) State Plan Option Ind - October" SPO_1915A_IND_11 = "1915(a) State Plan Option Ind - November" SPO_1915A_IND_12 = "1915(a) State Plan Option Ind - December" ABP_SPO_1937_IND_01 = "1937 Alternative Benefit Plan State Plan Option Ind - January" ABP_SPO_1937_IND_02 = "1937 Alternative Benefit Plan State Plan Option Ind - February" ABP_SPO_1937_IND_03 = "1937 Alternative Benefit Plan State Plan Option Ind - March" ABP_SPO_1937_IND_04 = "1937 Alternative Benefit Plan State Plan Option Ind - April" ABP_SPO_1937_IND_05 = "1937 Alternative Benefit Plan State Plan Option Ind - May" ABP_SPO_1937_IND_06 = "1937 Alternative Benefit Plan State Plan Option Ind - June" ABP_SPO_1937_IND_07 = "1937 Alternative Benefit Plan State Plan Option Ind - July" ABP_SPO_1937_IND_08 = "1937 Alternative Benefit Plan State Plan Option Ind - August" ABP_SPO_1937_IND_09 = "1937 Alternative Benefit Plan State Plan Option Ind - September" ABP_SPO_1937_IND_10 = "1937 Alternative Benefit Plan State Plan Option Ind - October" ABP_SPO_1937_IND_11 = "1937 Alternative Benefit Plan State Plan Option Ind - November" ABP_SPO_1937_IND_12 = "1937 Alternative Benefit Plan State Plan Option Ind - December" RFRNC_YR = "Reference Yr" ; run; title 'T-MSIS ANALYTIC FILE DEMOG/ELIG HH/SPO SAS Data Set'; proc contents data=taf_hhspo position; run; * End of Program *;