/************************************************************************************************/ /* Stata User File for H173 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 */ /* (H173.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 H173.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\H173.DO */ /* The program below will output the Stata dataset H173.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H173.log, replace; clear; * INPUT ALL VARIABLES; infix str DUID 1-5 str PID 6-8 str DUPERSID 9-16 byte PANEL 17-18 byte AGE53X 19-20 byte DOBMM 21-22 int DOBYY 23-26 byte SEX 27-27 byte PSAQAGE 28-29 byte MEDVISIT 30-31 byte FLUSHOT 32-33 byte WEIGHED 34-35 double PSAQBMIX 36-39 byte WGTLOSS 40-41 byte DRINKALC 42-43 byte DRINK5 44-45 byte DRINK4 46-47 byte STOPALC 48-49 byte TOBACCO 50-51 byte OFTTOBAC 52-53 byte QUITTBAC 54-55 byte QUITMEDS 56-57 byte QUITHELP 58-59 byte MOODQUEX 60-61 byte CHECKBP 62-63 byte CHECKCHL 64-65 byte HIVTEST 66-67 byte PNEUSHOT 68-69 byte SHINGLES 70-71 byte NOASPRIN 72-73 byte DISASPRN 74-75 byte COLONCR 76-77 byte COLONOSC 78-79 byte SIGMOID 80-81 byte BLDSTOOL 82-83 byte PROSCANC 84-85 byte AGEPSAT 86-87 byte UTREMCVC 88-89 byte PAPTEST 90-91 byte PAPAGE 92-93 byte BREASTRC 94-95 byte MAMMGRAM 96-97 byte OSTEOPOR 98-99 byte BNDENSTY 100-101 byte COMMM 102-103 int COMYYYY 104-107 byte LANGUAGE 108-108 double PSAQWT 109-121 int VARSTR 122-125 byte VARPSU 126-126 using H173.dat; *DEFINE VARIABLE LABELS; label variable DUID "DWELLING UNIT ID"; label variable PID "PERSON NUMBER"; label variable DUPERSID "PERSON ID (DUID + PID)"; label variable PANEL "PANEL NUMBER"; label variable AGE53X "AGE - R5/3 (EDITED/IMPUTED)"; label variable DOBMM "DATE OF BIRTH: MONTH"; label variable DOBYY "DATE OF BIRTH: YEAR"; label variable SEX "SEX"; label variable PSAQAGE "PSAQ WHAT IS PERSON S AGE"; label variable MEDVISIT "PSAQ HOW LONG AGO WAS LAST DR VISIT"; label variable FLUSHOT "PSAQ DID PERSON HAVE FLU VACCINE PAST YR"; label variable WEIGHED "PSAQ WAS PERSON WEIGHED IN PAST YEAR"; label variable PSAQBMIX "PSAQ BODY MASS INDEX CALCULATED"; label variable WGTLOSS "PSAQ DID DR ADVISE WGHT LOSS IN PAST YR"; label variable DRINKALC "PSAQ DID DR ASK ABOUT ALCOHOL PAST YR"; label variable DRINK5 "PSAQ HAD 5+ DRINKS PER DAY IN PAST YR"; label variable DRINK4 "PSAQ HAD 4+ DRINKS PER DAY IN PAST YR"; label variable STOPALC "PSAQ DID DR ADVISE DRINK LESS IN PAST YR"; label variable TOBACCO "PSAQ DID DR ASK ABOUT SMOKING"; label variable OFTTOBAC "PSAQ HOW OFTEN DID YOU SMOKE IN PAST YR"; label variable QUITTBAC "PSAQ DID DR ADVISE SMOKE LESS IN PAST YR"; label variable QUITMEDS "PSAQ DID DR ADVSE MED QUIT SMKNG PAST YR"; label variable QUITHELP "PSAQ DR ADVSE OTH WAY QUIT SMKNG PAST YR"; label variable MOODQUEX "PSAQ DID DR ASK ANXIOUS/DEPRSSED PAST YR"; label variable CHECKBP "PSAQ DID DR CHECK BP PAST 2 YRS"; label variable CHECKCHL "PSAQ DID DR CHECK CHOLESTEROL PAST 5 YRS"; label variable HIVTEST "PSAQ DID DR TEST FOR HIV IN PAST 5 YRS"; label variable PNEUSHOT "PSAQ HAVE YOU EVER HAD PNEUMONIA SHOT"; label variable SHINGLES "PSAQ HAVE YOU EVER HAD SHINGLES VACCINE"; label variable NOASPRIN "PSAQ CANT TAKE ASPRIN FOR MEDICAL REASON"; label variable DISASPRN "PSAQ DR DISCUSS ASPIRIN PREVENTIVE USE"; label variable COLONCR "PSAQ HAD COLON CANCER OR COLON REMOVED"; label variable COLONOSC "PSAQ HAD COLONOSCOPY IN PAST 10 YRS"; label variable SIGMOID "PSAQ HAD SIGMOIDOSCOPY IN PAST 5 YRS"; label variable BLDSTOOL "PSAQ AT-HOME BLOOD STOOL TEST IN PAST YR"; label variable PROSCANC "PSAQ HAS PERSON HAD PROSTATE CANCER"; label variable AGEPSAT "PSAQ PERSON S AGE AT LAST PSA TEST"; label variable UTREMCVC "PSAQ HAD HYSTERECTOMY OR CERVICAL CANCER"; label variable PAPTEST "PSAQ HAD PAP SMEAR WITHIN PAST 5 YEARS"; label variable PAPAGE "PSAQ WHAT AGE WAS PERSON LAST PAP SMEAR"; label variable BREASTRC "PSAQ HAD BREASTS REMOVED/BREAST CANCER"; label variable MAMMGRAM "PSAQ HAD MAMMOGRAM IN PAST 2 YRS"; label variable OSTEOPOR "PSAQ DID DR DX PERSON WITH OSTEOPEROSIS"; label variable BNDENSTY "PSAQ DID PERSON HAVE BONE DENSITY SCAN"; label variable COMMM "PSAQ COMPLETION DATE MONTH"; label variable COMYYYY "PSAQ COMPLETION DATE YEAR"; label variable LANGUAGE "PSAQ LANGUAGE OF SURVEY"; label variable PSAQWT "PSAQ PANEL 18 FINAL WEIGHT"; label variable VARSTR "VARIANCE ESTIMATION STRATUM"; label variable VARPSU "VARIANCE ESTIMATION PSU"; *DEFINE VALUE LABELS FOR REPORTS; label define H1730001X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 NEVER HAD A PSA TEST" 2 "2 UNDER AGE 50" 3 "3 BETWEEN 51 AND 64" 4 "4 BETWEEN 65 AND 74" 5 "5 75 YEARS OR OLDER" ; label define H1730002X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO, IT WAS OFFERED BUT PERSON DECLINED" 3 "3 NO, FOR ANY OTHER REASON" 4 "4 BOTH NO RESPONSES SELECTED" ; label define H1730003X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730004X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730005X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730006X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730007X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730008X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO, IT WAS OFFERED BUT PERSON DECLINED" 3 "3 NO, FOR ANY OTHER REASON" 4 "4 BOTH NO RESPONSES SELECTED" ; label define H1730009X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "01 JANUARY" 10 "10 OCTOBER" 11 "11 NOVEMBER" 12 "12 DECEMBER" 2 "02 FEBRUARY" 3 "03 MARCH" 4 "04 APRIL" 5 "05 MAY" 6 "06 JUNE" 7 "07 JULY" 8 "08 AUGUST" 9 "09 SEPTEMBER" ; label define H1730010X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 2015 "2015 YEAR" ; label define H1730011X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730012X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 JANUARY" 10 "10 OCTOBER" 11 "11 NOVEMBER" 12 "12 DECEMBER" 2 "2 FEBRUARY" 3 "3 MARCH" 4 "4 APRIL" 5 "5 MAY" 6 "6 JUNE" 7 "7 JULY" 8 "8 AUGUST" 9 "9 SEPTEMBER" ; label define H1730013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H1730014X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730015X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730016X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730017X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO, IT WAS OFFERED BUT PERSON DECLINED" 3 "3 NO, FOR ANY OTHER REASON" 4 "4 BOTH NO RESPONSES SELECTED" ; label define H1730019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 ENGLISH" 2 "2 SPANISH" ; label define H1730020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 WITHIN THE PAST 12 MONTHS" 2 "2 WITHIN THE PAST 1 TO 2 YEARS" 3 "3 WITHIN THE PAST 2 TO 5 YEARS" 4 "4 MORE THAN 5 YEARS AGO" 5 "5 NEVER" ; label define H1730022X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730023X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 EVERY DAY" 2 "2 SOME DAYS" 3 "3 NOT AT ALL" ; label define H1730025X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YOUNGER THAN 35" 2 "2 35 TO 44 YEARS OLD" 3 "3 45 TO 54 YEARS OLD" 4 "4 55 TO 64 YEARS OLD" 5 "5 65 TO 74 YEARS OLD" 6 "6 75 YEARS OR OLDER" ; label define H1730027X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO, IT WAS OFFERED BUT PERSON DECLINED" 3 "3 NO, FOR ANY OTHER REASON" 4 "4 BOTH NO RESPONSES SELECTED" ; label define H1730029X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730030X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" ; label define H1730031X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" ; label define H1730032X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730033X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730034X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 MALE" 2 "2 FEMALE" ; label define H1730036X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO, IT WAS OFFERED BUT PERSON DECLINED" 3 "3 NO, FOR ANY OTHER REASON" 4 "4 BOTH NO RESPONSES SELECTED" ; label define H1730037X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO, IT WAS OFFERED BUT PERSON DECLINED" 3 "3 NO, FOR ANY OTHER REASON" 4 "4 BOTH NO RESPONSES SELECTED" ; label define H1730038X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730039X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730040X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730041X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H1730042X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value AGEPSAT H1730001X; label value BLDSTOOL H1730002X; label value BNDENSTY H1730003X; label value BREASTRC H1730004X; label value CHECKBP H1730005X; label value CHECKCHL H1730006X; label value COLONCR H1730007X; label value COLONOSC H1730008X; label value COMMM H1730009X; label value COMYYYY H1730010X; label value DISASPRN H1730011X; label value DOBMM H1730012X; label value DOBYY H1730013X; label value DRINK4 H1730014X; label value DRINK5 H1730015X; label value DRINKALC H1730016X; label value FLUSHOT H1730017X; label value HIVTEST H1730018X; label value LANGUAGE H1730019X; label value MAMMGRAM H1730020X; label value MEDVISIT H1730021X; label value MOODQUEX H1730022X; label value NOASPRIN H1730023X; label value OFTTOBAC H1730024X; label value OSTEOPOR H1730025X; label value PAPAGE H1730026X; label value PAPTEST H1730027X; label value PNEUSHOT H1730028X; label value PROSCANC H1730029X; label value PSAQAGE H1730030X; label value PSAQBMIX H1730031X; label value QUITHELP H1730032X; label value QUITMEDS H1730033X; label value QUITTBAC H1730034X; label value SEX H1730035X; label value SHINGLES H1730036X; label value SIGMOID H1730037X; label value STOPALC H1730038X; label value TOBACCO H1730039X; label value UTREMCVC H1730040X; label value WEIGHED H1730041X; label value WGTLOSS H1730042X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H173, replace; #delimit cr * data file is stored in H173.dta * log file is stored in H173.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 H173.LOG and a data file named H173.DTA. If these files (H173.DTA and H173.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. ************************************************************************************************/