********************************************************************* APRIL 22, 2010 3:39 PM This is an example of a SAS program that creates a SAS file from the 2009 NHIS Public Use FAMILYXX.DAT ASCII file This is stored in FAMILYXX.SAS *********************************************************************; * USER NOTE: PLACE NEXT STATEMENT IN SUBSEQUENT PROGRAMS; LIBNAME NHIS "C:\NHIS2009"; * USER NOTE: PLACE NEXT STATEMENT IN SUBSEQUENT PROGRAMS IF YOU ALLOW PROGRAM TO PERMANENTLY STORE FORMATS; LIBNAME LIBRARY "C:\NHIS2009"; FILENAME ASCIIDAT 'C:\NHIS2009\FAMILYXX.dat'; * DEFINE VARIABLE VALUES FOR REPORTS; * USE THE STATEMENT "PROC FORMAT LIBRARY=LIBRARY" TO PERMANENTLY STORE THE FORMAT DEFINITIONS; * USE THE STATEMENT "PROC FORMAT" IF YOU DO NOT WISH TO PERMANENTLY STORE THE FORMATS; PROC FORMAT LIBRARY=LIBRARY; *PROC FORMAT; VALUE $GROUPC ' '< - HIGH = "Range of Values" ; VALUE GROUPN LOW - HIGH = "Range of Values" ; VALUE FAP001X 10 = "10 Household" 20 = "20 Person" 25 = "25 Income Imputation" 30 = "30 Sample Adult" 40 = "40 Sample Child" 60 = "60 Family" 63 = "63 Disability Questions Tests 2008/2009" 65 = "65 Paradata" 70 = "70 Injury/Poisoning Episode" 75 = "75 Injury/Poisoning Verbatim" ; VALUE FAP002X . = '.' OTHER = "Survey Year" ; VALUE FAP006X . = '.' OTHER = "Completion Year" 9998 = "9998 Not ascertained" ; VALUE FAP007X 01 = "01 January" 02 = "02 February" 03 = "03 March" 04 = "04 April" 05 = "05 May" 06 = "06 June" 07 = "07 July" 08 = "08 August" 09 = "09 September" 10 = "10 October" 11 = "11 November" 12 = "12 December" 98 = "98 Not ascertained" ; VALUE FAP008X 1 = "1 Gave telephone number" 2 = "2 No telephone" 7 = "7 Refused" 8 = "8 Not ascertained" 9 = "9 Don't know" ; VALUE FAP009X 1 = "1 Yes" 2 = "2 No" 7 = "7 Refused" 8 = "8 Not ascertained" 9 = "9 Don't know" ; VALUE FAP011X 000 = "000 Less than 1 week" 997 = "997 Refused" 998 = "998 Not ascertained" 999 = "999 Don't know" ; VALUE FAP013X 97 = "97 Refused" 98 = "98 Not ascertained" 99 = "99 Don't know" ; VALUE FAP015X 1 = "1 All or almost all calls received on cell phones" 2 = "2 Some received on cell phones and some on regular phones" 3 = "3 Very few or none on cell phones" 7 = "7 Refused" 8 = "8 Not ascertained" 9 = "9 Don't know" ; VALUE FAP016X 1 = "1 English" 2 = "2 Spanish" 3 = "3 English and Spanish" 4 = "4 Other" 8 = "8 Not ascertained" ; VALUE FAP020X 1 = "1 One adult, no child(ren) under 18" 2 = "2 Multiple adults, no child(ren) under 18" 3 = "3 One adult, 1+ child(ren) under 18" 4 = "4 Multiple adults, 1+ child(ren) under 18" 9 = "9 Unknown" ; VALUE FAP021X 11 = "11 Living alone" 12 = "12 Living with roommate(s)" 21 = "21 Married couple" 22 = "22 Unmarried couple" 23 = "23 All other adult-only families" 31 = "31 Mother and biological or non-biological child(ren) only" 32 = "32 Father and biological or non-biological child(ren) only" 33 = "33 All other single-adult and child(ren) families" 41 = "41 Married or unmarried parents with biological/adoptive child(ren) only" 42 = "42 Parent (biological or adoptive), step parent, and child(ren) only" 43 = "43 Parent (biological or adoptive), cohabiting partner, and child(ren) only" 44 = "44 At least 1 (biological or adoptive) parent and 1+ child(ren), and other rela ted adults" 45 = "45 Other related and/or unrelated adults, 1+ child(ren), no biological or adopt ive parent(s)" 99 = "99 Unknown" ; VALUE FAP022X 11 = "11 Living alone" 12 = "12 Living with roommate(s)" 21 = "21 Married couple" 22 = "22 Unmarried couple" 23 = "23 All other adult-only families" 31 = "31 Mother and biological or non-biological child(ren) only" 32 = "32 Father and biological or non-biological child(ren) only" 33 = "33 All other single-adult and child(ren) families" 41 = "41 Married parents with biological/adoptive child(ren) only" 42 = "42 Cohabiting parent(s) with child(ren) only" 43 = "43 Parent (biological or adoptive), step parent, and child(ren) only" 44 = "44 At least 1 (biological or adoptive) parent and 1+ child(ren), and other rela ted adults" 45 = "45 Other related and/or unrelated adults, 1+ child(ren), no biological or adopt ive parent(s)" 99 = "99 Unknown" ; VALUE FAP023X 01 = "01 Less than/equal to 8th grade" 02 = "02 9-12th grade, no high school diploma" 03 = "03 GED recipient" 04 = "04 High school graduate" 05 = "05 Some college, no degree" 06 = "06 AA degree, technical or vocational" 07 = "07 AA degree, academic program" 08 = "08 Bachelor's degree (BA, BS, AB, BBA)" 09 = "09 Master's, professional, or doctoral degree" 97 = "97 Refused" 98 = "98 Not ascertained" 99 = "99 Don't know" ; VALUE FAP088X 01 = "01 $0 - $34,999" 02 = "02 $35,000 - $49,999" 03 = "03 $50,000 - $74,999" 04 = "04 $75,000 - $99,999" 05 = "05 $100,000 and over" 06 = "06 $0 - $49,999 (no further detail)" 07 = "07 $50,000 and over (no further detail)" 08 = "08 $50,000 - $99,999 (no further detail)" 99 = "99 Unknown" ; VALUE FAP089X 01 = "01 $0 - $34,999" 02 = "02 $35,000 - $74,999" 03 = "03 $75,000 - $99,999" 04 = "04 $100,000 and over" 96 = "96 Undefined" 99 = "99 Unknown" ; VALUE FAP090X 01 = "01 Under 0.50" 02 = "02 0.50 - 0.74" 03 = "03 0.75 - 0.99" 04 = "04 1.00 - 1.24" 05 = "05 1.25 - 1.49" 06 = "06 1.50 - 1.74" 07 = "07 1.75 - 1.99" 08 = "08 2.00 - 2.49" 09 = "09 2.50 - 2.99" 10 = "10 3.00 - 3.49" 11 = "11 3.50 - 3.99" 12 = "12 4.00 - 4.49" 13 = "13 4.50 - 4.99" 14 = "14 5.00 and over" 15 = "15 Less than 1.00 (no further detail)" 16 = "16 1.00 - 1.99 (no further detail)" 17 = "17 2.00 and over (no further detail)" 96 = "96 Undefinable" 99 = "99 Unknown" ; VALUE FAP091X 01 = "01 Under 0.50" 02 = "02 0.50 - 0.74" 03 = "03 0.75 - 0.99" 04 = "04 1.00 - 1.24" 05 = "05 1.25 - 1.49" 06 = "06 1.50 - 1.74" 07 = "07 1.75 - 1.99" 08 = "08 2.00 - 2.49" 09 = "09 2.50 - 2.99" 10 = "10 3.00 - 3.49" 11 = "11 3.50 - 3.99" 12 = "12 4.00 - 4.49" 13 = "13 4.50 - 4.99" 14 = "14 5.00 and over" 15 = "15 Less than 1.00 (no further detail)" 16 = "16 1.00 - 1.99 (no further detail)" 17 = "17 2.00 - 3.99 (no further detail)" 18 = "18 4.00 and over (no further detail)" 96 = "96 Undefinable" 99 = "99 Unknown" ; VALUE FAP092X 1 = "1 Owned or being bought" 2 = "2 Rented" 3 = "3 Other arrangement" 7 = "7 Refused" 8 = "8 Not ascertained" 9 = "9 Don't know" ; DATA NHIS.FAMILYXX; * CREATE A SAS DATA SET; INFILE ASCIIDAT PAD LRECL=173; * DEFINE LENGTH OF ALL VARIABLES; LENGTH /* IDN LENGTHS */ RECTYPE 3 SRVY_YR 4 HHX $ 6 FMX $ 2 WTFA_FAM 8 /* FRT LENGTHS */ FINT_Y_P 4 FINT_M_P 3 /* COV LENGTHS */ TELN_FLG 3 CURWRKN 3 RNOSERVN 3 RHLNGDY 4 TELCELN 3 WRKCELN 3 CELLOUT 3 PHONEUSE 3 /* BCK LENGTHS */ FLNGINTV 3 /* MFM LENGTHS */ FM_SIZE 3 FM_KIDS 3 FM_ELDR 3 FM_TYPE 3 FM_STRCP 3 FM_STRP 3 FM_EDUC1 3 /* FHS LENGTHS */ 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 /* FIJ LENGTHS */ CARBON 3 /* FAU LENGTHS */ FDMEDYN 3 FDMEDCT 3 FNMEDYN 3 FNMEDCT 3 FHOSP2YN 3 FHOSP2CT 3 FHCHMYN 3 FHCHMCT 3 FHCPHRYN 3 FHCPHRCT 3 FHCDVYN 3 FHCDVCT 3 F10DVYN 3 F10DVCT 3 /* FSD LENGTHS */ FHDSTCT 3 FDGLWCT1 3 FDGLWCT2 3 FWRKLWCT 3 /* FIN LENGTHS */ 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 INCGRP2 3 INCGRP3 3 RAT_CAT2 3 RAT_CAT3 3 HOUSEOWN 3 FGAH 3 FSSAPLYN 3 FSSAPLCT 3 FSDAPLYN 3 FSDAPLCT 3 FFDSTYN 3 FFDSTCT 3 FWICYN 3 FWICCT 3 ; * INPUT ALL VARIABLES; INPUT /* IDN LOCATIONS */ RECTYPE 1 - 2 SRVY_YR 3 - 6 HHX $ 7 - 12 FMX $ 13 - 14 WTFA_FAM 15 - 20 /* FRT LOCATIONS */ FINT_Y_P 21 - 24 FINT_M_P 25 - 26 /* COV LOCATIONS */ TELN_FLG 27 - 27 CURWRKN 28 - 28 RNOSERVN 29 - 29 RHLNGDY 30 - 32 TELCELN 33 - 33 WRKCELN 34 - 35 CELLOUT 36 - 36 PHONEUSE 37 - 37 /* BCK LOCATIONS */ FLNGINTV 38 - 38 /* MFM LOCATIONS */ FM_SIZE 39 - 40 FM_KIDS 41 - 42 FM_ELDR 43 - 44 FM_TYPE 45 - 45 FM_STRCP 46 - 47 FM_STRP 48 - 49 FM_EDUC1 50 - 51 /* FHS LOCATIONS */ FCHLMYN 52 - 52 FCHLMCT 53 - 54 FSPEDYN 55 - 55 FSPEDCT 56 - 57 FLAADLYN 58 - 58 FLAADLCT 59 - 60 FLIADLYN 61 - 61 FLIADLCT 62 - 63 FWKLIMYN 64 - 64 FWKLIMCT 65 - 66 FWALKYN 67 - 67 FWALKCT 68 - 69 FREMEMYN 70 - 70 FREMEMCT 71 - 72 FANYLYN 73 - 73 FANYLCT 74 - 75 FHSTATEX 76 - 77 FHSTATVG 78 - 79 FHSTATG 80 - 81 FHSTATFR 82 - 83 FHSTATPR 84 - 85 /* FIJ LOCATIONS */ CARBON 86 - 86 /* FAU LOCATIONS */ FDMEDYN 87 - 87 FDMEDCT 88 - 89 FNMEDYN 90 - 90 FNMEDCT 91 - 92 FHOSP2YN 93 - 93 FHOSP2CT 94 - 95 FHCHMYN 96 - 96 FHCHMCT 97 - 98 FHCPHRYN 99 - 99 FHCPHRCT 100 - 101 FHCDVYN 102 - 102 FHCDVCT 103 - 104 F10DVYN 105 - 105 F10DVCT 106 - 107 /* FSD LOCATIONS */ FHDSTCT 108 - 109 FDGLWCT1 110 - 111 FDGLWCT2 112 - 113 FWRKLWCT 114 - 115 /* FIN LOCATIONS */ FSALYN 116 - 116 FSALCT 117 - 118 FSEINCYN 119 - 119 FSEINCCT 120 - 121 FSSRRYN 122 - 122 FSSRRCT 123 - 124 FPENSYN 125 - 125 FPENSCT 126 - 127 FOPENSYN 128 - 128 FOPENSCT 129 - 130 FSSIYN 131 - 131 FSSICT 132 - 133 FTANFYN 134 - 134 FTANFCT 135 - 136 FOWBENYN 137 - 137 FOWBENCT 138 - 139 FINTR1YN 140 - 140 FINTR1CT 141 - 142 FDIVDYN 143 - 143 FDIVDCT 144 - 145 FCHSPYN 146 - 146 FCHSPCT 147 - 148 FINCOTYN 149 - 149 FINCOTCT 150 - 151 INCGRP2 152 - 153 INCGRP3 154 - 155 RAT_CAT2 156 - 157 RAT_CAT3 158 - 159 HOUSEOWN 160 - 160 FGAH 161 - 161 FSSAPLYN 162 - 162 FSSAPLCT 163 - 164 FSDAPLYN 165 - 165 FSDAPLCT 166 - 167 FFDSTYN 168 - 168 FFDSTCT 169 - 170 FWICYN 171 - 171 FWICCT 172 - 173; * DEFINE VARIABLE LABELS; LABEL /* IDN LABELS */ RECTYPE ="File type identifier" SRVY_YR ="Year of National Health Interview Survey" HHX ="HH identifier" FMX ="Family #" WTFA_FAM ="Weight - Final Annual" /* FRT LABELS */ FINT_Y_P ="Year Interview Completed - Year" FINT_M_P ="Date of Interview - Month" /* COV LABELS */ TELN_FLG ="Supplied telephone number" CURWRKN ="Working phone inside home" RNOSERVN ="Without telephone service in the past 12 months" RHLNGDY ="Number of days without telephone service" TELCELN ="Working cell phone in family" WRKCELN ="Number of working cell phones" CELLOUT ="Working cell during land-line outage" PHONEUSE ="Received calls cell/landline/both" /* BCK LABELS */ FLNGINTV ="Language of Interview" /* MFM LABELS */ FM_SIZE ="Size of family" FM_KIDS ="# family members under 18 years of age" FM_ELDR ="# family members aged 65 and older" FM_TYPE ="Family type" FM_STRCP ="Family Structure" FM_STRP ="Family Structure" FM_EDUC1 ="Education of adult with highest education in family" /* FHS LABELS */ FCHLMYN ="Any children under age 5 in family with play limitations?" FCHLMCT ="# children under age 5 in family with play limitations" FSPEDYN ="Any children in family receive Special Education/EIS?" FSPEDCT ="# children in family receive Special Education/EIS" FLAADLYN ="Does any family member need help w/ADL?" FLAADLCT ="# family members needing help w/ADL" FLIADLYN ="Any family member need help w/chores, etc.?" FLIADLCT ="# family members need help w/chores, etc." FWKLIMYN ="Anyone with work limitations due to health problem?" FWKLIMCT ="# family members w/ work limitations due to health problem?" FWALKYN ="Any members have difficulty walking w/o equipment?" FWALKCT ="# family members having difficulty walking w/o equipment" FREMEMYN ="Any member limited by difficulty remembering?" FREMEMCT ="# family members w/ difficulty remembering" FANYLYN ="Is any family member limited in ANY WAY?" FANYLCT ="Number of family members w/ ANY limitation" FHSTATEX ="# family members in excellent health" FHSTATVG ="# family members in very good health" FHSTATG ="# family members in good health" FHSTATFR ="# family members in fair health" FHSTATPR ="# family members in poor health" /* FIJ LABELS */ CARBON ="Carbon monoxide detector in home" /* FAU LABELS */ FDMEDYN ="Any family member delay medical care, 12m?" FDMEDCT ="# of family members for whom medical care was delayed 12m" FNMEDYN ="Any family member need and not get medical care 12m?" FNMEDCT = "# of family members who needed and did not get medical care 12m" FHOSP2YN ="Any family member in hospital overnight, 12m?" FHOSP2CT ="# of family members in hospital overnight, 12m" FHCHMYN ="Any family member receive home care, 2 wk?" FHCHMCT ="# of family members who received home care, 2 wk" FHCPHRYN = "Any family member get advice/test results over the phone, 2wk?" FHCPHRCT = "# of family members who got advice/test results over the phone, 2 wk" FHCDVYN ="Any family member have an office visit, etc. 2 wk" FHCDVCT ="# of family members who had an office visit, etc. 2 wk" F10DVYN ="Any family member receive care 10+ times, 12m?" F10DVCT ="# of family members who received care 10+ times, 12m" /* FSD LABELS */ FHDSTCT ="# of children in family currently or ever in Head Start" FDGLWCT1 ="# family members working last week" FDGLWCT2 ="# family members looking for work last week" FWRKLWCT ="# family members working full time last week" /* FIN LABELS */ FSALYN ="Any family member received income from wages/salary" FSALCT ="# family members received income from wages/salary" FSEINCYN ="Any family member received income from self-employment" FSEINCCT ="# family members received income from self-employment" FSSRRYN = "Any family member received Social Security or Railroad Retirement" FSSRRCT = "# family members received Social Security or Railroad Retirement" FPENSYN = "Any family members receive disability pensions (See file layout)" FPENSCT = "# family members receive disability pensions (See file layout)" FOPENSYN = "Any family member received other survivor or retirement pensions" FOPENSCT = "# family members received other survivor or retirement pension" FSSIYN ="Any family member receive income from SSI" FSSICT ="# of family members receive income from SSI" FTANFYN ="Any family member receive income from Welfare/TANF" FTANFCT ="# of family members receive income from Welfare/TANF" FOWBENYN ="Any family member receive income from other Welfare programs" FOWBENCT = "# of family members receive income from other Welfare programs" FINTR1YN ="Anyone have money . . .that earned interest" FINTR1CT ="# of family members w/ money earning interest" FDIVDYN ="Any family member receive dividends from stocks, etc." FDIVDCT ="# of family members receive dividends from stocks, etc." FCHSPYN ="Any fam member rec child support inc?" FCHSPCT ="# of family members rec child support inc?" FINCOTYN ="Any fam member rec inc from otr source?" FINCOTCT ="# of family members rec inc from otr source?" INCGRP2 ="Total combined family income (grouped)" INCGRP3 ="Total combined family income (grouped)" RAT_CAT2 ="Ratio of family income to the poverty threshold" RAT_CAT3 ="Ratio of family income to the poverty threshold" HOUSEOWN ="Home tenure status" FGAH ="Paying lower rent due to gov't program" 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" ; * ASSOCIATE VARIABLES WITH FORMAT VALUES; * (PUT ASTERISK (*) BEFORE WORD "FORMAT" IN NEXT STATEMENT TO PREVENT FORMAT ASSOCIATIONS BEING STORED WITH DATA SET); FORMAT /* IDN FORMAT ASSOCIATIONS */ RECTYPE FAP001X. SRVY_YR FAP002X. HHX $GROUPC. WTFA_FAM GROUPN. /* FRT FORMAT ASSOCIATIONS */ FINT_Y_P FAP006X. FINT_M_P FAP007X. /* COV FORMAT ASSOCIATIONS */ TELN_FLG FAP008X. CURWRKN FAP009X. RNOSERVN FAP009X. RHLNGDY FAP011X. TELCELN FAP009X. WRKCELN FAP013X. CELLOUT FAP009X. PHONEUSE FAP015X. /* BCK FORMAT ASSOCIATIONS */ FLNGINTV FAP016X. /* MFM FORMAT ASSOCIATIONS */ FM_TYPE FAP020X. FM_STRCP FAP021X. FM_STRP FAP022X. FM_EDUC1 FAP023X. /* FHS FORMAT ASSOCIATIONS */ FCHLMYN FAP009X. FSPEDYN FAP009X. FLAADLYN FAP009X. FLIADLYN FAP009X. FWKLIMYN FAP009X. FWALKYN FAP009X. FREMEMYN FAP009X. FANYLYN FAP009X. /* FIJ FORMAT ASSOCIATIONS */ CARBON FAP009X. /* FAU FORMAT ASSOCIATIONS */ FDMEDYN FAP009X. FNMEDYN FAP009X. FHOSP2YN FAP009X. FHCHMYN FAP009X. FHCPHRYN FAP009X. FHCDVYN FAP009X. F10DVYN FAP009X. /* FSD FORMAT ASSOCIATIONS */ /* FIN FORMAT ASSOCIATIONS */ FSALYN FAP009X. FSEINCYN FAP009X. FSSRRYN FAP009X. FPENSYN FAP009X. FOPENSYN FAP009X. FSSIYN FAP009X. FTANFYN FAP009X. FOWBENYN FAP009X. FINTR1YN FAP009X. FDIVDYN FAP009X. FCHSPYN FAP009X. FINCOTYN FAP009X. INCGRP2 FAP088X. INCGRP3 FAP089X. RAT_CAT2 FAP090X. RAT_CAT3 FAP091X. HOUSEOWN FAP092X. FGAH FAP009X. FSSAPLYN FAP009X. FSDAPLYN FAP009X. FFDSTYN FAP009X. FWICYN FAP009X.; RUN; PROC CONTENTS DATA=NHIS.FAMILYXX; TITLE1 'CONTENTS OF THE 2009 NHIS Family FILE'; PROC FREQ DATA=NHIS.FAMILYXX NOTITLE; TABLES RECTYPE/LIST MISSING; TITLE1 'FREQUENCY REPORT FOR 2009 NHIS Family FILE'; TITLE2 '(WEIGHTED)'; WEIGHT WTFA_FAM; PROC FREQ DATA=NHIS.FAMILYXX NOTITLE; TABLES RECTYPE/LIST MISSING; TITLE1 'FREQUENCY REPORT FOR 2009 NHIS Family FILE'; TITLE2 '(UNWEIGHTED)'; * USER NOTE: TO SEE UNFORMATTED VALUES IN PROCEDURES, ADD THE STATEMENT: FORMAT _ALL_; RUN;