***************************************************************************************** ; * THIS IS AN EXAMPLE OF A PROGRAM THAT CAN BE USED TO READ IN THE * ; * LINKED NCHS-CMS MEDICARE FEASIBILITY STUDY ASCII FILE. * ; * * ; * TO DOWNLOAD AND SAVE THE LINKED NCHS-CMS MEDICARE FEASIBILITY STUDY * ; * ASCII FILE TO YOUR HARD DRIVE, FOLLOW THESE STEPS: * ; * * ; * STEP 1: DESIGNATE A FOLDER ON YOUR HARD DRIVE TO DOWNLOAD THE LINKED * ; * NCHS-CMS MEDICARE FEASIBILITY STUDY ASCII FILE. IN THIS * ; * EXAMPLE, THE DATA WILL BE SAVED TO: 'C:\Feasibility Study Data\' * ; * * ; * STEP 2: DOWNLOAD THE ASCII DATA FROM THE NCHS WEB SITE. * ; * GO TO THE NCHS WEB SITE (LINK BELOW) AND DOWNLOAD THE LINKED * ; * NCHS-CMS MEDICARE FEASIBILITY STUDY ASCII FILE TO THE FOLDER * ; * 'C:\Feasibility Study Data\' * ; * * ; * ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/datalinkage/feasibility_study_data/CMS/ * ; * * ; * * ; * IMPORTANT INFORMATION REGARDING THE SURVEY ID VARIABLE: * ; * * ; * FOR NHIS AND LSOA2 SURVEYS USE PUBLICID AS THE ID VARIABLE * ; * FOR NHANES AND NHEFS SURVEYS USE SEQN AS THE ID VARIABLE * ; * FOR NNHS USE RESNUM AS THE ID VARIABLE * ; * * ; ***************************************************************************************** ; filename intext "C:\Feasibility Study Data\MEDICARE_FEASIBILITY_[survey name].dat" ; data Feasibility ; infile intext lrecl=141 ; attrib PUBLICID length=$14 label='NCHS Survey Identifier - Participant Identification Number' SEQN length=5 format=Z5. label='NCHS Survey Identifier - Sample Sequence Number' RESNUM length=6 format=Z6. label='NCHS Survey Identifier - Resident Record (Case) Number' CMS_MEDICARE_MATCH length=3 format=1. label='CMS MEDICARE MATCH STATUS' on_denom_1991 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1991)' on_denom_1992 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1992)' on_denom_1993 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1993)' on_denom_1994 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1994)' on_denom_1995 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1995)' on_denom_1996 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1996)' on_denom_1997 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1997)' on_denom_1998 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1998)' on_denom_1999 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (1999)' on_denom_2000 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (2000)' on_denom_2001 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (2001)' on_denom_2002 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (2002)' on_denom_2003 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (2003)' on_denom_2004 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (2004)' on_denom_2005 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (2005)' on_denom_2006 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (2006)' on_denom_2007 length=3 format=1. label='ON DENOMINATOR FILE INDICATOR (2007)' on_medpar_1991 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1991)' on_medpar_1992 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1992)' on_medpar_1993 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1993)' on_medpar_1994 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1994)' on_medpar_1995 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1995)' on_medpar_1996 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1996)' on_medpar_1997 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1997)' on_medpar_1998 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1998)' on_medpar_1999 length=3 format=1. label='ON MEDPAR FILE INDICATOR (1999)' on_medpar_2000 length=3 format=1. label='ON MEDPAR FILE INDICATOR (2000)' on_medpar_2001 length=3 format=1. label='ON MEDPAR FILE INDICATOR (2001)' on_medpar_2002 length=3 format=1. label='ON MEDPAR FILE INDICATOR (2002)' on_medpar_2003 length=3 format=1. label='ON MEDPAR FILE INDICATOR (2003)' on_medpar_2004 length=3 format=1. label='ON MEDPAR FILE INDICATOR (2004)' on_medpar_2005 length=3 format=1. label='ON MEDPAR FILE INDICATOR (2005)' on_medpar_2006 length=3 format=1. label='ON MEDPAR FILE INDICATOR (2006)' on_medpar_2007 length=3 format=1. label='ON MEDPAR FILE INDICATOR (2007)' on_carrier_1991 length=3 format=1. label='ON CARRIER FILE INDICATOR (1991)' on_carrier_1992 length=3 format=1. label='ON CARRIER FILE INDICATOR (1992)' on_carrier_1993 length=3 format=1. label='ON CARRIER FILE INDICATOR (1993)' on_carrier_1994 length=3 format=1. label='ON CARRIER FILE INDICATOR (1994)' on_carrier_1995 length=3 format=1. label='ON CARRIER FILE INDICATOR (1995)' on_carrier_1996 length=3 format=1. label='ON CARRIER FILE INDICATOR (1996)' on_carrier_1997 length=3 format=1. label='ON CARRIER FILE INDICATOR (1997)' on_carrier_1998 length=3 format=1. label='ON CARRIER FILE INDICATOR (1998)' on_carrier_1999 length=3 format=1. label='ON CARRIER FILE INDICATOR (1999)' on_carrier_2000 length=3 format=1. label='ON CARRIER FILE INDICATOR (2000)' on_carrier_2001 length=3 format=1. label='ON CARRIER FILE INDICATOR (2001)' on_carrier_2002 length=3 format=1. label='ON CARRIER FILE INDICATOR (2002)' on_carrier_2003 length=3 format=1. label='ON CARRIER FILE INDICATOR (2003)' on_carrier_2004 length=3 format=1. label='ON CARRIER FILE INDICATOR (2004)' on_carrier_2005 length=3 format=1. label='ON CARRIER FILE INDICATOR (2005)' on_carrier_2006 length=3 format=1. label='ON CARRIER FILE INDICATOR (2006)' on_carrier_2007 length=3 format=1. label='ON CARRIER FILE INDICATOR (2007)' on_dme_1991 length=3 format=1. label='ON DME FILE INDICATOR (1991)' on_dme_1992 length=3 format=1. label='ON DME FILE INDICATOR (1992)' on_dme_1993 length=3 format=1. label='ON DME FILE INDICATOR (1993)' on_dme_1994 length=3 format=1. label='ON DME FILE INDICATOR (1994)' on_dme_1995 length=3 format=1. label='ON DME FILE INDICATOR (1995)' on_dme_1996 length=3 format=1. label='ON DME FILE INDICATOR (1996)' on_dme_1997 length=3 format=1. label='ON DME FILE INDICATOR (1997)' on_dme_1998 length=3 format=1. label='ON DME FILE INDICATOR (1998)' on_dme_1999 length=3 format=1. label='ON DME FILE INDICATOR (1999)' on_dme_2000 length=3 format=1. label='ON DME FILE INDICATOR (2000)' on_dme_2001 length=3 format=1. label='ON DME FILE INDICATOR (2001)' on_dme_2002 length=3 format=1. label='ON DME FILE INDICATOR (2002)' on_dme_2003 length=3 format=1. label='ON DME FILE INDICATOR (2003)' on_dme_2004 length=3 format=1. label='ON DME FILE INDICATOR (2004)' on_dme_2005 length=3 format=1. label='ON DME FILE INDICATOR (2005)' on_dme_2006 length=3 format=1. label='ON DME FILE INDICATOR (2006)' on_dme_2007 length=3 format=1. label='ON DME FILE INDICATOR (2007)' on_hha_1991 length=3 format=1. label='ON HHA FILE INDICATOR (1991)' on_hha_1992 length=3 format=1. label='ON HHA FILE INDICATOR (1992)' on_hha_1993 length=3 format=1. label='ON HHA FILE INDICATOR (1993)' on_hha_1994 length=3 format=1. label='ON HHA FILE INDICATOR (1994)' on_hha_1995 length=3 format=1. label='ON HHA FILE INDICATOR (1995)' on_hha_1996 length=3 format=1. label='ON HHA FILE INDICATOR (1996)' on_hha_1997 length=3 format=1. label='ON HHA FILE INDICATOR (1997)' on_hha_1998 length=3 format=1. label='ON HHA FILE INDICATOR (1998)' on_hha_1999 length=3 format=1. label='ON HHA FILE INDICATOR (1999)' on_hha_2000 length=3 format=1. label='ON HHA FILE INDICATOR (2000)' on_hha_2001 length=3 format=1. label='ON HHA FILE INDICATOR (2001)' on_hha_2002 length=3 format=1. label='ON HHA FILE INDICATOR (2002)' on_hha_2003 length=3 format=1. label='ON HHA FILE INDICATOR (2003)' on_hha_2004 length=3 format=1. label='ON HHA FILE INDICATOR (2004)' on_hha_2005 length=3 format=1. label='ON HHA FILE INDICATOR (2005)' on_hha_2006 length=3 format=1. label='ON HHA FILE INDICATOR (2006)' on_hha_2007 length=3 format=1. label='ON HHA FILE INDICATOR (2007)' on_hospice_1991 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1991)' on_hospice_1992 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1992)' on_hospice_1993 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1993)' on_hospice_1994 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1994)' on_hospice_1995 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1995)' on_hospice_1996 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1996)' on_hospice_1997 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1997)' on_hospice_1998 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1998)' on_hospice_1999 length=3 format=1. label='ON HOSPICE FILE INDICATOR (1999)' on_hospice_2000 length=3 format=1. label='ON HOSPICE FILE INDICATOR (2000)' on_hospice_2001 length=3 format=1. label='ON HOSPICE FILE INDICATOR (2001)' on_hospice_2002 length=3 format=1. label='ON HOSPICE FILE INDICATOR (2002)' on_hospice_2003 length=3 format=1. label='ON HOSPICE FILE INDICATOR (2003)' on_hospice_2004 length=3 format=1. label='ON HOSPICE FILE INDICATOR (2004)' on_hospice_2005 length=3 format=1. label='ON HOSPICE FILE INDICATOR (2005)' on_hospice_2006 length=3 format=1. label='ON HOSPICE FILE INDICATOR (2006)' on_hospice_2007 length=3 format=1. label='ON HOSPICE FILE INDICATOR (2007)' on_outpat_1991 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1991)' on_outpat_1992 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1992)' on_outpat_1993 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1993)' on_outpat_1994 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1994)' on_outpat_1995 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1995)' on_outpat_1996 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1996)' on_outpat_1997 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1997)' on_outpat_1998 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1998)' on_outpat_1999 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (1999)' on_outpat_2000 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (2000)' on_outpat_2001 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (2001)' on_outpat_2002 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (2002)' on_outpat_2003 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (2003)' on_outpat_2004 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (2004)' on_outpat_2005 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (2005)' on_outpat_2006 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (2006)' on_outpat_2007 length=3 format=1. label='ON OUTPATIENT FILE INDICATOR (2007)' on_cc_sum_2005 length=3 format=1. label='ON CHRONIC CONDITION SUMMARY FILE INDICATOR (2005)' on_cc_sum_2006 length=3 format=1. label='ON CHRONIC CONDITION SUMMARY FILE INDICATOR (2006)' on_cc_sum_2007 length=3 format=1. label='ON CHRONIC CONDITION SUMMARY FILE INDICATOR (2007)' on_partd_den_2006 length=3 format=1. label='ON PART D DENOMINATOR FILE INDICATOR (2006)' on_partd_den_2007 length=3 format=1. label='ON PART D DENOMINATOR FILE INDICATOR (2007)' on_partd_pde_2006 length=3 format=1. label='ON PART D PRESCRIPTION DRUG EVENT (PDE) FILE INDICATOR (2006)' on_partd_pde_2007 length=3 format=1. label='ON PART D PRESCRIPTION DRUG EVENT (PDE) FILE INDICATOR (2007)' ; input @ 1 PUBLICID $CHAR14. @ 1 SEQN 5. @ 1 RESNUM 6. @ 15 CMS_MEDICARE_MATCH 1. @ 16 on_DENOM_1991 1. @ 17 on_DENOM_1992 1. @ 18 on_DENOM_1993 1. @ 19 on_DENOM_1994 1. @ 20 on_DENOM_1995 1. @ 21 on_DENOM_1996 1. @ 22 on_DENOM_1997 1. @ 23 on_DENOM_1998 1. @ 24 on_DENOM_1999 1. @ 25 on_DENOM_2000 1. @ 26 on_DENOM_2001 1. @ 27 on_DENOM_2002 1. @ 28 on_DENOM_2003 1. @ 29 on_DENOM_2004 1. @ 30 on_DENOM_2005 1. @ 31 on_DENOM_2006 1. @ 32 on_DENOM_2007 1. @ 33 on_MEDPAR_1991 1. @ 34 on_MEDPAR_1992 1. @ 35 on_MEDPAR_1993 1. @ 36 on_MEDPAR_1994 1. @ 37 on_MEDPAR_1995 1. @ 38 on_MEDPAR_1996 1. @ 39 on_MEDPAR_1997 1. @ 40 on_MEDPAR_1998 1. @ 41 on_MEDPAR_1999 1. @ 42 on_MEDPAR_2000 1. @ 43 on_MEDPAR_2001 1. @ 44 on_MEDPAR_2002 1. @ 45 on_MEDPAR_2003 1. @ 46 on_MEDPAR_2004 1. @ 47 on_MEDPAR_2005 1. @ 48 on_MEDPAR_2006 1. @ 49 on_MEDPAR_2007 1. @ 50 on_CARRIER_1991 1. @ 51 on_CARRIER_1992 1. @ 52 on_CARRIER_1993 1. @ 53 on_CARRIER_1994 1. @ 54 on_CARRIER_1995 1. @ 55 on_CARRIER_1996 1. @ 56 on_CARRIER_1997 1. @ 57 on_CARRIER_1998 1. @ 58 on_CARRIER_1999 1. @ 59 on_CARRIER_2000 1. @ 60 on_CARRIER_2001 1. @ 61 on_CARRIER_2002 1. @ 62 on_CARRIER_2003 1. @ 63 on_CARRIER_2004 1. @ 64 on_CARRIER_2005 1. @ 65 on_CARRIER_2006 1. @ 66 on_CARRIER_2007 1. @ 67 on_DME_1991 1. @ 68 on_DME_1992 1. @ 69 on_DME_1993 1. @ 70 on_DME_1994 1. @ 71 on_DME_1995 1. @ 72 on_DME_1996 1. @ 73 on_DME_1997 1. @ 74 on_DME_1998 1. @ 75 on_DME_1999 1. @ 76 on_DME_2000 1. @ 77 on_DME_2001 1. @ 78 on_DME_2002 1. @ 79 on_DME_2003 1. @ 80 on_DME_2004 1. @ 81 on_DME_2005 1. @ 82 on_DME_2006 1. @ 83 on_DME_2007 1. @ 84 on_HHA_1991 1. @ 85 on_HHA_1992 1. @ 86 on_HHA_1993 1. @ 87 on_HHA_1994 1. @ 88 on_HHA_1995 1. @ 89 on_HHA_1996 1. @ 90 on_HHA_1997 1. @ 91 on_HHA_1998 1. @ 92 on_HHA_1999 1. @ 93 on_HHA_2000 1. @ 94 on_HHA_2001 1. @ 95 on_HHA_2002 1. @ 96 on_HHA_2003 1. @ 97 on_HHA_2004 1. @ 98 on_HHA_2005 1. @ 99 on_HHA_2006 1. @100 on_HHA_2007 1. @101 on_HOSPICE_1991 1. @102 on_HOSPICE_1992 1. @103 on_HOSPICE_1993 1. @104 on_HOSPICE_1994 1. @105 on_HOSPICE_1995 1. @106 on_HOSPICE_1996 1. @107 on_HOSPICE_1997 1. @108 on_HOSPICE_1998 1. @109 on_HOSPICE_1999 1. @110 on_HOSPICE_2000 1. @111 on_HOSPICE_2001 1. @112 on_HOSPICE_2002 1. @113 on_HOSPICE_2003 1. @114 on_HOSPICE_2004 1. @115 on_HOSPICE_2005 1. @116 on_HOSPICE_2006 1. @117 on_HOSPICE_2007 1. @118 on_OUTPAT_1991 1. @119 on_OUTPAT_1992 1. @120 on_OUTPAT_1993 1. @121 on_OUTPAT_1994 1. @122 on_OUTPAT_1995 1. @123 on_OUTPAT_1996 1. @124 on_OUTPAT_1997 1. @125 on_OUTPAT_1998 1. @126 on_OUTPAT_1999 1. @127 on_OUTPAT_2000 1. @128 on_OUTPAT_2001 1. @129 on_OUTPAT_2002 1. @130 on_OUTPAT_2003 1. @131 on_OUTPAT_2004 1. @132 on_OUTPAT_2005 1. @133 on_OUTPAT_2006 1. @134 on_OUTPAT_2007 1. @135 on_cc_SUM_2005 1. @136 on_cc_SUM_2006 1. @137 on_cc_SUM_2007 1. @138 on_PARTD_DEN_2006 1. @139 on_PARTD_DEN_2007 1. @140 on_PARTD_PDE_2006 1. @141 on_PARTD_PDE_2007 1. ; run ; proc contents data=Feasibility varnum ; run ; proc freq data=Feasibility (drop=PUBLICID SEQN RESNUM) ; tables _all_ /missing ; run ;