/********************************************************************* 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/ NOTES: THIS PROGRAM ASSUMES THAT THE ASCII DATA FILE IS IN STATA"S WORKING DIRECTORY. AN EXAMPLE OF HOW TO CHANGE THE WORKING DIRECTORY WITHIN STATA IS THE FOLLOWING COMMAND: cd "C:\Feasibility Study Data\" *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 NHHCS USE PATNUM AS THE ID VARIABLE FOR NNHS USE RESNUM AS THE ID VARIABLE *********************************************************************/ # delimit ; clear; /* CHANGE WORKING DIRECTORY TO FIND FILE */ cd "C:\Feasibility Study Data\"; /*READ IN THE LINKED NCHS-CMS MEDICARE FEASIBILITY STUDY ASCII FILE */ /* INPUT ALL NEW VARIABLES */ infix str publicid 1-14 seqn 1-5 resnum 1-6 patnum 1-6 cms_medicare_match 15 ON_MBSF_1999 16 ON_MBSF_2000 17 ON_MBSF_2001 18 ON_MBSF_2002 19 ON_MBSF_2003 20 ON_MBSF_2004 21 ON_MBSF_2005 22 ON_MBSF_2006 23 ON_MBSF_2007 24 ON_MBSF_2008 25 ON_MBSF_2009 26 ON_MBSF_2010 27 ON_MBSF_2011 28 ON_MBSF_2012 29 ON_MBSF_2013 30 ON_MEDPAR_1999 31 ON_MEDPAR_2000 32 ON_MEDPAR_2001 33 ON_MEDPAR_2002 34 ON_MEDPAR_2003 35 ON_MEDPAR_2004 36 ON_MEDPAR_2005 37 ON_MEDPAR_2006 38 ON_MEDPAR_2007 39 ON_MEDPAR_2008 40 ON_MEDPAR_2009 41 ON_MEDPAR_2010 42 ON_MEDPAR_2011 43 ON_MEDPAR_2012 44 ON_MEDPAR_2013 45 ON_CARRIER_1999 46 ON_CARRIER_2000 47 ON_CARRIER_2001 48 ON_CARRIER_2002 49 ON_CARRIER_2003 50 ON_CARRIER_2004 51 ON_CARRIER_2005 52 ON_CARRIER_2006 53 ON_CARRIER_2007 54 ON_CARRIER_2008 55 ON_CARRIER_2009 56 ON_CARRIER_2010 57 ON_CARRIER_2011 58 ON_CARRIER_2012 59 ON_CARRIER_2013 60 ON_DME_1999 61 ON_DME_2000 62 ON_DME_2001 63 ON_DME_2002 64 ON_DME_2003 65 ON_DME_2004 66 ON_DME_2005 67 ON_DME_2006 68 ON_DME_2007 69 ON_DME_2008 70 ON_DME_2009 71 ON_DME_2010 72 ON_DME_2011 73 ON_DME_2012 74 ON_DME_2013 75 ON_HHA_1999 76 ON_HHA_2000 77 ON_HHA_2001 78 ON_HHA_2002 79 ON_HHA_2003 80 ON_HHA_2004 81 ON_HHA_2005 82 ON_HHA_2006 83 ON_HHA_2007 84 ON_HHA_2008 85 ON_HHA_2009 86 ON_HHA_2010 87 ON_HHA_2011 88 ON_HHA_2012 89 ON_HHA_2013 90 ON_HOSPICE_1999 91 ON_HOSPICE_2000 92 ON_HOSPICE_2001 93 ON_HOSPICE_2002 94 ON_HOSPICE_2003 95 ON_HOSPICE_2004 96 ON_HOSPICE_2005 97 ON_HOSPICE_2006 98 ON_HOSPICE_2007 99 ON_HOSPICE_2008 100 ON_HOSPICE_2009 101 ON_HOSPICE_2010 102 ON_HOSPICE_2011 103 ON_HOSPICE_2012 104 ON_HOSPICE_2013 105 ON_OUTPAT_1999 106 ON_OUTPAT_2000 107 ON_OUTPAT_2001 108 ON_OUTPAT_2002 109 ON_OUTPAT_2003 110 ON_OUTPAT_2004 111 ON_OUTPAT_2005 112 ON_OUTPAT_2006 113 ON_OUTPAT_2007 114 ON_OUTPAT_2008 115 ON_OUTPAT_2009 116 ON_OUTPAT_2010 117 ON_OUTPAT_2011 118 ON_OUTPAT_2012 119 ON_OUTPAT_2013 120 ON_PDE_2006 121 ON_PDE_2007 122 ON_PDE_2008 123 ON_PDE_2009 124 ON_PDE_2010 125 ON_PDE_2011 126 ON_PDE_2012 127 ON_PDE_2013 128 using MCARE_FEAS_[survey name].dat ; /* DEFINE VARIABLE LABELS */ label variable publicid "NCHS Survey Identifier - Participant Identification Number"; label variable seqn "NCHS Survey Identifier - Sample Sequence Number"; label variable resnum "NCHS Survey Identifier - Resident Record (Case) Number"; label variable patnum "NCHS Survey Identifier - Patient/Discharge Record Number"; label variable cms_medicare_match "CMS MEDICARE MATCH STATUS"; label variable ON_MBSF_1999 "ON MBSF FILE INDICATOR (1999)"; label variable ON_MBSF_2000 "ON MBSF FILE INDICATOR (2000)"; label variable ON_MBSF_2001 "ON MBSF FILE INDICATOR (2001)"; label variable ON_MBSF_2002 "ON MBSF FILE INDICATOR (2002)"; label variable ON_MBSF_2003 "ON MBSF FILE INDICATOR (2003)"; label variable ON_MBSF_2004 "ON MBSF FILE INDICATOR (2004)"; label variable ON_MBSF_2005 "ON MBSF FILE INDICATOR (2005)"; label variable ON_MBSF_2006 "ON MBSF FILE INDICATOR (2006)"; label variable ON_MBSF_2007 "ON MBSF FILE INDICATOR (2007)"; label variable ON_MBSF_2008 "ON MBSF FILE INDICATOR (2008)"; label variable ON_MBSF_2009 "ON MBSF FILE INDICATOR (2009)"; label variable ON_MBSF_2010 "ON MBSF FILE INDICATOR (2010)"; label variable ON_MBSF_2011 "ON MBSF FILE INDICATOR (2011)"; label variable ON_MBSF_2012 "ON MBSF FILE INDICATOR (2012)"; label variable ON_MBSF_2013 "ON MBSF FILE INDICATOR (2013)"; label variable ON_MEDPAR_1999 "ON MEDPAR FILE INDICATOR (1999)"; label variable ON_MEDPAR_2000 "ON MEDPAR FILE INDICATOR (2000)"; label variable ON_MEDPAR_2001 "ON MEDPAR FILE INDICATOR (2001)"; label variable ON_MEDPAR_2002 "ON MEDPAR FILE INDICATOR (2002)"; label variable ON_MEDPAR_2003 "ON MEDPAR FILE INDICATOR (2003)"; label variable ON_MEDPAR_2004 "ON MEDPAR FILE INDICATOR (2004)"; label variable ON_MEDPAR_2005 "ON MEDPAR FILE INDICATOR (2005)"; label variable ON_MEDPAR_2006 "ON MEDPAR FILE INDICATOR (2006)"; label variable ON_MEDPAR_2007 "ON MEDPAR FILE INDICATOR (2007)"; label variable ON_MEDPAR_2008 "ON MEDPAR FILE INDICATOR (2008)"; label variable ON_MEDPAR_2009 "ON MEDPAR FILE INDICATOR (2009)"; label variable ON_MEDPAR_2010 "ON MEDPAR FILE INDICATOR (2010)"; label variable ON_MEDPAR_2011 "ON MEDPAR FILE INDICATOR (2011)"; label variable ON_MEDPAR_2012 "ON MEDPAR FILE INDICATOR (2012)"; label variable ON_MEDPAR_2013 "ON MEDPAR FILE INDICATOR (2013)"; label variable ON_CARRIER_1999 "ON CARRIER FILE INDICATOR (1999)"; label variable ON_CARRIER_2000 "ON CARRIER FILE INDICATOR (2000)"; label variable ON_CARRIER_2001 "ON CARRIER FILE INDICATOR (2001)"; label variable ON_CARRIER_2002 "ON CARRIER FILE INDICATOR (2002)"; label variable ON_CARRIER_2003 "ON CARRIER FILE INDICATOR (2003)"; label variable ON_CARRIER_2004 "ON CARRIER FILE INDICATOR (2004)"; label variable ON_CARRIER_2005 "ON CARRIER FILE INDICATOR (2005)"; label variable ON_CARRIER_2006 "ON CARRIER FILE INDICATOR (2006)"; label variable ON_CARRIER_2007 "ON CARRIER FILE INDICATOR (2007)"; label variable ON_CARRIER_2008 "ON CARRIER FILE INDICATOR (2008)"; label variable ON_CARRIER_2009 "ON CARRIER FILE INDICATOR (2009)"; label variable ON_CARRIER_2010 "ON CARRIER FILE INDICATOR (2010)"; label variable ON_CARRIER_2011 "ON CARRIER FILE INDICATOR (2011)"; label variable ON_CARRIER_2012 "ON CARRIER FILE INDICATOR (2012)"; label variable ON_CARRIER_2013 "ON CARRIER FILE INDICATOR (2013)"; label variable ON_DME_1999 "ON DME FILE INDICATOR (1999)"; label variable ON_DME_2000 "ON DME FILE INDICATOR (2000)"; label variable ON_DME_2001 "ON DME FILE INDICATOR (2001)"; label variable ON_DME_2002 "ON DME FILE INDICATOR (2002)"; label variable ON_DME_2003 "ON DME FILE INDICATOR (2003)"; label variable ON_DME_2004 "ON DME FILE INDICATOR (2004)"; label variable ON_DME_2005 "ON DME FILE INDICATOR (2005)"; label variable ON_DME_2006 "ON DME FILE INDICATOR (2006)"; label variable ON_DME_2007 "ON DME FILE INDICATOR (2007)"; label variable ON_DME_2008 "ON DME FILE INDICATOR (2008)"; label variable ON_DME_2009 "ON DME FILE INDICATOR (2009)"; label variable ON_DME_2010 "ON DME FILE INDICATOR (2010)"; label variable ON_DME_2011 "ON DME FILE INDICATOR (2011)"; label variable ON_DME_2012 "ON DME FILE INDICATOR (2012)"; label variable ON_DME_2013 "ON DME FILE INDICATOR (2013)"; label variable ON_HHA_1999 "ON HHA FILE INDICATOR (1999)"; label variable ON_HHA_2000 "ON HHA FILE INDICATOR (2000)"; label variable ON_HHA_2001 "ON HHA FILE INDICATOR (2001)"; label variable ON_HHA_2002 "ON HHA FILE INDICATOR (2002)"; label variable ON_HHA_2003 "ON HHA FILE INDICATOR (2003)"; label variable ON_HHA_2004 "ON HHA FILE INDICATOR (2004)"; label variable ON_HHA_2005 "ON HHA FILE INDICATOR (2005)"; label variable ON_HHA_2006 "ON HHA FILE INDICATOR (2006)"; label variable ON_HHA_2007 "ON HHA FILE INDICATOR (2007)"; label variable ON_HHA_2008 "ON HHA FILE INDICATOR (2008)"; label variable ON_HHA_2009 "ON HHA FILE INDICATOR (2009)"; label variable ON_HHA_2010 "ON HHA FILE INDICATOR (2010)"; label variable ON_HHA_2011 "ON HHA FILE INDICATOR (2011)"; label variable ON_HHA_2012 "ON HHA FILE INDICATOR (2012)"; label variable ON_HHA_2013 "ON HHA FILE INDICATOR (2013)"; label variable ON_HOSPICE_1999 "ON HOSPICE FILE INDICATOR (1999)"; label variable ON_HOSPICE_2000 "ON HOSPICE FILE INDICATOR (2000)"; label variable ON_HOSPICE_2001 "ON HOSPICE FILE INDICATOR (2001)"; label variable ON_HOSPICE_2002 "ON HOSPICE FILE INDICATOR (2002)"; label variable ON_HOSPICE_2003 "ON HOSPICE FILE INDICATOR (2003)"; label variable ON_HOSPICE_2004 "ON HOSPICE FILE INDICATOR (2004)"; label variable ON_HOSPICE_2005 "ON HOSPICE FILE INDICATOR (2005)"; label variable ON_HOSPICE_2006 "ON HOSPICE FILE INDICATOR (2006)"; label variable ON_HOSPICE_2007 "ON HOSPICE FILE INDICATOR (2007)"; label variable ON_HOSPICE_2008 "ON HOSPICE FILE INDICATOR (2008)"; label variable ON_HOSPICE_2009 "ON HOSPICE FILE INDICATOR (2009)"; label variable ON_HOSPICE_2010 "ON HOSPICE FILE INDICATOR (2010)"; label variable ON_HOSPICE_2011 "ON HOSPICE FILE INDICATOR (2011)"; label variable ON_HOSPICE_2012 "ON HOSPICE FILE INDICATOR (2012)"; label variable ON_HOSPICE_2013 "ON HOSPICE FILE INDICATOR (2013)"; label variable ON_OUTPAT_1999 "ON OUTPAT FILE INDICATOR (1999)"; label variable ON_OUTPAT_2000 "ON OUTPAT FILE INDICATOR (2000)"; label variable ON_OUTPAT_2001 "ON OUTPAT FILE INDICATOR (2001)"; label variable ON_OUTPAT_2002 "ON OUTPAT FILE INDICATOR (2002)"; label variable ON_OUTPAT_2003 "ON OUTPAT FILE INDICATOR (2003)"; label variable ON_OUTPAT_2004 "ON OUTPAT FILE INDICATOR (2004)"; label variable ON_OUTPAT_2005 "ON OUTPAT FILE INDICATOR (2005)"; label variable ON_OUTPAT_2006 "ON OUTPAT FILE INDICATOR (2006)"; label variable ON_OUTPAT_2007 "ON OUTPAT FILE INDICATOR (2007)"; label variable ON_OUTPAT_2008 "ON OUTPAT FILE INDICATOR (2008)"; label variable ON_OUTPAT_2009 "ON OUTPAT FILE INDICATOR (2009)"; label variable ON_OUTPAT_2010 "ON OUTPAT FILE INDICATOR (2010)"; label variable ON_OUTPAT_2011 "ON OUTPAT FILE INDICATOR (2011)"; label variable ON_OUTPAT_2012 "ON OUTPAT FILE INDICATOR (2012)"; label variable ON_OUTPAT_2013 "ON OUTPAT FILE INDICATOR (2013)"; label variable ON_PDE_2006 "ON PDE FILE INDICATOR (2006)"; label variable ON_PDE_2007 "ON PDE FILE INDICATOR (2007)"; label variable ON_PDE_2008 "ON PDE FILE INDICATOR (2008)"; label variable ON_PDE_2009 "ON PDE FILE INDICATOR (2009)"; label variable ON_PDE_2010 "ON PDE FILE INDICATOR (2010)"; label variable ON_PDE_2011 "ON PDE FILE INDICATOR (2011)"; label variable ON_PDE_2012 "ON PDE FILE INDICATOR (2012)"; label variable ON_PDE_2013 "ON PDE FILE INDICATOR (2013)"; /* FORMAT ZERO FILL ID VARIABLES */ format seqn %05.0f ; format resnum %06.0f ; format patnum %06.0f ; /* DISPLAY OVERALL DESCRIPTION OF FILE */ describe; /* DATA FILE IS STORED IN FEASIBILITY.DTA */ save feasibilty.dta, replace; #delimit cr