********************************************************************* 19JAN2000:14:19:56 THIS IS AN EXAMPLE OF A SAS PROGRAM THAT CREATES A SAS FILE FROM THE NHIS 1997 FAMILYXX.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 FAMILYXX.SAS *********************************************************************; * USER NOTE: PLACE NEXT TWO STATEMENTS IN SUBSEQUENT PROGRAMS; LIBNAME NHIS 'C:\NHIS1997\'; LIBNAME LIBRARY 'C:\NHIS1997\'; * DEFINE VARIABLE VALUES FOR REPORTS; PROC FORMAT LIBRARY=LIBRARY; VALUE FAP001X 60 = "Family" ; VALUE FAP002X 1997 = "1997" ; VALUE $FAP004X "01" - "06" = "Family number 1 thru 6" ; VALUE FAP005X 1 = "Quarter 1" 2 = "Quarter 2" 3 = "Quarter 3" 4 = "Quarter 4" ; VALUE FAP006X 01 = "Week 1" 02 = "Week 2" 03 = "Week 3" 04 = "Week 4" 05 = "Week 5" 06 = "Week 6" 07 = "Week 7" 08 = "Week 8" 09 = "Week 9" 10 = "Week 10" 11 = "Week 11" 12 = "Week 12" 13 = "Week 13" ; VALUE FAP007X 01 = "House, apartment, flat, condo" 02 = "HU in nontransient hotel, motel" 03 = "HU-permanent in transient hotel, motel" 04 = "HU in rooming house" 05 = "Mobile home/trailer w/no permanent rooms added" 06 = "Mobile home/trailer w/ 1+ permanent rooms adde" 07 = "HU not specified above" 08 = "Quarters not HU in room or board house" 09 = "Unit not permanent-transient hotel, motel" 10 = "Unoccupied site for mobile home/trailer/tent" 11 = "Student quarters in college dormitory" 12 = "Group quarter unit not specified above" 98 = "Not ascertained" ; VALUE FAP008X 1 = "Yes (gave phone number)" 2 = "No (no phone service)" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE FAP009X 1 = "Yes" 2 = "No" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE FAP011X 1 = "English" 2 = "Spanish" 3 = "English and Spanish" 4 = "Other" 8 = "Not ascertained" ; VALUE FAP012X 1 = "Northeast" 2 = "Midwest" 3 = "South" 4 = "West" ; VALUE FAP013X 1 = "5,000,000 or more" 2 = "2,500,000 - 4,999,999" 3 = "1,000,000 - 2,499,999" 4 = "500,000 - 999,999" 5 = "250,000 - 499,999" 6 = "Under 250,000" 7 = "Non-MSA" ; VALUE FAP018X 00 - 30 = "00-30 children" . = "" ; VALUE FAP021X 1 = "Yes" 2 = "No" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE FAP022X 00 - 30 = "00-30 family members" ; VALUE FAP026X 00 - 30 = "Number of members" . = "" ; VALUE FAP040X 00 - 99 = "Injury episodes" ; VALUE FAP043X 00 - 99 = "Number of poisonings" ; VALUE FAP067X 0 = "Zero" 1 = "Less than $500" 2 = "$500-$1,999" 3 = "$2,000-$2,999" 4 = "$3,000-$4,999" 5 = "$5,000 or more" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't Know" ; VALUE FAP069X 00 - 30 = "00-30 fam members" . = "" ; VALUE FAP073X 00 - 30 = "00-30 family members" . = "" ; VALUE FAP094X 01 = "0-$4999" 02 = "$5000-$9999" 03 = "$10000-$14999" 04 = "$15000-$19999" 05 = "$20000-$24999" 06 = "$25000-$34999" 07 = "$35000-$44999" 08 = "$45000-$54999" 09 = "$55000-$64999" 10 = "$65000-$74999" 11 = "$75000 and over" 12 = "$20000 or more (no detail)" 13 = "Less than $20000 (no detail)" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" ; VALUE FAP095X 01 = "Under .50" 02 = ".50 to .74" 03 = ".75 to .99" 04 = "1.00 to 1.24" 05 = "1.25 to 1.49" 06 = "1.50 to 1.74" 07 = "1.75 to 1.99" 08 = "2.00 to 2.49" 09 = "2.50 to 2.99" 10 = "3.00 to 3.49" 11 = "3.50 to 3.99" 12 = "4.00 to 4.49" 13 = "4.50 to 4.99" 14 = "5.00 and over" 96 = "Undefinable" 99 = "Unknown" ; VALUE FAP096X 1 = "Owned" 2 = "Being bought" 3 = "Rented" 4 = "Other arrangement" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE FAP099X 00 - 30 = "00-30 fam members" ; VALUE FAP101X 1 = "One adult, no child(ren) under 18" 2 = "Multiple adults, no child(ren) under 18" 3 = "One adult, 1+ child(ren) under 18" 4 = "Multiple adults, 1+ child(ren) under 18" 9 = "Unknown" ; VALUE FAP102X 01 = "Less/equal to 8th grade" 02 = "9-12th grade, no high school diploma" 03 = "High school graduate" 04 = "GED recipient" 05 = "Some college, no degree" 06 = "AA degree, technical or vocational" 07 = "AA degree, academic program" 08 = "Bachelor's degree (BA, BS, AB, BBA)" 09 = "Master's, professional, or doctoral degree" 97 = "Refused" 98 = "Not ascertained" 99 = "Don't know" . = "" ; DATA NHIS.FAMILYXX; * CREATE A SAS DATA SET STORED IN DIR 'C:\NHIS1997\'; INFILE 'C:\NHIS1997\FAMILYXX.DAT' MISSOVER TRUNCOVER LRECL=175; * DEFINE LENGTH OF NUMERIC VARIABLES; LENGTH RECTYPE 3 SRVY_YR 4 INTV_QRT 3 ASSIGNWK 3 LIVQRT 3 TELENUM 3 INSIDE 3 FM_SIZE 3 LNG_INTV 3 REGION 3 MSASIZEP 3 WTFA_FAM 8 STRATUM 4 PSU 3 FCHLMYN 3 FCHLMCT 3 FSPEDYN 3 FSPEDCT 3 FLAADLYN 3 FLAADLCT 3 FLIADLYN 3 FLIADLCT 3 FWKLIMYN 3 FWKLIMCT 3 FWALKYN 3 FWALKCT 3 FREMEMYN 3 FREMEMCT 3 FANYLYN 3 FANYLCT 3 FHSTATEX 3 FHSTATVG 3 FHSTATG 3 FHSTATFR 3 FHSTATPR 3 FINJYN 3 FINJCT1 3 FINJCT2 3 FPOISYN 3 FPOISCT1 3 FPOISCT2 3 FDMEDYN 3 FDMEDCT 3 FNMEDYN 3 FNMEDCT 3 FHOSPYN 3 FHOSPCT 3 FHCHMYN 3 FHCHMCT 3 FHCPHYN 3 FHCPHCT 3 FHCDVYN 3 FHCDVCT 3 F10DVYN 3 F10DVCT 3 FHICOVYN 3 FHICOVCT 3 FHIPRVCT 3 FHICARCT 3 FHICADCT 3 FHIMILCT 3 FHIIHSCT 3 FHIPUBCT 3 FHIOGVCT 3 FHICOST 3 FHDSTCT 3 FDGLWCT1 3 FDGLWCT2 3 FWRKLWCT 3 FSALYN 3 FSALCT 3 FSEINCYN 3 FSEINCCT 3 FSSRRYN 3 FSSRRCT 3 FPENSYN 3 FPENSCT 3 FSSIYN 3 FSSICT 3 FSSDIYN 3 FSSDICT 3 FAFDCYN 3 FAFDCCT 3 FINTRSYN 3 FINTRSCT 3 FDIVDYN 3 FDIVDCT 3 FCHSPYN 3 FCHSPCT 3 FINCOTYN 3 FINCOTCT 3 FINCGRP 3 FRAT_CAT 3 FHOUSE 3 FFDSTYN 3 FFDSTCT 3 FM_KIDS 3 FM_ELDR 3 FMTYPE 3 FM_EDUC 3 ; * INPUT ALL VARIABLES; INPUT RECTYPE 1 - 2 SRVY_YR 3 - 6 HHX $ 7 - 12 FMX $ 13 - 14 INTV_QRT 15 - 15 ASSIGNWK 16 - 17 LIVQRT 18 - 19 TELENUM 20 - 20 INSIDE 21 - 21 FM_SIZE 22 - 23 LNG_INTV 24 - 24 REGION 25 - 25 MSASIZEP 26 - 26 WTFA_FAM 27 - 32 STRATUM 33 - 35 PSU 36 - 36 FCHLMYN 37 - 37 FCHLMCT 38 - 39 FSPEDYN 40 - 40 FSPEDCT 41 - 42 FLAADLYN 43 - 43 FLAADLCT 44 - 45 FLIADLYN 46 - 46 FLIADLCT 47 - 48 FWKLIMYN 49 - 49 FWKLIMCT 50 - 51 FWALKYN 52 - 52 FWALKCT 53 - 54 FREMEMYN 55 - 55 FREMEMCT 56 - 57 FANYLYN 58 - 58 FANYLCT 59 - 60 FHSTATEX 61 - 62 FHSTATVG 63 - 64 FHSTATG 65 - 66 FHSTATFR 67 - 68 FHSTATPR 69 - 70 FINJYN 71 - 71 FINJCT1 72 - 73 FINJCT2 74 - 75 FPOISYN 76 - 76 FPOISCT1 77 - 78 FPOISCT2 79 - 80 FDMEDYN 81 - 81 FDMEDCT 82 - 83 FNMEDYN 84 - 84 FNMEDCT 85 - 86 FHOSPYN 87 - 87 FHOSPCT 88 - 89 FHCHMYN 90 - 90 FHCHMCT 91 - 92 FHCPHYN 93 - 93 FHCPHCT 94 - 95 FHCDVYN 96 - 96 FHCDVCT 97 - 98 F10DVYN 99 - 99 F10DVCT 100 - 101 FHICOVYN 102 - 102 FHICOVCT 103 - 104 FHIPRVCT 105 - 106 FHICARCT 107 - 108 FHICADCT 109 - 110 FHIMILCT 111 - 112 FHIIHSCT 113 - 114 FHIPUBCT 115 - 116 FHIOGVCT 117 - 118 FHICOST 119 - 119 FHDSTCT 120 - 121 FDGLWCT1 122 - 123 FDGLWCT2 124 - 125 FWRKLWCT 126 - 127 FSALYN 128 - 128 FSALCT 129 - 130 FSEINCYN 131 - 131 FSEINCCT 132 - 133 FSSRRYN 134 - 134 FSSRRCT 135 - 136 FPENSYN 137 - 137 FPENSCT 138 - 139 FSSIYN 140 - 140 FSSICT 141 - 142 FSSDIYN 143 - 143 FSSDICT 144 - 145 FAFDCYN 146 - 146 FAFDCCT 147 - 148 FINTRSYN 149 - 149 FINTRSCT 150 - 151 FDIVDYN 152 - 152 FDIVDCT 153 - 154 FCHSPYN 155 - 155 FCHSPCT 156 - 157 FINCOTYN 158 - 158 FINCOTCT 159 - 160 FINCGRP 161 - 162 FRAT_CAT 163 - 164 FHOUSE 165 - 165 FFDSTYN 166 - 166 FFDSTCT 167 - 168 FM_KIDS 169 - 170 FM_ELDR 171 - 172 FMTYPE 173 - 173 FM_EDUC 174 - 175; * DEFINE VARIABLE LABELS; LABEL RECTYPE ="Record Type" SRVY_YR ="Survey Year" HHX ="Household Serial Number" FMX ="Family Serial Number" INTV_QRT ="Interview Quarter" ASSIGNWK ="Assignment week" LIVQRT ="Type of living quarters" TELENUM ="Supplied telephone number" INSIDE ="Working phone inside home" FM_SIZE ="Size of family" LNG_INTV ="Language of interview" REGION ="Region" MSASIZEP ="Geographic Distribution - MSA size" WTFA_FAM ="Weight - Final Annual" STRATUM ="Stratum for variance estimation" PSU ="PSU for variance estimation" FCHLMYN ="Any child < 5 in fam w/ play lim?" FCHLMCT ="# children < 5 in fam w/ play lim" FSPEDYN ="Any child < 18 in fam rec Spec Ed/EIS?" FSPEDCT ="# children < 18 in fam rec Spec Ed/EIS" FLAADLYN ="Anyone need help w/ADL?" FLAADLCT ="# fam members needing help w/ADL" FLIADLYN ="Anyone need help w/ chores, shop?" FLIADLCT ="# fam members need help w/chores, shop" FWKLIMYN ="Anyone with work lim due to hlth prob?" FWKLIMCT ="# fam members w/ work lim (hlth)" FWALKYN ="Anyone have dif walking w/o equip?" FWALKCT ="# fam members dif walk w/o equip" FREMEMYN ="Anyone limited by dif remembering?" FREMEMCT ="# fam members w/ dif remembering" FANYLYN ="Anyone limited in any way?" FANYLCT ="# fam members w/ any limitation" FHSTATEX ="# fam members in excellent health" FHSTATVG ="# fam members in very good health" FHSTATG ="# fam members in good health" FHSTATFR ="# fam members in fair health" FHSTATPR ="# fam members in poor health" FINJYN ="Anyone w/ a serious injury (last 3 m)?" FINJCT1 ="# fam members w/ injury (last 3 m)" FINJCT2 ="# injury episodes/family (last 3 m)" FPOISYN ="Anyone w/ serious poisoning (last 3 m)?" FPOISCT1 ="# fam members poisoned (last 3 m)" FPOISCT2 ="# poisonings/family (last 3 m)" FDMEDYN ="Anyone delay med care (cost), 12m?" FDMEDCT ="# fam members delay med care (cost)" FNMEDYN ="Anyone not get med care (cost), 12m?" FNMEDCT ="# fam members not get med care (cost)" FHOSPYN ="Anyone in hosp OVERNIGHT, 12m?" FHOSPCT ="# fam members in hosp OVERNIGHT, 12m" FHCHMYN ="Anyone rec home care by hlth prof, 2 wk?" FHCHMCT ="# fam members rec home care, 2 wk" FHCPHYN ="Anyone phone a hlth prof, 2 wk?" FHCPHCT ="# fam members phone hlth care prof, 2 wk" FHCDVYN ="Anyone see hlth prof in office, 2 wk?" FHCDVCT ="# fam members see hlth prof in office" F10DVYN ="Anyone rec care 10+ times, 12m?" F10DVCT ="# fam members rec care 10+ times, 12m" FHICOVYN ="Anyone have hlth ins coverage?" FHICOVCT ="# fam members with hlth ins coverage" FHIPRVCT ="# fam members w/ private hlth ins" FHICARCT ="# fam members w/ medicare hlth ins" FHICADCT ="# fam members w/ medicaid hlth ins" FHIMILCT ="# fam members w/ military hlth ins" FHIIHSCT ="# fam members w/ IHS hlth ins" FHIPUBCT ="# fam members w/ otr state-spon hlth ins" FHIOGVCT ="# fam members w/ otr govt hlth ins" FHICOST ="Cost of fam med/dental care, past 12m" FHDSTCT ="# children < 6 in Head Start" FDGLWCT1 ="# fam members working last week" FDGLWCT2 ="# fam members look for work last week" FWRKLWCT ="# fam members work full time last week" FSALYN ="Anyone rec inc from wages/sal (last CY)?" FSALCT ="# fam members rec inc from wage/sal" FSEINCYN ="Anyone rec inc from self-emp?" FSEINCCT ="# fam members rec inc from self-emp" FSSRRYN ="Anyone rec Soc Sec or RR ret (last CY)?" FSSRRCT ="# fam members rec Soc Sec or RR ret" FPENSYN ="Anyone rec inc from otr pensions?" FPENSCT ="# fam members rec inc from otr pensions" FSSIYN ="Anyone rec inc from SSI?" FSSICT ="# fam members rec inc from SSI" FSSDIYN ="Anyone rec inc from SSDI?" FSSDICT ="# fam members rec inc from SSDI" FAFDCYN ="Anyone rec Wel/AFDC/Gen Assist?" FAFDCCT ="# fam members rec Wel/AFDC/Gen Assist" FINTRSYN ="Anyone rec int from sav/bank accts?" FINTRSCT ="# fam members rec int from sav/bank acct" FDIVDYN ="Anyone rec div from stocks, funds?" FDIVDCT ="# fam members rec div from stocks, funds" FCHSPYN ="Anyone rec inc from child support?" FCHSPCT ="# fam members rec inc from child support" FINCOTYN ="Anyone rec inc from any otr source?" FINCOTCT ="# fam members rec inc from any otr sourc" FINCGRP ="Total combined family income (grouped)" FRAT_CAT ="Ratio of fam inc to poverty threshold" FHOUSE ="Family's home tenure status" FFDSTYN ="Anyone auth to rec fd stmps last yr?" FFDSTCT ="# fam members rec fd stmps (last yr)" FM_KIDS ="# fam members aged 17 and younger" FM_ELDR ="# fam members aged 65 and older" FMTYPE ="Family Type" FM_EDUC ="Educ of adult with highest educ in fam" ; * ASSOCIATE VARIABLES WITH FORMAT VALUES; FORMAT RECTYPE FAP001X. SRVY_YR FAP002X. FMX $FAP004X. INTV_QRT FAP005X. ASSIGNWK FAP006X. LIVQRT FAP007X. TELENUM FAP008X. INSIDE FAP009X. LNG_INTV FAP011X. REGION FAP012X. MSASIZEP FAP013X. FCHLMYN FAP009X. FCHLMCT FAP018X. FSPEDYN FAP009X. FSPEDCT FAP018X. FLAADLYN FAP021X. FLAADLCT FAP022X. FLIADLYN FAP021X. FLIADLCT FAP022X. FWKLIMYN FAP009X. FWKLIMCT FAP026X. FWALKYN FAP021X. FWALKCT FAP022X. FREMEMYN FAP021X. FREMEMCT FAP022X. FANYLYN FAP021X. FANYLCT FAP022X. FHSTATEX FAP022X. FHSTATVG FAP022X. FHSTATG FAP022X. FHSTATFR FAP022X. FHSTATPR FAP022X. FINJYN FAP021X. FINJCT1 FAP022X. FINJCT2 FAP040X. FPOISYN FAP021X. FPOISCT1 FAP022X. FPOISCT2 FAP043X. FDMEDYN FAP021X. FDMEDCT FAP022X. FNMEDYN FAP021X. FNMEDCT FAP022X. FHOSPYN FAP021X. FHOSPCT FAP022X. FHCHMYN FAP021X. FHCHMCT FAP022X. FHCPHYN FAP021X. FHCPHCT FAP022X. FHCDVYN FAP021X. FHCDVCT FAP022X. F10DVYN FAP021X. F10DVCT FAP022X. FHICOVYN FAP021X. FHICOVCT FAP022X. FHIPRVCT FAP022X. FHICARCT FAP022X. FHICADCT FAP022X. FHIMILCT FAP022X. FHIIHSCT FAP022X. FHIPUBCT FAP022X. FHIOGVCT FAP022X. FHICOST FAP067X. FHDSTCT FAP018X. FDGLWCT1 FAP069X. FDGLWCT2 FAP069X. FWRKLWCT FAP069X. FSALYN FAP009X. FSALCT FAP073X. FSEINCYN FAP009X. FSEINCCT FAP073X. FSSRRYN FAP021X. FSSRRCT FAP022X. FPENSYN FAP021X. FPENSCT FAP022X. FSSIYN FAP021X. FSSICT FAP022X. FSSDIYN FAP021X. FSSDICT FAP022X. FAFDCYN FAP021X. FAFDCCT FAP022X. FINTRSYN FAP021X. FINTRSCT FAP022X. FDIVDYN FAP021X. FDIVDCT FAP022X. FCHSPYN FAP021X. FCHSPCT FAP022X. FINCOTYN FAP021X. FINCOTCT FAP022X. FINCGRP FAP094X. FRAT_CAT FAP095X. FHOUSE FAP096X. FFDSTYN FAP021X. FFDSTCT FAP022X. FM_KIDS FAP099X. FM_ELDR FAP099X. FMTYPE FAP101X. FM_EDUC FAP102X.; PROC CONTENTS DATA=NHIS.FAMILYXX; PROC FREQ DATA=NHIS.FAMILYXX; TITLE1 'FREQUENCY REPORT FOR 1997 NHIS FAMILYXX FILE'; TITLE2 '(WEIGHTED)'; TABLES RECTYPE/LIST MISSING; WEIGHT WTFA_FAM ; PROC FREQ DATA=NHIS.FAMILYXX; TITLE1 'FREQUENCY REPORT FOR 1997 NHIS FAMILYXX FILE'; TITLE2 '(UNWEIGHTED)'; TABLES RECTYPE/LIST MISSING; * USER NOTE: TO SEE UNFORMATTED VALUES IN PROCEDURES, ADD THE STATEMENT: FORMAT _ALL_; RUN;