********************************************************************* NOVEMBER 6, 2003 8:56 AM THIS IS AN EXAMPLE OF A SAS PROGRAM THAT CREATES A SAS FILE FROM THE 2002 NHIS PUBLIC USE 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:\NHIS2002\'; LIBNAME LIBRARY 'C:\NHIS2002\'; FILENAME ASCIIDAT 'C:\NHIS2002\FAMILYXX.DAT'; * DEFINE VARIABLE VALUES FOR REPORTS; PROC FORMAT LIBRARY=LIBRARY; VALUE FAP001X 60 = "Family" ; VALUE FAP002X 2002 = "2002" ; VALUE $FAP004X "01" - "08" = "Family number 1 thru 8" ; 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 added" 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 FAP010X 01 - 08 = "01-08" ; VALUE FAP011X 00 - 07 = "00-07" ; VALUE FAP013X 1 = "English" 2 = "Spanish" 3 = "English and Spanish" 4 = "Other" 8 = "Not ascertained" ; VALUE FAP014X 1 = "Northeast" 2 = "Midwest" 3 = "South" 4 = "West" ; VALUE FAP019X 00 - 30 = "00-30 children" . = "" ; VALUE FAP022X 1 = "Yes" 2 = "No" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE FAP023X 00 - 30 = "00-30 family members" ; VALUE FAP025X 00 - 30 = "00-30 family members" . = "" ; VALUE FAP027X 00 - 30 = "Number of members" . = "" ; VALUE FAP064X 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 FAP066X 00 - 30 = "00-30 fam members" . = "" ; VALUE FAP093X 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 FAP094X 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 FAP095X 1 = "Owned or being bought" 2 = "Rented" 3 = "Other arrangement" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE FAP104X 1 = "Yes - at least 1 recipient age-eligible" 2 = "Yes - no recipients age-eligible" 3 = "No" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" . = "" ; VALUE FAP105X 00 - 30 = "00-30 fam members" ; VALUE FAP107X 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 FAP110X 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" . = "" ; VALUE FAP111X 01 - 30 = "Person number" 98 = "Not ascertained" ; DATA NHIS.FAMILYXX; * CREATE A SAS DATA SET; INFILE ASCIIDAT PAD LRECL=191; * DEFINE LENGTH OF ALL VARIABLES; LENGTH RECTYPE 3 SRVY_YR 4 HHX $ 6 FMX $ 2 INTV_QRT 3 ASSIGNWK 3 LIVQRT 3 TELENUM 3 INSIDE 3 ACPT_FAM 3 REJ_FAM 3 FM_SIZE 3 LNG_INTV 3 REGION 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 FDMEDYN 3 FDMEDCT 3 FNMEDYN 3 FNMEDCT 3 FHOSPYN 3 FHOSPCT 3 FHCHMYN 3 FHCHMCT 3 FHCPHRYN 3 FHCPHRCT 3 FHCDVYN 3 FHCDVCT 3 F10DVYN 3 F10DVCT 3 FHICOVYN 3 FHICOVCT 3 FHIPRVCT 3 FHISINCT 3 FHICARCT 3 FHICADCT 3 FHICHPCT 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 FOPENSYN 3 FOPENSCT 3 FSSIYN 3 FSSICT 3 FTANFYN 3 FTANFCT 3 FOWBENYN 3 FOWBENCT 3 FINTR1YN 3 FINTR1CT 3 FDIVDYN 3 FDIVDCT 3 FCHSPYN 3 FCHSPCT 3 FINCOTYN 3 FINCOTCT 3 FINCGRP 3 FRAT_CAT 3 FHOUSE 3 FSSAPLYN 3 FSSAPLCT 3 FSDAPLYN 3 FSDAPLCT 3 FFDSTYN 3 FFDSTCT 3 FWICYN 3 FWICCT 3 FWICYN2 3 FM_KIDS 3 FM_ELDR 3 FMTYPE 3 FMSTRCT2 3 FMSTR2 3 FM_EDUC 3 FM_RESP 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 ACPT_FAM 22 - 23 REJ_FAM 24 - 25 FM_SIZE 26 - 27 LNG_INTV 28 - 28 REGION 29 - 29 WTFA_FAM 30 - 35 STRATUM 36 - 38 PSU 39 - 39 FCHLMYN 40 - 40 FCHLMCT 41 - 42 FSPEDYN 43 - 43 FSPEDCT 44 - 45 FLAADLYN 46 - 46 FLAADLCT 47 - 48 FLIADLYN 49 - 49 FLIADLCT 50 - 51 FWKLIMYN 52 - 52 FWKLIMCT 53 - 54 FWALKYN 55 - 55 FWALKCT 56 - 57 FREMEMYN 58 - 58 FREMEMCT 59 - 60 FANYLYN 61 - 61 FANYLCT 62 - 63 FHSTATEX 64 - 65 FHSTATVG 66 - 67 FHSTATG 68 - 69 FHSTATFR 70 - 71 FHSTATPR 72 - 73 FDMEDYN 74 - 74 FDMEDCT 75 - 76 FNMEDYN 77 - 77 FNMEDCT 78 - 79 FHOSPYN 80 - 80 FHOSPCT 81 - 82 FHCHMYN 83 - 83 FHCHMCT 84 - 85 FHCPHRYN 86 - 86 FHCPHRCT 87 - 88 FHCDVYN 89 - 89 FHCDVCT 90 - 91 F10DVYN 92 - 92 F10DVCT 93 - 94 FHICOVYN 95 - 95 FHICOVCT 96 - 97 FHIPRVCT 98 - 99 FHISINCT 100 - 101 FHICARCT 102 - 103 FHICADCT 104 - 105 FHICHPCT 106 - 107 FHIMILCT 108 - 109 FHIIHSCT 110 - 111 FHIPUBCT 112 - 113 FHIOGVCT 114 - 115 FHICOST 116 - 116 FHDSTCT 117 - 118 FDGLWCT1 119 - 120 FDGLWCT2 121 - 122 FWRKLWCT 123 - 124 FSALYN 125 - 125 FSALCT 126 - 127 FSEINCYN 128 - 128 FSEINCCT 129 - 130 FSSRRYN 131 - 131 FSSRRCT 132 - 133 FPENSYN 134 - 134 FPENSCT 135 - 136 FOPENSYN 137 - 137 FOPENSCT 138 - 139 FSSIYN 140 - 140 FSSICT 141 - 142 FTANFYN 143 - 143 FTANFCT 144 - 145 FOWBENYN 146 - 146 FOWBENCT 147 - 148 FINTR1YN 149 - 149 FINTR1CT 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 FSSAPLYN 166 - 166 FSSAPLCT 167 - 168 FSDAPLYN 169 - 169 FSDAPLCT 170 - 171 FFDSTYN 172 - 172 FFDSTCT 173 - 174 FWICYN 175 - 175 FWICCT 176 - 177 FWICYN2 178 - 178 FM_KIDS 179 - 180 FM_ELDR 181 - 182 FMTYPE 183 - 183 FMSTRCT2 184 - 185 FMSTR2 186 - 187 FM_EDUC 188 - 189 FM_RESP 190 - 191; * 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" ACPT_FAM ="Number of families responding in HH" REJ_FAM ="Number of families not responding in HH" FM_SIZE ="Size of family" LNG_INTV ="Language of interview" REGION ="Region" WTFA_FAM ="Weight - Final Annual" STRATUM ="Stratum for variance estimation" PSU ="PSU for variance estimation" FCHLMYN ="Any kids under age 5 in fam w/play lim?" FCHLMCT ="# kids under age 5 in fam w/play lim" FSPEDYN ="Any children in fam rec Spec Ed/EIS?" FSPEDCT ="# children in fam rec Spec Ed/EIS" FLAADLYN ="Does any fam member need help w/ADL?" FLAADLCT ="# fam members needing help w/ADL" FLIADLYN ="Any fam member need help w/chores, etc.?" FLIADLCT ="# fam members need help w/chores, etc." FWKLIMYN ="Anyone with work lim due to hlth prob?" FWKLIMCT ="# fam members w/ work lim (hlth)" FWALKYN ="Any members have dif walking w/o equip?" FWALKCT ="# fam members having dif walk w/o equip" FREMEMYN ="Any member limited by dif remembering?" FREMEMCT ="# fam members w/ dif remembering" FANYLYN ="Is any fam member limited in ANY WAY?" FANYLCT ="Number of 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" FDMEDYN ="Any fam member delay* med care, 12m?" FDMEDCT ="# fam mem for whom med care delayed* 12m" FNMEDYN ="Any fam mem need+not get med care* 12m?" FNMEDCT ="# fam members need+not get med care* 12m" FHOSPYN ="Any fam member in hosp overnight, 12m?" FHOSPCT ="# fam members in hosp overnight, 12m" FHCHMYN ="Any fam member rec home care*, 2 wk?" FHCHMCT ="# fam members rec home care*, 2 wk" FHCPHRYN ="Any fam mem get adv/test results, 2wk?" FHCPHRCT ="# fam mem got adv/test results, 2 wk" FHCDVYN ="Any fam mem have office visit, etc. 2 wk" FHCDVCT ="# fam mem have office visit, etc. 2 wk" F10DVYN ="Any fam member rec care 10+ times, 12m?" F10DVCT ="# fam members rec care 10+ times, 12m" FHICOVYN ="Any fam member have hlth ins coverage?" FHICOVCT ="# fam members with hlth ins coverage" FHIPRVCT ="# fam members w/ PRIVATE hlth ins" FHISINCT ="# fam members w/ SINGLE service plans" FHICARCT ="# fam members w/ MEDICARE hlth ins" FHICADCT ="# fam members w/ MEDICAID hlth ins" FHICHPCT ="# fam members w/ CHIP hlth ins" FHIMILCT ="# fam members w/ MILITARY hlth ins" FHIIHSCT ="# fam members w/ IHS hlth ins" FHIPUBCT ="# fam members w/ oth state-spon hlth ins" FHIOGVCT ="# fam members w/ other govt hlth ins" FHICOST ="Cost of fam med/dental care, past 12 m" FHDSTCT ="# of children le 17 in Head Start" FDGLWCT1 ="# fam members working last week" FDGLWCT2 ="# fam members looking for work last week" FWRKLWCT ="# fam members work full time last week" FSALYN ="Any fam member rec inc from wages/sal?" FSALCT ="# fam members rec inc from wage/sal" FSEINCYN ="Any fam member rec inc from self-emp?" FSEINCCT ="# fam members rec inc from self-emp" FSSRRYN ="Any fam member rec Soc Sec or RR ret?" FSSRRCT ="# fam members rec Soc Sec or RR ret" FPENSYN ="Any fam member rec disab pensions*?" FPENSCT ="# of fam members rec disab pensions*" FOPENSYN ="Any fam member rec otr surv or ret pens?" FOPENSCT ="# fam members rec otr surv or ret pens" FSSIYN ="Any fam member rec inc from SSI?" FSSICT ="# fam members rec inc from SSI" FTANFYN ="Any fam member rec inc from Wel/TANF?" FTANFCT ="# of fam members rec inc from Wel/TANF" FOWBENYN ="Any fam mem rec inc fr othr Welfare pgm?" FOWBENCT ="# of fam mem rec inc fr otr Welfare pgms" FINTR1YN ="Anyone have money...that earned interest" FINTR1CT ="# fam members w/ money earn interest" FDIVDYN ="Any fam member rec div from stocks, etc." FDIVDCT ="# fam members rec div from stocks, etc." FCHSPYN ="Any fam member rec child support inc?" FCHSPCT ="# fam members rec child support inc" FINCOTYN ="Any fam member rec inc from otr source?" FINCOTCT ="# fam members rec inc from otr source" FINCGRP ="Total combined family income (grouped)" FRAT_CAT ="Ratio of fam inc to poverty threshold" FHOUSE ="Family's home tenure status" FSSAPLYN ="Any fam member EVER applied for SSI?" FSSAPLCT ="# fam members EVER applied for SSI" FSDAPLYN ="Any fam member EVER applied for SSDI?" FSDAPLCT ="# fam members EVER applied for SSDI" FFDSTYN ="Any fam member auth to rec food stamps?" FFDSTCT ="# fam members auth to rec food stamps" FWICYN ="Any fam member rec WIC benefits?" FWICCT ="# fam members rec WIC benefits" FWICYN2 ="Any fam member rec WIC benefits?" FM_KIDS ="# fam members under 18 years of age" FM_ELDR ="# fam members aged 65 and older" FMTYPE ="Family Type" FMSTRCT2 ="Family Structure" FMSTR2 ="Family Structure (on the person-level)" FM_EDUC ="Educ of adult with highest educ in fam" FM_RESP ="Person number of family respondent" ; * ASSOCIATE VARIABLES WITH FORMAT VALUES; FORMAT RECTYPE FAP001X. SRVY_YR FAP002X. FMX $FAP004X. INTV_QRT FAP005X. ASSIGNWK FAP006X. LIVQRT FAP007X. TELENUM FAP008X. INSIDE FAP009X. ACPT_FAM FAP010X. REJ_FAM FAP011X. LNG_INTV FAP013X. REGION FAP014X. FCHLMYN FAP009X. FCHLMCT FAP019X. FSPEDYN FAP009X. FSPEDCT FAP019X. FLAADLYN FAP022X. FLAADLCT FAP023X. FLIADLYN FAP009X. FLIADLCT FAP025X. FWKLIMYN FAP009X. FWKLIMCT FAP027X. FWALKYN FAP022X. FWALKCT FAP023X. FREMEMYN FAP022X. FREMEMCT FAP023X. FANYLYN FAP022X. FANYLCT FAP023X. FHSTATEX FAP023X. FHSTATVG FAP023X. FHSTATG FAP023X. FHSTATFR FAP023X. FHSTATPR FAP023X. FDMEDYN FAP022X. FDMEDCT FAP023X. FNMEDYN FAP022X. FNMEDCT FAP023X. FHOSPYN FAP022X. FHOSPCT FAP023X. FHCHMYN FAP022X. FHCHMCT FAP023X. FHCPHRYN FAP022X. FHCPHRCT FAP023X. FHCDVYN FAP022X. FHCDVCT FAP023X. F10DVYN FAP022X. F10DVCT FAP023X. FHICOVYN FAP022X. FHICOVCT FAP023X. FHIPRVCT FAP023X. FHISINCT FAP023X. FHICARCT FAP023X. FHICADCT FAP023X. FHICHPCT FAP023X. FHIMILCT FAP023X. FHIIHSCT FAP023X. FHIPUBCT FAP023X. FHIOGVCT FAP023X. FHICOST FAP064X. FHDSTCT FAP019X. FDGLWCT1 FAP066X. FDGLWCT2 FAP066X. FWRKLWCT FAP066X. FSALYN FAP009X. FSALCT FAP025X. FSEINCYN FAP009X. FSEINCCT FAP025X. FSSRRYN FAP022X. FSSRRCT FAP023X. FPENSYN FAP022X. FPENSCT FAP023X. FOPENSYN FAP022X. FOPENSCT FAP023X. FSSIYN FAP022X. FSSICT FAP023X. FTANFYN FAP022X. FTANFCT FAP023X. FOWBENYN FAP022X. FOWBENCT FAP023X. FINTR1YN FAP022X. FINTR1CT FAP023X. FDIVDYN FAP022X. FDIVDCT FAP023X. FCHSPYN FAP022X. FCHSPCT FAP023X. FINCOTYN FAP022X. FINCOTCT FAP023X. FINCGRP FAP093X. FRAT_CAT FAP094X. FHOUSE FAP095X. FSSAPLYN FAP022X. FSSAPLCT FAP023X. FSDAPLYN FAP022X. FSDAPLCT FAP023X. FFDSTYN FAP022X. FFDSTCT FAP023X. FWICYN FAP009X. FWICCT FAP025X. FWICYN2 FAP104X. FM_KIDS FAP105X. FM_ELDR FAP105X. FMTYPE FAP107X. FM_EDUC FAP110X. FM_RESP FAP111X.; PROC CONTENTS DATA=NHIS.FAMILYXX; TITLE1 'CONTENTS OF THE 2002 NHIS FAMILYXX FILE'; PROC FREQ DATA=NHIS.FAMILYXX; TITLE1 'FREQUENCY REPORT FOR 2002 NHIS FAMILYXX FILE'; TITLE2 '(WEIGHTED)'; TABLES RECTYPE/LIST MISSING; WEIGHT WTFA_FAM ; PROC FREQ DATA=NHIS.FAMILYXX; TITLE1 'FREQUENCY REPORT FOR 2002 NHIS FAMILYXX FILE'; TITLE2 '(UNWEIGHTED)'; TABLES RECTYPE/LIST MISSING; * USER NOTE: TO SEE UNFORMATTED VALUES IN PROCEDURES, ADD THE STATEMENT: FORMAT _ALL_; RUN;