/********************************************************************* January 2019 THIS IS AN EXAMPLE OF A PROGRAM THAT CAN BE USED TO READ IN THE PUBLIC-USE CMS MEDICAID FEASIBILITY ASCII FILE AND RUN BASIC FREQUENCIES. NOTE: THE FORMAT DEFINITIONS GIVEN BELOW WILL RESULT IN PROCEDURE OUTPUT SHOWING VALUES THAT HAVE BEEN GROUPED AS THEY ARE SHOWN IN THE FILE LAYOUT DOCUMENTATION. *********************************************************************** TO DOWNLOAD AND SAVE THE PUBLIC-USE CMS MEDICAID FEASIBILITY FILES TO YOUR HARD DRIVE, FOLLOW THESE STEPS: *STEP 1: DESIGNATE A FOLDER ON YOUR HARD DRIVE TO DOWNLOAD THE PUBLIC-USE CMS MEDICAID FEASIBILITY FILE. IN THIS EXAMPLE, THE DATA WILL BE SAVED TO: 'C:\PUBLIC USE DATA' *STEP 2: TO DOWNLOAD THE PUBLIC-USE CMS MEDICAID FEASIBILITY FILE, GO TO THE WEB SITE: ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/datalinkage/feasibility_study_data/CMS/medicaid/ RIGHT CLICK ON THE DESIRED SURVEY LINK AND SELECT "Save Target as...". A "Save as" SCREEN WILL APPEAR AND YOU WILL NEED TO SELECT AND INPUT A LOCATION WHERE TO SAVE THE DATA FILE ON YOUR HARD DRIVE. IT IS ALSO IMPORTANT THAT THE BOX "Save Type as" reads ".dat Document". THIS WILL ENSURE THAT THE DATA FILE IS SAVED TO YOUR HARD DRIVE IN THE CORRECT FORMAT. IN THIS EXAMPLE, WE SAVE THE DATA FILE IN THE FOLDER 'C:\PUBLIC USE DATA\' AND SAVE THE DATA FILE AS "MEDICAID_FEASIBILITY_NHIS_1998.DAT". ***********************************************************************/ # delimit ; clear; * set mem 200m NO LONGER NEEDED IN NEWER VERSIONS OF STATA; * cd "C:\Public Use Data\" * SUBSTITUTE YOUR OWN LOCAL DIRECTORY IF NEEDED; cd "" ; //READ IN THE PUBLIC-USE CMS MEDICAID FEASIBILITY FILE //INPUT ALL VARIABLES //NOTE: When reading in the .DAT, you must modify the INFIX statement so that only one ID variable (the one applicable to the survey being used) is read in. For each different survey, the ID variables are as follows: //publicid: PUBLIC-USE ID FOR NHIS AND LSOA II //seqn: PUBLIC-USE ID FOR NHANES //resnum: PUBLIC-USE ID FOR NNHS //patnum: PUBLIC-USE ID FOR NHHCS infix str publicid 1-14 seqn 1-5 resnum 1-6 patnum 1-6 CMS_MEDICAID_MATCH 15 ON_PS_1999 16 ON_PS_2000 17 ON_PS_2001 18 ON_PS_2002 19 ON_PS_2003 20 ON_PS_2004 21 ON_PS_2005 22 ON_PS_2006 23 ON_PS_2007 24 ON_PS_2008 25 ON_PS_2009 26 ON_PS_2010 27 ON_PS_2011 28 ON_PS_2012 29 ON_PS_2013 30 ON_PS_2014 31 ON_IP_1999 32 ON_IP_2000 33 ON_IP_2001 34 ON_IP_2002 35 ON_IP_2003 36 ON_IP_2004 37 ON_IP_2005 38 ON_IP_2006 39 ON_IP_2007 40 ON_IP_2008 41 ON_IP_2009 42 ON_IP_2010 43 ON_IP_2011 44 ON_IP_2012 45 ON_IP_2013 46 ON_IP_2014 47 ON_LT_1999 48 ON_LT_2000 49 ON_LT_2001 50 ON_LT_2002 51 ON_LT_2003 52 ON_LT_2004 53 ON_LT_2005 54 ON_LT_2006 55 ON_LT_2007 56 ON_LT_2008 57 ON_LT_2009 58 ON_LT_2010 59 ON_LT_2011 60 ON_LT_2012 61 ON_LT_2013 62 ON_LT_2014 63 ON_OT_1999 64 ON_OT_2000 65 ON_OT_2001 66 ON_OT_2002 67 ON_OT_2003 68 ON_OT_2004 69 ON_OT_2005 70 ON_OT_2006 71 ON_OT_2007 72 ON_OT_2008 73 ON_OT_2009 74 ON_OT_2010 75 ON_OT_2011 76 ON_OT_2012 77 ON_OT_2013 78 ON_OT_2014 79 ON_RX_1999 80 ON_RX_2000 81 ON_RX_2001 82 ON_RX_2002 83 ON_RX_2003 84 ON_RX_2004 85 ON_RX_2005 86 ON_RX_2006 87 ON_RX_2007 88 ON_RX_2008 89 ON_RX_2009 90 ON_RX_2010 91 ON_RX_2011 92 ON_RX_2012 93 ON_RX_2013 94 ON_RX_2014 95 using MEDICAID_FEASIBILITY_***survey name ***.DAT; /* DEFINE VARIABLE LABELS */ label variable publicid "PARTICIPANT IDENTIFICATION NUMBER"; label variable seqn "SAMPLE SEQUENCE NUMBER"; label variable resnum "RESIDENT RECORD (CASE) NUMBER"; label variable patnum "PATIENT/DISCHARGE RECORD (CASE) NUMBER"; label variable CMS_MEDICAID_MATCH "CMS MEDICAID MATCH STATUS"; label variable ON_PS_1999 "ON MAX PERSON SUMMARY FILE INDICATOR (1999)"; label variable ON_PS_2000 "ON MAX PERSON SUMMARY FILE INDICATOR (2000)"; label variable ON_PS_2001 "ON MAX PERSON SUMMARY FILE INDICATOR (2001)"; label variable ON_PS_2002 "ON MAX PERSON SUMMARY FILE INDICATOR (2002)"; label variable ON_PS_2003 "ON MAX PERSON SUMMARY FILE INDICATOR (2003)"; label variable ON_PS_2004 "ON MAX PERSON SUMMARY FILE INDICATOR (2004)"; label variable ON_PS_2005 "ON MAX PERSON SUMMARY FILE INDICATOR (2005)"; label variable ON_PS_2006 "ON MAX PERSON SUMMARY FILE INDICATOR (2006)"; label variable ON_PS_2007 "ON MAX PERSON SUMMARY FILE INDICATOR (2007)"; label variable ON_PS_2008 "ON MAX PERSON SUMMARY FILE INDICATOR (2008)"; label variable ON_PS_2009 "ON MAX PERSON SUMMARY FILE INDICATOR (2009)"; label variable ON_PS_2010 "ON MAX PERSON SUMMARY FILE INDICATOR (2010)"; label variable ON_PS_2011 "ON MAX PERSON SUMMARY FILE INDICATOR (2011)"; label variable ON_PS_2012 "ON MAX PERSON SUMMARY FILE INDICATOR (2012)"; label variable ON_PS_2013 "ON MAX PERSON SUMMARY FILE INDICATOR (2013)"; label variable ON_PS_2014 "ON MAX PERSON SUMMARY FILE INDICATOR (2014)"; label variable ON_IP_1999 "ON MAX INPATIENT FILE INDICATOR (1999)"; label variable ON_IP_2000 "ON MAX INPATIENT FILE INDICATOR (2000)"; label variable ON_IP_2001 "ON MAX INPATIENT FILE INDICATOR (2001)"; label variable ON_IP_2002 "ON MAX INPATIENT FILE INDICATOR (2002)"; label variable ON_IP_2003 "ON MAX INPATIENT FILE INDICATOR (2003)"; label variable ON_IP_2004 "ON MAX INPATIENT FILE INDICATOR (2004)"; label variable ON_IP_2005 "ON MAX INPATIENT FILE INDICATOR (2005)"; label variable ON_IP_2006 "ON MAX INPATIENT FILE INDICATOR (2006)"; label variable ON_IP_2007 "ON MAX INPATIENT FILE INDICATOR (2007)"; label variable ON_IP_2008 "ON MAX INPATIENT FILE INDICATOR (2008)"; label variable ON_IP_2009 "ON MAX INPATIENT FILE INDICATOR (2009)"; label variable ON_IP_2010 "ON MAX INPATIENT FILE INDICATOR (2010)"; label variable ON_IP_2011 "ON MAX INPATIENT FILE INDICATOR (2011)"; label variable ON_IP_2012 "ON MAX INPATIENT FILE INDICATOR (2012)"; label variable ON_IP_2013 "ON MAX INPATIENT FILE INDICATOR (2013)"; label variable ON_IP_2014 "ON MAX INPATIENT FILE INDICATOR (2014)"; label variable ON_LT_1999 "ON MAX LONG TERM FILE INDICATOR (1999)"; label variable ON_LT_2000 "ON MAX LONG TERM FILE INDICATOR (2000)"; label variable ON_LT_2001 "ON MAX LONG TERM FILE INDICATOR (2001)"; label variable ON_LT_2002 "ON MAX LONG TERM FILE INDICATOR (2002)"; label variable ON_LT_2003 "ON MAX LONG TERM FILE INDICATOR (2003)"; label variable ON_LT_2004 "ON MAX LONG TERM FILE INDICATOR (2004)"; label variable ON_LT_2005 "ON MAX LONG TERM FILE INDICATOR (2005)"; label variable ON_LT_2006 "ON MAX LONG TERM FILE INDICATOR (2006)"; label variable ON_LT_2007 "ON MAX LONG TERM FILE INDICATOR (2007)"; label variable ON_LT_2008 "ON MAX LONG TERM FILE INDICATOR (2008)"; label variable ON_LT_2009 "ON MAX LONG TERM FILE INDICATOR (2009)"; label variable ON_LT_2010 "ON MAX LONG TERM FILE INDICATOR (2010)"; label variable ON_LT_2011 "ON MAX LONG TERM FILE INDICATOR (2011)"; label variable ON_LT_2012 "ON MAX LONG TERM FILE INDICATOR (2012)"; label variable ON_LT_2013 "ON MAX LONG TERM FILE INDICATOR (2013)"; label variable ON_LT_2014 "ON MAX LONG TERM FILE INDICATOR (2014)"; label variable ON_OT_1999 "ON MAX OTHER SERVICES FILE INDICATOR (1999)"; label variable ON_OT_2000 "ON MAX OTHER SERVICES FILE INDICATOR (2000)"; label variable ON_OT_2001 "ON MAX OTHER SERVICES FILE INDICATOR (2001)"; label variable ON_OT_2002 "ON MAX OTHER SERVICES FILE INDICATOR (2002)"; label variable ON_OT_2003 "ON MAX OTHER SERVICES FILE INDICATOR (2003)"; label variable ON_OT_2004 "ON MAX OTHER SERVICES FILE INDICATOR (2004)"; label variable ON_OT_2005 "ON MAX OTHER SERVICES FILE INDICATOR (2005)"; label variable ON_OT_2006 "ON MAX OTHER SERVICES FILE INDICATOR (2006)"; label variable ON_OT_2007 "ON MAX OTHER SERVICES FILE INDICATOR (2007)"; label variable ON_OT_2008 "ON MAX OTHER SERVICES FILE INDICATOR (2008)"; label variable ON_OT_2009 "ON MAX OTHER SERVICES FILE INDICATOR (2009)"; label variable ON_OT_2010 "ON MAX OTHER SERVICES FILE INDICATOR (2010)"; label variable ON_OT_2011 "ON MAX OTHER SERVICES FILE INDICATOR (2011)"; label variable ON_OT_2012 "ON MAX OTHER SERVICES FILE INDICATOR (2012)"; label variable ON_OT_2013 "ON MAX OTHER SERVICES FILE INDICATOR (2013)"; label variable ON_OT_2014 "ON MAX OTHER SERVICES FILE INDICATOR (2014)"; label variable ON_RX_1999 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (1999)"; label variable ON_RX_2000 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2000)"; label variable ON_RX_2001 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2001)"; label variable ON_RX_2002 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2002)"; label variable ON_RX_2003 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2003)"; label variable ON_RX_2004 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2004)"; label variable ON_RX_2005 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2005)"; label variable ON_RX_2006 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2006)"; label variable ON_RX_2007 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2007)"; label variable ON_RX_2008 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2008)"; label variable ON_RX_2009 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2009)"; label variable ON_RX_2010 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2010)"; label variable ON_RX_2011 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2011)"; label variable ON_RX_2012 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2012)"; label variable ON_RX_2013 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2013)"; label variable ON_RX_2014 "ON MAX PRESRCIPTION DRUG FILE INDICATOR (2014)"; /* DEFINE VALUE LABELS FOR REPORTS */ /* DISPLAY OVERALL DESCRIPTION OF FILE */ describe; /*RUN FREQUENCIES- UNWEIGHTED */ tabulate CMS_MEDICAID_MATCH, missing; tabulate ON_PS_1999, missing; tabulate ON_PS_2000, missing; tabulate ON_PS_2001, missing; tabulate ON_PS_2002, missing; tabulate ON_PS_2003, missing; tabulate ON_PS_2004, missing; tabulate ON_PS_2005, missing; tabulate ON_PS_2006, missing; tabulate ON_PS_2007, missing; tabulate ON_PS_2008, missing; tabulate ON_PS_2009, missing; tabulate ON_PS_2010, missing; tabulate ON_PS_2011, missing; tabulate ON_PS_2012, missing; tabulate ON_PS_2013, missing; tabulate ON_PS_2014, missing; tabulate ON_IP_1999, missing; tabulate ON_IP_2000, missing; tabulate ON_IP_2001, missing; tabulate ON_IP_2002, missing; tabulate ON_IP_2003, missing; tabulate ON_IP_2004, missing; tabulate ON_IP_2005, missing; tabulate ON_IP_2006, missing; tabulate ON_IP_2007, missing; tabulate ON_IP_2008, missing; tabulate ON_IP_2009, missing; tabulate ON_IP_2010, missing; tabulate ON_IP_2011, missing; tabulate ON_IP_2012, missing; tabulate ON_IP_2013, missing; tabulate ON_IP_2014, missing; tabulate ON_LT_1999, missing; tabulate ON_LT_2000, missing; tabulate ON_LT_2001, missing; tabulate ON_LT_2002, missing; tabulate ON_LT_2003, missing; tabulate ON_LT_2004, missing; tabulate ON_LT_2005, missing; tabulate ON_LT_2006, missing; tabulate ON_LT_2007, missing; tabulate ON_LT_2008, missing; tabulate ON_LT_2009, missing; tabulate ON_LT_2010, missing; tabulate ON_LT_2011, missing; tabulate ON_LT_2012, missing; tabulate ON_LT_2013, missing; tabulate ON_LT_2014, missing; tabulate ON_OT_1999, missing; tabulate ON_OT_2000, missing; tabulate ON_OT_2001, missing; tabulate ON_OT_2002, missing; tabulate ON_OT_2003, missing; tabulate ON_OT_2004, missing; tabulate ON_OT_2005, missing; tabulate ON_OT_2006, missing; tabulate ON_OT_2007, missing; tabulate ON_OT_2008, missing; tabulate ON_OT_2009, missing; tabulate ON_OT_2010, missing; tabulate ON_OT_2011, missing; tabulate ON_OT_2012, missing; tabulate ON_OT_2013, missing; tabulate ON_OT_2014, missing; tabulate ON_RX_1999, missing; tabulate ON_RX_2000, missing; tabulate ON_RX_2001, missing; tabulate ON_RX_2002, missing; tabulate ON_RX_2003, missing; tabulate ON_RX_2004, missing; tabulate ON_RX_2005, missing; tabulate ON_RX_2006, missing; tabulate ON_RX_2007, missing; tabulate ON_RX_2008, missing; tabulate ON_RX_2009, missing; tabulate ON_RX_2010, missing; tabulate ON_RX_2011, missing; tabulate ON_RX_2012, missing; tabulate ON_RX_2013, missing; tabulate ON_RX_2014, missing; /* DATA FILE IS STORED IN ***SURVEY***PMORT.DTA */ save **** survey name ****_MED_feas, replace; #delimit cr