USING STATA
    
  There are two ways to read the 2017 NHAMCS Emergency Department public-use data file into Stata:

  Option 1 - Use the zipped file ED2017-stata.zip in the Stata folder on 
  the FTP server to open a complete Stata dataset of the 2017 NHAMCS Emergency Department public use file.

  The steps for this option are as follows:

  1) Create a new folder on your local workstation, for example, C:\MYFILES\ED2017

  2) Download to the new folder the file ED2017-stata.zip from the FTP server: 
     ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/dataset_documentation/nhamcs/stata

  3) ED2017-stata.zip is a compressed file which you must unzip prior to use. 
     In order to do this, double click on the file name in your directory screen; 
     an option to unzip the file should appear. A new folder, ED2017-stata, will probably 
     be created, depending on the software your system uses. The unzipped file ED2017.dta 
     will be within that folder. This is the Stata dataset. You can then 
     move the file to your preferred location.

     Alternately, you can right-click on the name of the compressed file from your directory screen. 
     On the pop-up menu, there should be an option to extract the file to a location of your choosing.


  Option 2 - Use the DO file (*.do) and dictionary file (*.dct) provided in 
  the “Stata Documentation” section of the Ambulatory Health Care Data website, 
  (under Public Use File Documentation) along with the flat data file (*.zip) 
  in the “Downloadable data files” section, to create a Stata dataset. The file that
  is created should be identical to the file described in Option 1 above. 

  The steps for this option are as follows:

  1) Create a new folder on your local workstation, for example, C:\MYFILES\ED2017

  2) Download to the new folder the 2017 NHAMCS Emergency Department dataset (ED2017.zip) from the FTP server: 
     ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/datasets/nhamcs

  3) ED2017.zip is a compressed file which must be unzipped prior to use.

     In order to do this, double click on the file name in your directory screen; 
     an option to unzip the file should appear. A new folder, ED2017, will probably 
     be created, depending on the software your system uses. The unzipped file ED2017 
     with no extension will be within that folder. This is the NHAMCS Emergency Department ASCII 
     dataset. You can then move the file to your preferred location. 

     IMPORTANT: Stata requires a file extension to recognize this as a data file, 
     so simply rename it as ED2017.raw.

  4) Download to the new folder the ED2017.do and eddict2017.dct files from the FTP server:
     ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/dataset_documentation/nhamcs/stata

  4) Open Stata, then open "New Do-file Editor" from the taskbar and enter the following script, making
     sure to point to the folder on your local workstation where you have saved the Stata files:
  
     cd C:\MYFILES\ED2017\
     do ED2017

     Once this script is in the editor, you can Run Stata from the taskbar.
 
     A note on labels:

     It should be pointed out that Stata will not allow value labels for 
     character (string) format variables.  In the case of NAMCS and NHAMCS data, 
     there are a number of character or string variables, such as DIAG1 (physician's 
     first-listed diagnosis), etc.  For some character variables, we have been able 
     to redefine them as numeric without changing their basic structure and the 
     labels should work.  However, for the diagnosis variables (DIAG1, DIAG2, DIAG3, etc.) which 
     actually contain alpha characters in the string, this was not able to be done.  

     If data users experience difficulties or have suggestions for future releases of these 
     products, please contact the Ambulatory and Hospital Care Statistics Branch at 
     301-458-4600 or email at ambcare@cdc.gov.