_dta: 1. by Jean Roth , jroth@nber.org , 26 Jul 2014 obs: 35,586 vars: 254 26 Jul 2014 17:21 size: 24,127,308 (_dta has notes) ------------------------------------------------------------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------------------------------------------------------------- vmonth byte %9.0g vmonth month of visit vyear int %8.0g year of visit vdayr byte %9.0g vdayr day of week of visit - recoded age byte %18.0g age patient age in years sex byte %8.0g sex patient sex ethnic byte %22.0g ethnic patient ethnicity race byte %34.0g race patient race usetobac byte %8.0g does patient use tobacco? paytype byte %17.0g paytype primary expected source of payment rfv1 long %12.0g reason for visit #1 rfv2 long %12.0g reason for visit #2 rfv3 long %12.0g reason for visit #3 rfv13d int %8.0g reason for visit #1 - broad rfv23d int %8.0g reason for visit #2 - broad rfv33d int %8.0g reason for visit #3 - broad primcare byte %8.0g are you the patient's primary care physician? refer byte %14.0g refer was patient referred for this visit? senbefor byte %24.0g senbefo has patient been seen in this clinic before? pastvis byte %14.0g pastvis how many past visits in last 12 months? major byte %25.0g major major reason for visit episode byte %15.0g episode episode of care share byte %8.0g do other physicians share care for problem? injury byte %8.0g injury is visit related to injury, poisoning, or ... cause1 str4 %4s cause of injury #1 cause2 str4 %4s cause of injury #2 cause3 str4 %4s cause of injury #3 cause13d str3 %3s cause of injury #1 - broad cause23d str3 %3s cause of injury #2 - broad cause33d str3 %3s cause of injury #3 - broad vcause str75 %75s cause of injury-verbatim text diag1 str5 %5s physician's diagnosis #1 diag2 str5 %5s physician's diagnosis #2 diag3 str5 %5s physician's diagnosis #3 diag13d str3 %3s physician's diagnosis #1 - broad diag23d str3 %3s physician's diagnosis #2 - broad diag33d str3 %3s physician's diagnosis #3 - broad prdiag1 byte %8.0g is diag1 probable, questionable, or ruleout? prdiag2 byte %8.0g is diag2 probable, questionable, or ruleout? prdiag3 byte %8.0g is diag3 probable, questionable, or ruleout? diagscrn byte %8.0g were diagnostic services ordered or provided? genmedxm byte %8.0g general medical exam othrexam byte %8.0g other exam examwi1 str4 %4s exam write-in #1 - 4 digit examwi2 str4 %4s exam write-in #2 - 4 digit exmwi13d str3 %3s exam write-in #1 - 3 digit exmwi23d str3 %3s exam write-in #2 - 3 digit exmwi12d str2 %2s exam write-in #1 - 2 digit exmwi22d str2 %2s exam write-in #2 - 2 digit blodpres byte %8.0g blood pressure urine byte %8.0g urinalysis pap byte %8.0g pap test psa byte %8.0g psa test hematocr byte %8.0g hematocrit/hemoglobin cbc byte %8.0g cbc cholest byte %8.0g cholesterol test othblood byte %8.0g other blood test pregtest byte %8.0g pregnancy test ekg byte %8.0g ekg culture byte %8.0g culture cervcx byte %8.0g cervical culture stoolcx byte %8.0g stool culture throatcx byte %8.0g throat culture urinecx byte %8.0g urine culture othrcult byte %8.0g other culture anyimg byte %8.0g any imaging xray byte %8.0g x-ray mammo byte %8.0g mammogram ultrasnd byte %8.0g ultrasound othimage byte %8.0g other imaging scopproc byte %8.0g scope procedure scopewi1 str4 %4s scope procedure write-in #1 - 4 digit scopewi2 str4 %4s scope procedure write-in #2 - 4 digit scpwi13d str3 %3s scope procedure write-in #1 - 3 digit scpwi23d str3 %3s scope procedure write-in #2 - 3 digit scpwi12d str2 %2s scope procedure write-in #1 - 2 digit scpwi22d str2 %2s scope procedure write-in #2 - 2 digit sigcolon byte %8.0g sigmoid/colon endoscop byte %8.0g endoscopy cystosc byte %8.0g cystoscopy othdiag byte %8.0g other diagnostic service diagsc1 str4 %4s diag/screen service write-in #1 - 4 digit diagsc2 str4 %4s diag/screen service write-in #2 - 4 digit digsc13d str3 %3s diag/screen service write-in #1 - 3 digit digsc23d str3 %3s diag/screen service write-in #2 - 3 digit digsc12d str2 %2s diag/screen service write-in #1 - 2 digit digsc22d str2 %2s diag/screen service write-in #2 - 2 digit/ therprev byte %8.0g was couns/educ/therapy ordered or provided? asthmaed byte %8.0g asthma education dietnutr byte %8.0g diet/nutrition exercise byte %8.0g exercise grwthdev byte %8.0g growth/development mentlhlt byte %8.0g mental health/stress management physioth byte %8.0g physiotherapy psychoth byte %8.0g psychotherapy tobacco byte %8.0g tobacco use/exposure wtreduc byte %8.0g weight reduction othcet byte %8.0g other counseling/education/therapy amb byte %8.0g were surgical procedures ord/sched or perf? biopsy byte %8.0g biopsy excision byte %8.0g excision amb1 str4 %4s surgical procedure #1 - 4 digit amb13d str3 %3s surgical procedure #1 - 3 digit amb12d str2 %2s surgical procedure #1 - 2 digit ordperf1 byte %8.0g surg procedure #1 - ord/sched or perf? amb2 str4 %4s surgical procedure #2 - 4 digit amb23d str3 %3s surgical procedure #2 - 2 digit amb22d str2 %2s ordperf2 byte %8.0g surg procedure #2 - ord/sched or perf? med byte %8.0g were medications/injections ordered/provided? med1 str5 %5s med #1 med2 str5 %5s med #2 med3 str5 %5s med #3 med4 str5 %5s med #4 med5 str5 %5s med #5 med6 str5 %5s med #6 nummed byte %8.0g number of medications nodisp byte %8.0g no answer to disposition item nofu byte %8.0g no follow up planned retprn byte %8.0g return as needed refothmd byte %8.0g refer to other md retappt byte %8.0g return, appt. telephon byte %8.0g telephone followup admithos byte %8.0g admit to hospital othdisp byte %8.0g other disposition noprovid byte %8.0g no answer to provider item staffmd byte %8.0g staff md seen resint byte %8.0g resident/intern seen othermd byte %8.0g other md seen rn byte %8.0g rn seen lpn byte %8.0g lpn seen mednurse byte %8.0g med/nursing asst seen npnmw byte %8.0g nurse pract/midwife seen physasst byte %8.0g physician assistant seen medtech byte %8.0g med tech seen othprov byte %8.0g other provider seen patwt int %8.0g patient visit weight region byte %8.0g geographic region msa byte %8.0g visit occurred in msa or non-msa location owner byte %8.0g hospital ownership hospcode int %8.0g hospital code clintype byte %8.0g type of clinic patcode int %8.0g patient code bdatefl byte %8.0g was patient birth date imputed? sexfl byte %8.0g was patient sex imputed? racefl byte %8.0g was patient race imputed? gen1 str5 %5s generic name code for medication #1 prescr1 byte %8.0g prescription status code for medication #1 contsub1 byte %8.0g controlled substance code for medication #1 comstat1 byte %8.0g composition status code for medication #1 drug1cl1 str4 %4s drug class #1 for medication #1 drg1ing1 str5 %5s ingredient code #1 for medication #1 drg1ing2 str5 %5s ingredient code #2 for medication #1 drg1ing3 str5 %5s ingredient code #3 for medication #1 drg1ing4 str5 %5s ingredient code #4 for medication #1 drg1ing5 str5 %5s ingredient code #5 for medication #1 gen2 str5 %5s generic name code for medication #2 prescr2 byte %8.0g prescription status code for medication #2 contsub2 byte %8.0g controlled substance code for medication #2 comstat2 byte %8.0g composition status code for medication #2 drug2cl1 str4 %4s drug class #1 for medication #2 drg2ing1 str5 %5s ingredient code #1 for medication #2 drg2ing2 str5 %5s ingredient code #2 for medication #2 drg2ing3 str5 %5s ingredient code #3 for medication #2 drg2ing4 str5 %5s ingredient code #4 for medication #2 drg2ing5 str5 %5s ingredient code #5 for medication #2 gen3 str5 %5s generic name code for medication #3 prescr3 byte %8.0g prescription status code for medication #3 contsub3 byte %8.0g controlled substance code for medication #3 comstat3 byte %8.0g composition status code for medication #3 drug3cl1 str4 %4s drug class #1 for medication #3 drg3ing1 str5 %5s ingredient code #1 for medication #3 drg3ing2 str5 %5s ingredient code #2 for medication #3 drg3ing3 str5 %5s ingredient code #3 for medication #3 drg3ing4 str5 %5s ingredient code #4 for medication #3 drg3ing5 str5 %5s ingredient code #5 for medication #3 gen4 str5 %5s generic name code for medication #4 prescr4 byte %8.0g prescription status code for medication #4 contsub4 byte %8.0g controlled substance code for medication #4 comstat4 byte %8.0g composition status code for medication #4 drug4cl1 str4 %4s drug class #1 for medication #4 drg4ing1 str5 %5s ingredient code #1 for medication #4 drg4ing2 str5 %5s ingredient code #2 for medication #4 drg4ing3 str5 %5s ingredient code #3 for medication #4 drg4ing4 str5 %5s ingredient code #4 for medication #4 drg4ing5 str5 %5s ingredient code #5 for medication #4 gen5 str5 %5s generic name code for medication #5 prescr5 byte %8.0g prescription status code for medication #5 contsub5 byte %8.0g controlled substance code for medication #5 comstat5 byte %8.0g composition status code for medication #5 drug5cl1 str4 %4s drug class #1 for medication 5 drg5ing1 str5 %5s ingredient code #1 for medication #5 drg5ing2 str5 %5s ingredient code #2 for medication #5 drg5ing3 str5 %5s ingredient code #3 for medication #5 drg5ing4 str5 %5s ingredient code #4 for medication #5 drg5ing5 str5 %5s ingredient code #5 for medication #5 gen6 str5 %5s generic name code for medication #6 prescr6 byte %8.0g prescription status code for medication #6 contsub6 byte %8.0g controlled substance code for medication #6 comstat6 byte %8.0g composition status code for medication #6 drug6cl1 str4 %4s drug class #1 for medication #6 drg6ing1 str5 %5s ingredient code #1 for medication #6 drg6ing2 str5 %5s ingredient code #2 for medication #6 drg6ing3 str5 %5s ingredient code #3 for medication #6 drg6ing4 str5 %5s ingredient code #4 for medication #6 drg6ing5 str5 %5s ingredient code #5 for medication #6 racer byte %8.0g race recode agedays int %8.0g age in days for patients less than one year ager byte %8.0g age recode cause1r int %8.0g cause of injury #1 - recode cause2r int %8.0g cause of injury #2 - recode cause3r int %8.0g cause of injury #3 - recode intentr byte %8.0g intentionality of injury based on e-code diag1r long %12.0g diagnosis #1 - recode diag2r long %12.0g diagnosis #2 - recode diag3r long %12.0g diagnosis #3 - recode examwi1r int %8.0g exam write-in #1 - recode examwi2r int %8.0g exam write-in #2 - recode scopwi1r int %8.0g scope procedure write-in #1 - recode scopwi2r int %8.0g scope procedure write-in #2 - recode diagsc1r int %8.0g other diagnostic/ screening service #1 diagsc2r int %8.0g other diagnostic/ screening service #2 amb1r int %8.0g surgical procedure write-in #1 amb2r int %8.0g surgical procedure write-in #2 whocomp byte %8.0g who completed the patient record forms? settype byte %8.0g setting type blank byte %8.0g stratm int %8.0g psu stratum marker (masked) psum byte %8.0g psu marker (masked) year int %8.0g survey year 2001 subfile byte %8.0g survey identifier (constant=1 for namcs) prostrat byte %8.0g provider stratum marker provider int %8.0g provider code dept byte %8.0g hospital dept code (constant=1 for namcs) sustrat byte %8.0g hospital sampling unit stratum su int %8.0g hospital sampling unit (=001 for namcs) clinic byte %8.0g hospital clinic/emergency service area marker poppsum byte %8.0g stratum counts of psus (masked) popsum byte %8.0g # of clinic sampling units in hospital popvism byte %8.0g estimated provider visit volume (masked) popprovm byte %8.0g estimated # of inscope prov in psu (masked) cstratm long %12.0g clustered psu stratum marker (masked) cpsum long %12.0g clustered psu marker (masked) drug1cl2 str4 %4s drug class #2 for medication #1 drug1cl3 str4 %4s drug class #3 for medication #1 drug2cl2 str4 %4s drug class #2 for medication #2 drug2cl3 str4 %4s drug class #3 for medication #2 drug3cl2 str4 %4s drug class #2 for medication #3 drug3cl3 str4 %4s drug class #3 for medication #3 drug4cl2 str4 %4s drug class #2 for medication #4 drug4cl3 str4 %4s drug class #3 for medication #4 drug5cl2 str4 %4s drug class #2 for medication #5 drug5cl3 str4 %4s drug class #3 for medication #5 drug6cl2 str4 %4s drug class #2 for medication #6 drug6cl3 str4 %4s drug class #3 for medication #6 ------------------------------------------------------------------------------------------------------------------------------------- Sorted by: vmonth: 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December vdayr: 1 Sunday 2 Monday 3 Tuesday 4 Wednesday 5 Thursday 6 Friday 7 Saturday age: 0 Under one year 100 100 years and over sex: 1 Female 2 Male ethnic: 0 Blank 1 Hispanic or Latino 2 Not Hispanic or Latino race: 1 White Only 2 Black/African American only 3 Asian only 4 Native Hawaiian/Oth Pac Isl only 5 American Indian/Alaska Native only 6 More than one race reported paytype: 0 Blank 1 Private insurance 2 Medicare 3 Medicaid 5 Self-pay 6 No charge 7 Other 8 Unknown refer: 0 Blank 1 Yes 2 No 3 Unknown 8 Not applicable senbefo: 0 Blank 1 Yes, established patient 2 No, new patient pastvis: 0 Blank 1 None 2 1-2 3 3-5 4 6 or more 5 Unknown 8 Not applicable major: 0 Blank 1 Acute problem 2 Chronic problem, routine 3 Chronic problem, flare-up 4 Pre/Post-surgery 5 Preventive care episode: 0 Blank 1 Initial visit 2 Follow-up visit 3 Unknown 8 Not applicable injury: 0 No 1 Yes