/************************************************************************************************/ /* Stata User File for H175 Data */ /* */ /* This file contains information and a sample Stata program to create a permanent */ /* Stata dataset for users who want to use Stata in processing the MEPS data provided */ /* in this PUF release. Stata (StataCorp) has the capability to produce */ /* appropriate standard errors for estimates from a survey with a complex sample */ /* design such as the Medical Expenditure Panel Survey (MEPS). */ /* The input file for creating a permanent Stata dataset is the ASCII data file */ /* (H175.DAT) supplied in this PUF release, which in turn can be extracted from the */ /* .EXE file. After entering the Stata interactive environment access the Stata DO-File */ /* editor by clicking on the appropriate icon in the command line at the top of the */ /* screen. Copy and paste the following Stata commands into the editor and save as a */ /* DO file. A DO file is a Stata program which may then be executed using the DO command. */ /* For example, if the DO file is named H175.DO and is located in the directory */ /* C:\MEPS\PROG, then the file may be executed by typing the following command into */ /* the Stata command line: */ /* do C:\MEPS\PROG\H175.DO */ /* The program below will output the Stata dataset H175.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H175.log, replace; clear; * INPUT ALL VARIABLES; infix str DUPERSID 1-8 byte MULTSPEC 9-10 byte MULTLOC 11-12 byte MULTLOC2 13-14 byte PRACTYPX 15-16 int NUMDOC 17-19 byte NUMPCP 20-21 byte NUMNPA 22-23 byte PRACXRAY 24-25 byte ACO 26-27 byte CAPITATD 28-29 byte MEDHOME 30-31 byte PERMCAID 32-33 byte BASESAL 34-35 byte ROLEX 36-37 byte POWNERX 38-39 byte SAMEDAY 40-41 byte PCREMIND 42-43 byte QUALCARE 44-45 byte CASEMGR 46-47 byte HOSDCCHK 48-49 byte EHREMR 50-51 byte EHRRMIND 52-53 byte SECMSGS 54-55 double MOSWT15P 56-68 int VARSTR 69-72 byte VARPSU 73-73 using H175.dat; *DEFINE VARIABLE LABELS; label variable DUPERSID "PERSON ID (DUID + PID)"; label variable MULTSPEC "MULTISPECIALTY GROUP PRACTICE"; label variable MULTLOC "DOES PRACT HAVE MORE THAN 1 LOCATION"; label variable MULTLOC2 "RESPONSES FOR ALL OR 1 LOC"; label variable PRACTYPX "PRACTICE DESCRIPTION"; label variable NUMDOC "APPROX # FT + PT PHYSICIANS IN PRACTICE"; label variable NUMPCP "APPROX # PRIM CARE PHYSICIANS IN PRACT"; label variable NUMNPA "APPROX # NURSE PRACTNRS + PHYS ASSISTS"; label variable PRACXRAY "PRACTICE XRAY CHEST & EXTREMITIES ONSITE"; label variable ACO "PARTICIPATE IN ACO W/MEDICRE OR PRIV INS"; label variable CAPITATD "PRACTICE HAS CAPITATED CONTRACTS"; label variable MEDHOME "CERTIFIED PATIENT-CENTERED MEDICAL HOME"; label variable PERMCAID "PERCENT COVERED BY MEDICAID"; label variable BASESAL "PHYSICIANS PAID BASE SALARY"; label variable ROLEX "ROLE OF RESPONDENT IN PRACTICE"; label variable POWNERX "PRACTICE OWNERSHIP"; label variable SAMEDAY "PRACT SET TIME ASIDE FOR SAME-DAY APPTS"; label variable PCREMIND "SEND PREVENTIVE CARE REMINDERS TO P"; label variable QUALCARE "REPORTS TO PHYS ON CLINICAL QUAL CARE"; label variable CASEMGR "CASE MANAGER COORDINATE PATIENT CARE"; label variable HOSDCCHK "CHECK IN W/P 48 HRS AFTER HOSP DISCHARGE"; label variable EHREMR "PRACTICE USES EHR OR EMR"; label variable EHRRMIND "EHR/EMR REMINDERS FOR GUIDELINES/SCREEN"; label variable SECMSGS "EHR/EMR EXCHANGE SECURE MESSAGES W/P"; label variable MOSWT15P "MOS FILE PERSON WEIGHT, 2015"; label variable VARSTR "VARIANCE ESTIMATION STRATUM - 2015"; label variable VARPSU "VARIANCE ESTIMATION PSU - 2015"; *DEFINE VALUE LABELS FOR REPORTS; label define H1750001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 3 "3 PRAC DOESNT KNOW WHEN PATIENTS DISCHARGED" ; label define H1750008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750010X -1 "-1 INAPPLICABLE (SINGLE LOCATION)" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 INCLUSIVE OF THE PRACTICE AS A WHOLE" 2 "2 EXCLUSIVE TO THIS LOCATION" ; label define H1750011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750012X -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 1 "1" 250 "250" ; label define H1750013X -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 1 "1" 50 "50" ; label define H1750014X -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 1 "1" 80 "80" ; label define H1750015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 LESS THAN 10 PERCENT" 2 "2 10-50 PERCENT" 3 "3 GREATER THAN 50 PERCENT" ; label define H1750017X -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 PHYSICIANS IN PRACTICE" 2 "2 ANOTHER PHYSICIAN GROUP" 3 "3 NONPROFIT/ GOVT CLINIC" 4 "4 ACADEMIC" 5 "5 HMO" 6 "6 INDEPENDENT PRACTICE" 7 "7 HOSPITAL OWNED" 8 "8 CORPORATION OWNED" 91 "91 OTHER, PLEASE SPECIFY" ; label define H1750018X -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 AN INDEPENDENT PRACTICE" 2 "2 A PHYSICIAN NETWORK OWNED BY HOSPITAL" 3 "3 A NONPROFIT OR GOVT CLINIC" 4 "4 PRACTICE OWNED BY ACADEMIC MEDICAL CENTER" 5 "5 AN HMO" 6 "6 CORPORATION OWNED" 91 "91 OTHER, PLEASE SPECIFY" ; label define H1750019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750020X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750021X -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 PRACTICE ADMINISTRATOR" 2 "2 MEDICAL DIRECTOR" 3 "3 PHYSICIAN" 4 "4 OFFICE OR OTHER MANAGER" 5 "5 OFFICE STAFF NON-MANAGERIAL" 6 "6 NON-PHYSICIAN MEDICAL" 7 "7 BILLING" 8 "8 RECEPTIONIST" 91 "91 OTHER, PLEASE SPECIFY" ; label define H1750022X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1750023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value ACO H1750001X; label value BASESAL H1750002X; label value CAPITATD H1750003X; label value CASEMGR H1750004X; label value EHREMR H1750005X; label value EHRRMIND H1750006X; label value HOSDCCHK H1750007X; label value MEDHOME H1750008X; label value MULTLOC H1750009X; label value MULTLOC2 H1750010X; label value MULTSPEC H1750011X; label value NUMDOC H1750012X; label value NUMNPA H1750013X; label value NUMPCP H1750014X; label value PCREMIND H1750015X; label value PERMCAID H1750016X; label value POWNERX H1750017X; label value PRACTYPX H1750018X; label value PRACXRAY H1750019X; label value QUALCARE H1750020X; label value ROLEX H1750021X; label value SAMEDAY H1750022X; label value SECMSGS H1750023X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H175, replace; #delimit cr * data file is stored in H175.dta * log file is stored in H175.log log close /************************************************************************************************ NOTES: 1. This program has been tested on Stata Version 10 (for Windows). 2. This program will create a permanent Stata dataset. All additional analyses can be run using this dataset. In addition to the dataset, this program creates a log file named H175.LOG and a data file named H175.DTA. If these files (H175.DTA and H175.LOG) already exist in the working directory, they will be replaced when this program is executed. 3. If the program ends prematurely, the log file will remain open. Before running this program again, the user should enter the following Stata command: log close 4. The cd command assigns C:\MEPS\DATA as the working directory and location of the input ASCII and output .DTA and .LOG files and can be modified by the user as necessary. 5. Stata commands end with a carriage return by default. The command #delimit ; temporarily changes the command ending delimiter from a carriage return to a semicolon. 6. The infix command assumes that the input variables are numeric unless the variable name is prefaced by str. For example, DUPERSID is the a string (or character) variable. ************************************************************************************************/