********************************************************************* SEPTEMBER 30, 2003 5:25 PM THIS IS AN EXAMPLE OF A SAS PROGRAM THAT CREATES A SAS FILE FROM THE 2002 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:\NHIS2002\'; LIBNAME LIBRARY 'C:\NHIS2002\'; FILENAME ASCIIDAT 'C:\NHIS2002\INJPOIEP.DAT'; * DEFINE VARIABLE VALUES FOR REPORTS; PROC FORMAT LIBRARY=LIBRARY; VALUE INP001X 70 = "Injury/Poisoning Episode" ; VALUE INP002X 2002 = "2002" ; VALUE $INP006X "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 INP007X 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 INP008X 01 = "Sunday" 02 = "Monday" 03 = "Tuesday" 04 = "Wednesday" 05 = "Thursday" 06 = "Friday" 07 = "Saturday" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE INP009X 2001 = "2001" 2002 = "2002" 2003 = "2003" 9997 = "Refused" 9998 = "Not ascertained" 9999 = "Don't know" ; VALUE INP010X 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 INP011X 1 = "Mentioned" 2 = "Not mentioned" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE INP017X 01 - 94 = "1-94 nights" 95 = "95+ nights" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; VALUE INP018X 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 INP020X 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 INP021X 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 INP022X 1 = "Yes" 2 = "No" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE INP024X 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 INP025X 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 INP026X 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 INP027X 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 INP028X 1 = "Mentioned" 2 = "Not mentioned" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE INP038X 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 INP039X 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 INP040X 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 INP041X 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 INP042X 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 INP054X 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 INP055X 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 INP072X 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 INP073X 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 $INP078X "0030" - "9964" = "ICD-9-CM codes" "V714" = "ICD-9-CM codes" "99998" = "Not ascertained" ; VALUE $INP079X "0030" - "9964" = "ICD-9-CM codes" "V714" = "ICD-9-CM codes" "99998" = "Not ascertained" " " = "" ; VALUE $INP082X "E8120" - "E9888"= "E codes" "99998" = "Not ascertained" ; VALUE $INP083X "E8120" - "E9888"= "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 INP001X. SRVY_YR INP002X. IPEPNO $INP006X. IJDATE_M INP007X. DAY INP008X. IJDATE_Y INP009X. RPCKDM INP010X. IJMED_2 INP011X. IJMED_3 INP011X. IJMED_4 INP011X. IJMED_5 INP011X. IJMED_6 INP011X. IJMED_7 INP011X. IHNO INP017X. CAUSNEW INP018X. ECAUSNEW INP018X. MVWHO INP020X. MVTYP INP021X. SBELT INP022X. HELMT INP022X. MVHIT INP024X. BURN INP025X. FALLNEW1 INP026X. FALLNEW2 INP027X. FALLN1 INP028X. FALLN2 INP028X. FALLN3 INP028X. FALLN4 INP028X. FALLN5 INP028X. FALLN6 INP028X. FALLN7 INP028X. FALLN8 INP028X. FALLN9 INP028X. FALLN10 INP028X. FWHY INP038X. ANIMAL INP039X. POITP INP040X. WHAT_1 INP041X. WHAT_2 INP042X. WHAT1 INP011X. WHAT2 INP011X. WHAT3 INP011X. WHAT4 INP011X. WHAT5 INP011X. WHAT6 INP011X. WHAT7 INP011X. WHAT8 INP011X. WHAT9 INP011X. WHAT10 INP011X. WHAT11 INP011X. WHERNEW1 INP054X. WHERNEW2 INP055X. WHERN1 INP011X. WHERN2 INP011X. WHERN3 INP011X. WHERN4 INP011X. WHERN5 INP011X. WHERN6 INP011X. WHERN7 INP011X. WHERN8 INP011X. WHERN9 INP011X. WHERN10 INP011X. WHERN11 INP011X. WHERN12 INP011X. WHERN13 INP011X. WHERN14 INP011X. WHERN15 INP011X. WHERN16 INP011X. WKLS INP072X. SCLS INP073X. IJADL INP022X. LIMTM INP022X. IJIAD INP022X. HLIMT INP022X. ICD9_1 $INP078X. ICD9_2 $INP079X. ICD9_3 $INP079X. ICD9_4 $INP079X. ECODE_1 $INP082X. ECODE_2 $INP083X. ECODE_3 $INP083X.; PROC CONTENTS DATA=NHIS.INJPOIEP; TITLE1 'CONTENTS OF THE 2002 NHIS INJPOIEP FILE'; PROC FREQ DATA=NHIS.INJPOIEP; TITLE1 'FREQUENCY REPORT FOR 2002 NHIS INJPOIEP FILE'; TITLE2 '(WEIGHTED)'; TABLES RECTYPE/LIST MISSING; WEIGHT WTFA ; PROC FREQ DATA=NHIS.INJPOIEP; TITLE1 'FREQUENCY REPORT FOR 2002 NHIS INJPOIEP FILE'; TITLE2 '(UNWEIGHTED)'; TABLES RECTYPE/LIST MISSING; * USER NOTE: TO SEE UNFORMATTED VALUES IN PROCEDURES, ADD THE STATEMENT: FORMAT _ALL_; RUN;