set more off; /********************************************************************** THIS IS AN EXAMPLE OF A PROGRAM THAT CAN BE USED TO READ IN THE LINKED NCHS-CMS MEDICAID (MAX) FEASIBILITY STUDY ASCII FILE. TO DOWNLOAD AND SAVE THE LINKED NCHS-CMS MEDICAID (MAX) 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 MEDICAID (MAX) 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 MEDICAID (MAX) FEASIBILITY STUDY ASCII FILE TO THE FOLDER 'C:\Feasibility Study Data\' ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/datalinkage/feasibility_study_data/CMS/Medicaid 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 USE PUBLICID AS THE ID VARIABLE FOR NHANES USE SEQN 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 MEDICAID (MAX) FEASIBILITY STUDY ASCII FILE */ /* INPUT ALL NEW VARIABLES */ infix str publicid 1-14 seqn 1-5 resnum 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_ip_1999 27 on_ip_2000 28 on_ip_2001 29 on_ip_2002 30 on_ip_2003 31 on_ip_2004 32 on_ip_2005 33 on_ip_2006 34 on_ip_2007 35 on_ip_2008 36 on_ip_2009 37 on_lt_1999 38 on_lt_2000 39 on_lt_2001 40 on_lt_2002 41 on_lt_2003 42 on_lt_2004 43 on_lt_2005 44 on_lt_2006 45 on_lt_2007 46 on_lt_2008 47 on_lt_2009 48 on_ot_1999 49 on_ot_2000 50 on_ot_2001 51 on_ot_2002 52 on_ot_2003 53 on_ot_2004 54 on_ot_2005 55 on_ot_2006 56 on_ot_2007 57 on_ot_2008 58 on_ot_2009 59 on_rx_1999 60 on_rx_2000 61 on_rx_2001 62 on_rx_2002 63 on_rx_2003 64 on_rx_2004 65 on_rx_2005 66 on_rx_2006 67 on_rx_2007 68 on_rx_2008 69 on_rx_2009 70 using MEDICAID_FEASIBILITY_[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 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_ip_1999 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (1999)"; label variable on_ip_2000 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2000)"; label variable on_ip_2001 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2001)"; label variable on_ip_2002 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2002)"; label variable on_ip_2003 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2003)"; label variable on_ip_2004 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2004)"; label variable on_ip_2005 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2005)"; label variable on_ip_2006 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2006)"; label variable on_ip_2007 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2007)"; label variable on_ip_2008 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2008)"; label variable on_ip_2009 "ON MAX INPATIENT HOSPITAL FILE INDICATOR (2009)"; label variable on_lt_1999 "ON MAX LONG TERM CARE FILE INDICATOR (1999)"; label variable on_lt_2000 "ON MAX LONG TERM CARE FILE INDICATOR (2000)"; label variable on_lt_2001 "ON MAX LONG TERM CARE FILE INDICATOR (2001)"; label variable on_lt_2002 "ON MAX LONG TERM CARE FILE INDICATOR (2002)"; label variable on_lt_2003 "ON MAX LONG TERM CARE FILE INDICATOR (2003)"; label variable on_lt_2004 "ON MAX LONG TERM CARE FILE INDICATOR (2004)"; label variable on_lt_2005 "ON MAX LONG TERM CARE FILE INDICATOR (2005)"; label variable on_lt_2006 "ON MAX LONG TERM CARE FILE INDICATOR (2006)"; label variable on_lt_2007 "ON MAX LONG TERM CARE FILE INDICATOR (2007)"; label variable on_lt_2008 "ON MAX LONG TERM CARE FILE INDICATOR (2008)"; label variable on_lt_2009 "ON MAX LONG TERM CARE FILE INDICATOR (2009)"; 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_rx_1999 "ON PRESCRIPTION DRUG FILE INDICATOR (1999)"; label variable on_rx_2000 "ON PRESCRIPTION DRUG FILE INDICATOR (2000)"; label variable on_rx_2001 "ON PRESCRIPTION DRUG FILE INDICATOR (2001)"; label variable on_rx_2002 "ON PRESCRIPTION DRUG FILE INDICATOR (2002)"; label variable on_rx_2003 "ON PRESCRIPTION DRUG FILE INDICATOR (2003)"; label variable on_rx_2004 "ON PRESCRIPTION DRUG FILE INDICATOR (2004)"; label variable on_rx_2005 "ON PRESCRIPTION DRUG FILE INDICATOR (2005)"; label variable on_rx_2006 "ON PRESCRIPTION DRUG FILE INDICATOR (2006)"; label variable on_rx_2007 "ON PRESCRIPTION DRUG FILE INDICATOR (2007)"; label variable on_rx_2008 "ON PRESCRIPTION DRUG FILE INDICATOR (2008)"; label variable on_rx_2009 "ON PRESCRIPTION DRUG FILE INDICATOR (2009)"; /* FORMAT ZERO FILL ID VARIABLES */ /*format seqn %05.0f */ /*format resnum %06.0f */ /* DISPLAY OVERALL DESCRIPTION OF FILE */ describe; codebook,all; /* DATA FILE IS STORED IN FEASIBILITY.DTA */ save feasibilty.dta, replace; #delimit cr