********************************************************************* FEBRUARY 20, 2002 4:51 PM THIS IS AN EXAMPLE OF A SAS PROGRAM THAT CREATES A SAS FILE FROM THE 2000 NHIS PUBLIC USE INJPOIEP.DAT ASCII FILE NOTE: THE FORMAT DEFINITIONS GIVEN BELOW WILL RESULT IN PROCEDURE OUTPUT SHOWING VALUES THAT HAVE BEEN GROUPED AS THEY ARE SHOWN IN THE FILE LAYOUT DOCUMENTATION THIS IS STORED IN INJPOIEP.SAS *********************************************************************; * USER NOTE: PLACE NEXT TWO STATEMENTS IN SUBSEQUENT PROGRAMS; LIBNAME NHIS 'C:\NHIS2000\'; LIBNAME LIBRARY 'C:\NHIS2000\'; FILENAME ASCIIDAT 'C:\NHIS2000\INJPOIEP.DAT'; * DEFINE VARIABLE VALUES FOR REPORTS; PROC FORMAT LIBRARY=LIBRARY; VALUE IPP001X 70 = "Injury/Poisoning Episode" ; VALUE IPP002X 2000 = "2000" ; VALUE $IPP006X "01" = "First injury or poisoning" "02" = "Second injury or poisoning" "03" = "Third injury or poisoning" "04" = "Fourth injury or poisoning" "05" = "Fifth injury or poisoning" "06" = "Sixth injury or poisoning" "07" = "Seventh injury or poisoning" "08" = "Eighth injury or poisoning" "09" = "Ninth injury or poisoning" "10" = "Tenth injury or poisoning" ; VALUE IPP007X 01 = "January" 02 = "February" 03 = "March" 04 = "April" 05 = "May" 06 = "June" 07 = "July" 08 = "August" 09 = "September" 10 = "October" 11 = "November" 12 = "December" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE IPP008X 01 = "Sunday" 02 = "Monday" 03 = "Tuesday" 04 = "Wednesday" 05 = "Thursday" 06 = "Friday" 07 = "Saturday" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE IPP009X 1999 = "1999" 2000 = "2000" 2001 = "2001" 9997 = "Refused" 9998 = "Not ascertained" 9999 = "Don't know" ; VALUE IPP010X 00 - 91 = "0-91 days" 92 = "92-104 days" 93 = "Same month as interview" 94 = "Month before month of interview" 95 = "2 months before month of interview" 96 = "3 or 4 months before month of interview" 98 = "Not ascertained" ; VALUE IPP011X 1 = "Mentioned" 2 = "Not mentioned" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE IPP017X 01 - 94 = "1-94 nights" 95 = "95+ nights" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE IPP018X 01 = "Transportation (see Notes below)" 02 = "Fire/burn/scald related" 03 = "Fall" 04 = "Poisoning" 05 = "Overexertion/strenuous movements" 06 = "Struck by object or person" 07 = "Animal or insect bite" 08 = "Cut/pierce" 09 = "Machinery" 10 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE IPP020X 1 = "Driver of a vehicle" 2 = "Passenger in a vehicle" 3 = "Bicycle rider" 4 = "Pedestrian" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE IPP021X 01 = "Passenger car" 02 = "Light truck (pickups, vans, utility vehicles)" 03 = "Bus" 04 = "Large truck" 05 = "Motorcycles (including mopeds, minibikes)" 06 = "All terrain vehicle or ski/snow-mobile" 07 = "Farm equipment (tractor)" 08 = "Airplane" 09 = "Boat" 10 = "Train" 11 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE IPP022X 1 = "Yes" 2 = "No" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE IPP024X 01 = "Passenger car" 02 = "Light truck (pickups, vans, utility vehicles)" 03 = "Bus" 04 = "Large truck" 05 = "Motorcycle (including mopeds, minibikes)" 06 = "All terrain vehicle or ski or snow-mobile" 07 = "Farm equipment (tractor)" 08 = "Bicycle" 09 = "Train" 10 = "Boat (includes all on water vehicles)" 11 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE IPP025X 01 = "Cigarette, cigar, pipe" 02 = "Cooking unit" 03 = "Heater" 04 = "Wiring" 05 = "Motor vehicle battery caps, radiator caps" 06 = "Fireworks" 07 = "Other explosive" 08 = "Water or steam" 09 = "Food" 10 = "Chemicals" 11 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE IPP026X 01 = "Stairs, steps, escalator" 02 = "Floor/level ground" 03 = "Curb, including sidewalk" 04 = "Ladder or scaffolding" 05 = "Playground equipment" 06 = "Building or other structure" 07 = "Chair, bed, sofa, other furniture" 08 = "Bathtub, shower, toilet, commode" 09 = "Hole or other opening" 10 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE IPP027X 00 = "No second response" 01 = "Stairs, steps, escalator" 02 = "Floor/level ground" 03 = "Curb, including sidewalk" 04 = "Ladder or scaffolding" 05 = "Playground equipment" 06 = "Building or other structure" 07 = "Chair, bed, sofa, other furniture" 08 = "Bathtub, shower, toilet, commode" 09 = "Hole or other opening" 10 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE IPP028X 1 = "Mentioned" 2 = "Not mentioned" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE IPP038X 1 = "Slipping, tripping, or stumbling" 2 = "Jumping or diving" 3 = "Collision with/pushing, shoving by other person" 4 = "Loss of balance/dizziness/fainting/seizure" 5 = "Something else" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE IPP039X 01 = "Dog" 02 = "Cat" 03 = "Poisonous snake/reptile" 04 = "Nonpoisonous snake/reptile" 05 = "Unknown snake/reptile" 06 = "Poisonous insect" 07 = "Nonpoisonous insect" 08 = "Unknown insect" 09 = "Rodent" 10 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE IPP040X 01 = "A drug or med substance used mistakenly/od" 02 = "A harmful or toxic solid or liquid substance" 03 = "Inhaling gases or vapors" 04 = "Eating poisonous plant/substance" 05 = "A venomous animal or plant" 06 = "Food poisoning" 07 = "Allergic reaction" 08 = "Something else" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE IPP041X 01 = "Driving/riding in motor vehicle" 02 = "Working at paid job" 03 = "Working around house/yard" 04 = "Attending school" 05 = "Unpaid work" 06 = "Sports" 07 = "Leisure activity" 08 = "Sleeping, resting, eating, drinking" 09 = "Cooking" 10 = "Being cared for" 11 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE IPP042X 00 = "No second response" 01 = "Driving/riding in motor vehicle" 02 = "Working at paid job" 03 = "Working around house/yard" 04 = "Attending school" 05 = "Unpaid work" 06 = "Sports" 07 = "Leisure activity" 08 = "Sleeping, resting, eating, drinking" 09 = "Cooking" 10 = "Being cared for" 11 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE IPP054X 01 = "Inside home" 02 = "Outside home" 03 = "School" 04 = "Child care center/preschool" 05 = "Residential institution" 06 = "Health care facility" 07 = "Street/highway" 08 = "Parking lot" 09 = "Sport facility, ath field, playground" 10 = "Trade and service areas" 11 = "Farm" 12 = "Park/recreation area" 13 = "River/lake/stream/ocean" 14 = "Industrial or construction area" 15 = "Other public building" 16 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE IPP055X 00 = "No second response" 01 = "Inside home" 02 = "Outside home" 03 = "School" 04 = "Child care center/preschool" 05 = "Residential institution" 06 = "Health care facility" 07 = "Street/highway" 08 = "Parking lot" 09 = "Sport facility, ath field, playground" 10 = "Trade and service areas" 11 = "Farm" 12 = "Park/recreation area" 13 = "River/lake/stream/ocean" 14 = "Industrial or construction area" 15 = "Other public building" 16 = "Other" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE IPP072X 1 = "Not employed at the time" 2 = "None" 3 = "Less than 1 day" 4 = "One to five days" 5 = "Six or more days" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE IPP073X 1 = "Not in school at the time" 2 = "None" 3 = "Less than 1 day" 4 = "One to five days" 5 = "Six or more days" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE $IPP078X "0039" - "9999" = "ICD-9-CM codes" "V072" = "ICD-9-CM codes" "V155" = "ICD-9-CM codes" "99998" = "Not ascertained" ; VALUE $IPP079X "0039" - "9999" = "ICD-9-CM codes" "V072" = "ICD-9-CM codes" "V155" = "ICD-9-CM codes" "99998" = "Not ascertained" " " = "" ; VALUE $IPP082X "E8072" - "E989" = "E codes" "99998" = "Not ascertained" ; VALUE $IPP083X "E8072" - "E989" = "E codes" "99998" = "Not ascertained" " " = "" ; DATA NHIS.INJPOIEP; * CREATE A SAS DATA SET; INFILE ASCIIDAT PAD LRECL=150; * DEFINE LENGTH OF ALL VARIABLES; LENGTH RECTYPE 3 SRVY_YR 4 HHX $ 6 FMX $ 2 PX $ 2 IPEPNO $ 2 IJDATE_M 3 DAY 3 IJDATE_Y 4 RPCKDM 3 IJMED_2 3 IJMED_3 3 IJMED_4 3 IJMED_5 3 IJMED_6 3 IJMED_7 3 IHNO 3 CAUSNEW 3 ECAUSNEW 3 MVWHO 3 MVTYP 3 SBELT 3 HELMT 3 MVHIT 3 BURN 3 FALLNEW1 3 FALLNEW2 3 FALLN1 3 FALLN2 3 FALLN3 3 FALLN4 3 FALLN5 3 FALLN6 3 FALLN7 3 FALLN8 3 FALLN9 3 FALLN10 3 FWHY 3 ANIMAL 3 POITP 3 WHAT_1 3 WHAT_2 3 WHAT1 3 WHAT2 3 WHAT3 3 WHAT4 3 WHAT5 3 WHAT6 3 WHAT7 3 WHAT8 3 WHAT9 3 WHAT10 3 WHAT11 3 WHERNEW1 3 WHERNEW2 3 WHERN1 3 WHERN2 3 WHERN3 3 WHERN4 3 WHERN5 3 WHERN6 3 WHERN7 3 WHERN8 3 WHERN9 3 WHERN10 3 WHERN11 3 WHERN12 3 WHERN13 3 WHERN14 3 WHERN15 3 WHERN16 3 WKLS 3 SCLS 3 IJADL 3 LIMTM 3 IJIAD 3 HLIMT 3 ICD9_1 $ 5 ICD9_2 $ 5 ICD9_3 $ 5 ICD9_4 $ 5 ECODE_1 $ 5 ECODE_2 $ 5 ECODE_3 $ 5 WTFA 8 ; * INPUT ALL VARIABLES; INPUT RECTYPE 1 - 2 SRVY_YR 3 - 6 HHX $ 7 - 12 FMX $ 13 - 14 PX $ 15 - 16 IPEPNO $ 17 - 18 IJDATE_M 19 - 20 DAY 21 - 22 IJDATE_Y 23 - 26 RPCKDM 27 - 28 IJMED_2 29 - 29 IJMED_3 30 - 30 IJMED_4 31 - 31 IJMED_5 32 - 32 IJMED_6 33 - 33 IJMED_7 34 - 34 IHNO 35 - 36 CAUSNEW 37 - 38 ECAUSNEW 39 - 40 MVWHO 41 - 41 MVTYP 42 - 43 SBELT 44 - 44 HELMT 45 - 45 MVHIT 46 - 47 BURN 48 - 49 FALLNEW1 50 - 51 FALLNEW2 52 - 53 FALLN1 54 - 54 FALLN2 55 - 55 FALLN3 56 - 56 FALLN4 57 - 57 FALLN5 58 - 58 FALLN6 59 - 59 FALLN7 60 - 60 FALLN8 61 - 61 FALLN9 62 - 62 FALLN10 63 - 63 FWHY 64 - 64 ANIMAL 65 - 66 POITP 67 - 68 WHAT_1 69 - 70 WHAT_2 71 - 72 WHAT1 73 - 73 WHAT2 74 - 74 WHAT3 75 - 75 WHAT4 76 - 76 WHAT5 77 - 77 WHAT6 78 - 78 WHAT7 79 - 79 WHAT8 80 - 80 WHAT9 81 - 81 WHAT10 82 - 82 WHAT11 83 - 83 WHERNEW1 84 - 85 WHERNEW2 86 - 87 WHERN1 88 - 88 WHERN2 89 - 89 WHERN3 90 - 90 WHERN4 91 - 91 WHERN5 92 - 92 WHERN6 93 - 93 WHERN7 94 - 94 WHERN8 95 - 95 WHERN9 96 - 96 WHERN10 97 - 97 WHERN11 98 - 98 WHERN12 99 - 99 WHERN13 100 - 100 WHERN14 101 - 101 WHERN15 102 - 102 WHERN16 103 - 103 WKLS 104 - 104 SCLS 105 - 105 IJADL 106 - 106 LIMTM 107 - 107 IJIAD 108 - 108 HLIMT 109 - 109 ICD9_1 $ 110 - 114 ICD9_2 $ 115 - 119 ICD9_3 $ 120 - 124 ICD9_4 $ 125 - 129 ECODE_1 $ 130 - 134 ECODE_2 $ 135 - 139 ECODE_3 $ 140 - 144 WTFA 145 - 150; * DEFINE VARIABLE LABELS; LABEL RECTYPE ="Record Type" SRVY_YR ="Survey Year" HHX ="Household Serial Number" FMX ="Family Serial Number" PX ="Person Number" IPEPNO ="Number of injury/poisoning" IJDATE_M ="Month of injury or poisoning" DAY ="Day of week of injury/poisoning" IJDATE_Y ="Year of injury or poisoning" RPCKDM ="Time between interview and I/P dates" IJMED_2 ="Phone call to doctor" IJMED_3 ="Phone call to poison control center" IJMED_4 ="Visit to doctor's office" IJMED_5 ="Visit to clinic/outpatient dept" IJMED_6 ="Visit to emergency department" IJMED_7 ="Visit to hospital" IHNO ="Number of nights hospitalized" CAUSNEW ="Cause of injury/poisoning episode" ECAUSNEW ="Cause of injury based on E codes" MVWHO ="Injured as a driver, pass, rider, or ped" MVTYP ="Type of vehicle injured person was in" SBELT ="Wearing sbelt/in cseat attot accident" HELMT ="Wearing helmet at time of accident" MVHIT ="Type of vehicle striking pedestrian" BURN ="Cause of burn/scald" FALLNEW1 ="How person fell (1st response)" FALLNEW2 ="How person fell (2nd response)" FALLN1 ="Fell down stairs, steps, escalator" FALLN2 ="Fell on floor/level ground" FALLN3 ="Fell on or down from curb/sidewalk" FALLN4 ="Fell on or from ladder or scaffolding" FALLN5 ="Fell on or from playground equipment" FALLN6 ="Fell from building or other structure" FALLN7 ="Fell from chair/bed/sofa/other furniture" FALLN8 ="Fell from bathtub/shower/toilet/commode" FALLN9 ="Fell into hole or other opening" FALLN10 ="Fell: other" FWHY ="Cause of fall" ANIMAL ="Kind of animal or insect bite" POITP ="Cause of poisoning" WHAT_1 ="Activity when injured/poisoned(1st resp)" WHAT_2 ="Activity when injured/poisoned(2nd resp)" WHAT1 ="Driving or riding in motor vehicle" WHAT2 ="Working at paid job" WHAT3 ="Working around the house or yard" WHAT4 ="Attending school" WHAT5 ="Unpaid work (housework, volunteer)" WHAT6 ="Sports (organized team or individual)" WHAT7 ="Leisure activity (excluding sports)" WHAT8 ="Sleeping, resting, eating, drinking" WHAT9 ="Cooking" WHAT10 ="Hands on care from other person" WHAT11 ="Other" WHERNEW1 ="Place injured/poisoned (1st response)" WHERNEW2 ="Place injured/poisoned (2nd response)" WHERN1 ="Home (inside)" WHERN2 ="Home (outside)" WHERN3 ="School (not residential)" WHERN4 ="Child care center or preschool" WHERN5 ="Residential institution (excl. hospital)" WHERN6 ="Health care facility (incl. hospital)" WHERN7 ="Street/highway" WHERN8 ="Parking lot" WHERN9 ="Sport facility, athletic field, playgnd" WHERN10 ="Trade and service areas" WHERN11 ="Farm" WHERN12 ="Park/recreation area" WHERN13 ="River/lake/stream/ocean" WHERN14 ="Industrial or construction area" WHERN15 ="Other public building" WHERN16 ="Other" WKLS ="Days absent from work" SCLS ="Days absent from school" IJADL ="Need help with personal care needs" LIMTM ="Help with personal care needs for 6 mo+" IJIAD ="Need help with routine needs" HLIMT ="Need help with routine needs for 6 mo+" ICD9_1 ="ICD-9-CM diagnosis code" ICD9_2 ="ICD-9-CM diagnosis code" ICD9_3 ="ICD-9-CM diagnosis code" ICD9_4 ="ICD-9-CM diagnosis code" ECODE_1 ="ICD-9-CM External cause code" ECODE_2 ="ICD-9-CM External cause code" ECODE_3 ="ICD-9-CM External cause code" WTFA ="Weight - Final Annual" ; * ASSOCIATE VARIABLES WITH FORMAT VALUES; FORMAT RECTYPE IPP001X. SRVY_YR IPP002X. IPEPNO $IPP006X. IJDATE_M IPP007X. DAY IPP008X. IJDATE_Y IPP009X. RPCKDM IPP010X. IJMED_2 IPP011X. IJMED_3 IPP011X. IJMED_4 IPP011X. IJMED_5 IPP011X. IJMED_6 IPP011X. IJMED_7 IPP011X. IHNO IPP017X. CAUSNEW IPP018X. ECAUSNEW IPP018X. MVWHO IPP020X. MVTYP IPP021X. SBELT IPP022X. HELMT IPP022X. MVHIT IPP024X. BURN IPP025X. FALLNEW1 IPP026X. FALLNEW2 IPP027X. FALLN1 IPP028X. FALLN2 IPP028X. FALLN3 IPP028X. FALLN4 IPP028X. FALLN5 IPP028X. FALLN6 IPP028X. FALLN7 IPP028X. FALLN8 IPP028X. FALLN9 IPP028X. FALLN10 IPP028X. FWHY IPP038X. ANIMAL IPP039X. POITP IPP040X. WHAT_1 IPP041X. WHAT_2 IPP042X. WHAT1 IPP011X. WHAT2 IPP011X. WHAT3 IPP011X. WHAT4 IPP011X. WHAT5 IPP011X. WHAT6 IPP011X. WHAT7 IPP011X. WHAT8 IPP011X. WHAT9 IPP011X. WHAT10 IPP011X. WHAT11 IPP011X. WHERNEW1 IPP054X. WHERNEW2 IPP055X. WHERN1 IPP011X. WHERN2 IPP011X. WHERN3 IPP011X. WHERN4 IPP011X. WHERN5 IPP011X. WHERN6 IPP011X. WHERN7 IPP011X. WHERN8 IPP011X. WHERN9 IPP011X. WHERN10 IPP011X. WHERN11 IPP011X. WHERN12 IPP011X. WHERN13 IPP011X. WHERN14 IPP011X. WHERN15 IPP011X. WHERN16 IPP011X. WKLS IPP072X. SCLS IPP073X. IJADL IPP022X. LIMTM IPP022X. IJIAD IPP022X. HLIMT IPP022X. ICD9_1 $IPP078X. ICD9_2 $IPP079X. ICD9_3 $IPP079X. ICD9_4 $IPP079X. ECODE_1 $IPP082X. ECODE_2 $IPP083X. ECODE_3 $IPP083X.; PROC CONTENTS DATA=NHIS.INJPOIEP; TITLE1 'CONTENTS OF THE 2000 NHIS INJPOIEP FILE'; PROC FREQ DATA=NHIS.INJPOIEP; TITLE1 'FREQUENCY REPORT FOR 2000 NHIS INJPOIEP FILE'; TITLE2 '(WEIGHTED)'; TABLES RECTYPE/LIST MISSING; WEIGHT WTFA ; PROC FREQ DATA=NHIS.INJPOIEP; TITLE1 'FREQUENCY REPORT FOR 2000 NHIS INJPOIEP FILE'; TITLE2 '(UNWEIGHTED)'; TABLES RECTYPE/LIST MISSING; * USER NOTE: TO SEE UNFORMATTED VALUES IN PROCEDURES, ADD THE STATEMENT: FORMAT _ALL_; RUN;