********************************************************************* * JUNE 3, 2015 11:54 AM * * THIS IS AN EXAMPLE OF AN SPSS SCRIPT THAT CREATES * A TEMPORARY SPSS FILE FROM THE * 2014 NHIS PUBLIC USE FAMILYXX.DAT ASCII FILE * * THIS IS STORED IN FAMILYXX.SPS ********************************************************************* FILE HANDLE TEMP /NAME='C:\NHIS2014\FAMILYXX.dat' /RECFORM=VARIABLE /LRECL=211 DATA LIST FILE=TEMP FIXED RECORDS=1 TABLE / RECTYPE 1 - 2 SRVY_YR 3 - 6 HHX 7 - 12 (A) FMX 13 - 14 (A) WTFA_FAM 15 - 20 FINT_Y_P 21 - 24 FINT_M_P 25 - 26 TELN_FLG 27 - 27 CURWRKN 28 - 28 TELCELN 29 - 29 WRKCELN 30 - 31 PHONEUSE 32 - 32 FLNGINTV 33 - 33 FM_SIZE 34 - 35 FM_KIDS 36 - 37 FM_ELDR 38 - 39 FM_TYPE 40 - 40 FM_STRCP 41 - 42 FM_STRP 43 - 44 FM_EDUC1 45 - 46 FCHLMYN 47 - 47 FCHLMCT 48 - 49 FSPEDYN 50 - 50 FSPEDCT 51 - 52 FLAADLYN 53 - 53 FLAADLCT 54 - 55 FLIADLYN 56 - 56 FLIADLCT 57 - 58 FWKLIMYN 59 - 59 FWKLIMCT 60 - 61 FWALKYN 62 - 62 FWALKCT 63 - 64 FREMEMYN 65 - 65 FREMEMCT 66 - 67 FANYLYN 68 - 68 FANYLCT 69 - 70 FHSTATEX 71 - 72 FHSTATVG 73 - 74 FHSTATG 75 - 76 FHSTATFR 77 - 78 FHSTATPR 79 - 80 FSRUNOUT 81 - 81 FSLAST 82 - 82 FSBALANC 83 - 83 FSSKIP 84 - 84 FSSKDAYS 85 - 86 FSLESS 87 - 87 FSHUNGRY 88 - 88 FSWEIGHT 89 - 89 FSNOTEAT 90 - 90 FSNEDAYS 91 - 92 FDMEDYN 93 - 93 FDMEDCT 94 - 95 FNMEDYN 96 - 96 FNMEDCT 97 - 98 FHOSP2YN 99 - 99 FHOSP2CT 100 - 101 FHCHMYN 102 - 102 FHCHMCT 103 - 104 FHCPHRYN 105 - 105 FHCPHRCT 106 - 107 FHCDVYN 108 - 108 FHCDVCT 109 - 110 F10DVYN 111 - 111 F10DVCT 112 - 113 FHICOVYN 114 - 114 FHICOVCT 115 - 116 FHIPRVCT 117 - 118 FHIEXCT 119 - 120 FHISINCT 121 - 122 FHICARCT 123 - 124 FHICADCT 125 - 126 FHICHPCT 127 - 128 FHIMILCT 129 - 130 FHIIHSCT 131 - 132 FHIPUBCT 133 - 134 FHIOGVCT 135 - 136 FPRCOOH 137 - 137 FHIEBCCT 138 - 139 COVCONF 140 - 140 FHICOST 141 - 141 FMEDBILL 142 - 142 FMEDBPAY 143 - 143 FMEDBNOP 144 - 144 FSAF 145 - 145 FHDSTCT 146 - 147 FDGLWCT1 148 - 149 FDGLWCT2 150 - 151 FWRKLWCT 152 - 153 FSALYN 154 - 154 FSALCT 155 - 156 FSEINCYN 157 - 157 FSEINCCT 158 - 159 FSSRRYN 160 - 160 FSSRRCT 161 - 162 FPENSYN 163 - 163 FPENSCT 164 - 165 FOPENSYN 166 - 166 FOPENSCT 167 - 168 FSSIYN 169 - 169 FSSICT 170 - 171 FTANFYN 172 - 172 FTANFCT 173 - 174 FOWBENYN 175 - 175 FOWBENCT 176 - 177 FINTR1YN 178 - 178 FINTR1CT 179 - 180 FDIVDYN 181 - 181 FDIVDCT 182 - 183 FCHSPYN 184 - 184 FCHSPCT 185 - 186 FINCOTYN 187 - 187 FINCOTCT 188 - 189 INCGRP4 190 - 191 INCGRP5 192 - 193 RAT_CAT4 194 - 195 RAT_CAT5 196 - 197 HOUSEOWN 198 - 198 FGAH 199 - 199 FSSAPLYN 200 - 200 FSSAPLCT 201 - 202 FSDAPLYN 203 - 203 FSDAPLCT 204 - 205 FSNAP 206 - 206 FSNAPMYR 207 - 208 FWICYN 209 - 209 FWICCT 210 - 211 . VARIABLE LABELS RECTYPE "File type identifier" SRVY_YR "Year of National Health Interview Survey" HHX "Household Number" FMX "Family Number" WTFA_FAM "Weight - Final Annual" FINT_Y_P "Year Interview Completed - Year" FINT_M_P "Date of Interview - Month" TELN_FLG "Supplied telephone number" CURWRKN "Working phone inside home" TELCELN "Working cell phone in family" WRKCELN "Number of working cell phones" PHONEUSE "Received calls cell/landline/both" FLNGINTV "Language of Interview" 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" 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 receiving Special Education/EIS" FLAADLYN "Any family member need help with an ADL?" FLAADLCT "# family members needing help with an ADL" FLIADLYN "Any family member need help with an IADL?" FLIADLCT "# family members needing help with an IADL" FWKLIMYN "Any family member have work limitations due to a health problem?" FWKLIMCT "# family members with work limitations due to a health problem" FWALKYN "Any family member have difficulty walking without equipment?" FWALKCT "# family members having difficulty walking without equipment" FREMEMYN "Any family member limited by difficulty remembering?" FREMEMCT "# family members with difficulty remembering" FANYLYN "Is any family member limited in ANY WAY?" FANYLCT "# of family members with 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" FSRUNOUT "Worried food would run out before got money to buy more" FSLAST "Food did not last before had money to get more" FSBALANC "Could not afford to eat balanced meals" FSSKIP "Cut size or skipped meals because not enough money" FSSKDAYS "Number of days cut size or skipped meals" FSLESS "Eat less than felt should because not enough money" FSHUNGRY "Hungry but did not eat because not enough money" FSWEIGHT "Lose weight because not enough money for food" FSNOTEAT "Not eat for a whole day because not enough money for food" FSNEDAYS "Number of days did not eat" FDMEDYN "Any family member delay seeking 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, 2wk?" FHCHMCT "# of family members who received home care, 2wk" FHCPHRYN "Any family member get advice/test results over the phone, 2wk?" FHCPHRCT "# of family members who got advice/test results over the phone, 2wk" FHCDVYN "Any family member have an office visit, etc., 2wk" FHCDVCT "# of family members who had an office visit, etc., 2wk" F10DVYN "Any family member receive care 10+ times, 12m?" F10DVCT "# of family members who received care 10+ times, 12m" FHICOVYN "Any family member have health insurance coverage?" FHICOVCT "Number of family members with health insurance coverage" FHIPRVCT "Number of family members with private health insurance coverage" FHIEXCT "Number of family members with exchange-based coverage" FHISINCT "Number of family members with single service plans" FHICARCT "Number of family members with Medicare" FHICADCT "Number of family members with Medicaid" FHICHPCT "Number of family members with SCHIP" FHIMILCT "Number of family members with Military health insurance coverage" FHIIHSCT "Number of family members with Indian Health Service coverage" FHIPUBCT "Number of family members with other state-sponsored health plan" FHIOGVCT "Number of family members with other government health plan" FPRCOOH "Any persons covered living outside of the household" FHIEBCCT "Number of family members with employer based coverage" COVCONF "Confidence in obtaining affordable coverage" FHICOST "Cost of family medical/dental care in the past 12 months" FMEDBILL "Problems paying or unable to pay any medical bills" FMEDBPAY "Medical bills being paid off over time" FMEDBNOP "Unable to pay medical bills" FSAF "Family has a Flexible Spending Account" 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" FSALYN "Any family member receive income from wages or salary?" FSALCT "# family members receiving income from wages or salary" FSEINCYN "Any family member receive income from self-employment?" FSEINCCT "# family members receiving income from self-employment" FSSRRYN "Any family member receive Social Security or Railroad Retirement income?" FSSRRCT "# family members receiving Social Security or Railroad Retirement income" FPENSYN "Any family members receive disability pensions (See file layout)" FPENSCT "# family members receiving disability pensions (See file layout)" FOPENSYN "Any family member receive other survivor or retirement pensions?" FOPENSCT "# family members receiving other survivor or retirement pension" FSSIYN "Any family member receive income from SSI?" FSSICT "# of family members receiving income from SSI" FTANFYN "Any family member receive income from a state or county welfare program?" FTANFCT "# of family members receiving income from a state or county welfare program" FOWBENYN "Any family member receive other kind of welfare assistance?" FOWBENCT "# of family members receiving other kind of welfare assistance" FINTR1YN "Any family member receive income from interest bearing accounts, funds, etc.?" FINTR1CT "# of family members receiving income from interest bearing accounts, funds, etc." FDIVDYN "Any family member receive dividends from stocks, etc.?" FDIVDCT "# of family members receiving dividends from stocks, etc." FCHSPYN "Any family member receive child support income?" FCHSPCT "# of family members for whom child support was received" FINCOTYN "Any family member receive income from any other source?" FINCOTCT "# of family members receiving income from any other source" INCGRP4 "Total combined family income (grouped)" INCGRP5 "Total combined family income (grouped)" RAT_CAT4 "Ratio of family income to the poverty threshold" RAT_CAT5 "Ratio of family income to the poverty threshold" HOUSEOWN "Home tenure status" FGAH "Paying lower rent due to government program" FSSAPLYN "Any family member ever apply for SSI?" FSSAPLCT "# family members ever applying for SSI" FSDAPLYN "Any family member ever apply for SSDI?" FSDAPLCT "# family members ever applying for SSDI" FSNAP "Any family member receive food stamp/SNAP benefits last calendar year?" FSNAPMYR "Number of months family received food stamps/SNAP benefits, last calendar year" FWICYN "Any family member receiving WIC benefits?" FWICCT "# family members receiving WIC benefits" . VALUE LABELS RECTYPE 10 "Household" 20 "Person" 25 "Income Imputation" 30 "Sample Adult" 38 "Functioning and Disability" 40 "Sample Child" 60 "Family" 63 "Family Disability Questions" 65 "Paradata" 70 "Injury/Poisoning Episode" 75 "Injury/Poisoning Verbatim" / FINT_Y_P 9998 "Not ascertained" / FINT_M_P 01 "January" 02 "February" 03 "March" 04 "April" 05 "May" 06 "June" 07 "July" 08 "August" 09 "September" 10 "October" 11 "November" 12 "December" 98 "Not ascertained" / TELN_FLG 1 "Gave telephone number" 2 "No telephone" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / CURWRKN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / TELCELN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / WRKCELN 97 "Refused" 98 "Not ascertained" 99 "Don't know" / PHONEUSE 1 "All or almost all calls received on cell phones" 2 "Some received on cell phones and some on regular phones" 3 "Very few or none on cell phones" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FLNGINTV 1 "English" 2 "Spanish" 3 "English and Spanish" 4 "Other" 8 "Not ascertained" / FM_TYPE 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" / FM_STRCP 11 "Living alone" 12 "Living with roommate(s)" 21 "Married couple" 22 "Unmarried couple" 23 "All other adult-only families" 31 "Mother and biological or non-biological child(ren) only" 32 "Father and biological or non-biological child(ren) only" 33 "All other single-adult and child(ren) families" 41 "Married or unmarried parents with biological/adoptive child(ren) only" 42 "Parent (biological or adoptive), step parent, and child(ren) only" 43 "Parent (biological or adoptive), cohabiting partner, and child(ren) only" 44 "At least 1 (biological or adoptive) parent and 1+ child(ren), and other related adults" 45 "Other related and/or unrelated adults, 1+ child(ren), no biological or adoptive parent(s)" 99 "Unknown" / FM_STRP 11 "Living alone" 12 "Living with roommate(s)" 21 "Married couple" 22 "Unmarried couple" 23 "All other adult-only families" 31 "Mother and biological or non-biological child(ren) only" 32 "Father and biological or non-biological child(ren) only" 33 "All other single-adult and child(ren) families" 41 "Married parents with biological/adoptive child(ren) only" 42 "Cohabiting parent(s) with child(ren) only" 43 "Parent (biological or adoptive), step parent, and child(ren) only" 44 "At least 1 (biological or adoptive) parent and 1+ child(ren), and other related adults" 45 "Other related and/or unrelated adults, 1+ child(ren), no biological or adoptive parent(s)" 99 "Unknown" / FM_EDUC1 01 "Less than/equal to 8th grade" 02 "9-12th grade, no high school diploma" 03 "GED recipient" 04 "High school graduate" 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" / FCHLMYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSPEDYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FLAADLYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FLIADLYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FWKLIMYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FWALKYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FREMEMYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FANYLYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSRUNOUT 1 "Often true" 2 "Sometimes true" 3 "Never true" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSLAST 1 "Often true" 2 "Sometimes true" 3 "Never true" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSBALANC 1 "Often true" 2 "Sometimes true" 3 "Never true" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSSKIP 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSSKDAYS 97 "Refused" 98 "Not ascertained" 99 "Don't know" / FSLESS 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSHUNGRY 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSWEIGHT 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSNOTEAT 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSNEDAYS 97 "Refused" 98 "Not ascertained" 99 "Don't know" / FDMEDYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FNMEDYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FHOSP2YN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FHCHMYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FHCPHRYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FHCDVYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / F10DVYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FHICOVYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FPRCOOH 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / COVCONF 1 "Very confident" 2 "Somewhat confident" 3 "Not too confident" 4 "Not confident at all" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FHICOST 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" / FMEDBILL 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FMEDBPAY 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FMEDBNOP 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSAF 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSALYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSEINCYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSSRRYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FPENSYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FOPENSYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSSIYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FTANFYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FOWBENYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FINTR1YN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FDIVDYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FCHSPYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FINCOTYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / INCGRP4 01 "$0 - $34,999" 02 "$35,000 - $49,999" 03 "$50,000 - $74,999" 04 "$75,000 - $99,999" 05 "$100,000 and over" 06 "$0 - $49,999 (no further detail)" 07 "$50,000 - $99,999 (no further detail)" 96 "Undefined" 99 "Unknown" / INCGRP5 01 "$0 - $34,999" 02 "$35,000 - $74,999" 03 "$75,000 - $99,999" 04 "$100,000 and over" 96 "Undefined" 99 "Unknown" / RAT_CAT4 01 "Under 0.50" 02 "0.50 - 0.74" 03 "0.75 - 0.99" 04 "1.00 - 1.24" 05 "1.25 - 1.49" 06 "1.50 - 1.74" 07 "1.75 - 1.99" 08 "2.00 - 2.49" 09 "2.50 - 2.99" 10 "3.00 - 3.49" 11 "3.50 - 3.99" 12 "4.00 - 4.49" 13 "4.50 - 4.99" 14 "5.00 and over" 15 "Less than 1.00 (no further detail)" 16 "1.00 - 1.99 (no further detail)" 17 "2.00 and over (no further detail)" 96 "Undefinable" 99 "Unknown" / RAT_CAT5 01 "Under 0.50" 02 "0.50 - 0.74" 03 "0.75 - 0.99" 04 "1.00 - 1.24" 05 "1.25 - 1.49" 06 "1.50 - 1.74" 07 "1.75 - 1.99" 08 "2.00 - 2.49" 09 "2.50 - 2.99" 10 "3.00 - 3.49" 11 "3.50 - 3.99" 12 "4.00 - 4.49" 13 "4.50 - 4.99" 14 "5.00 and over" 15 "Less than 1.00 (no further detail)" 16 "1.00 - 1.99 (no further detail)" 17 "2.00 - 3.99 (no further detail)" 18 "4.00 and over (no further detail)" 96 "Undefinable" 99 "Unknown" / HOUSEOWN 1 "Owned or being bought" 2 "Rented" 3 "Other arrangement" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FGAH 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSSAPLYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSDAPLYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSNAP 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" / FSNAPMYR 97 "Refused" 98 "Not ascertained" 99 "Don't know" / FWICYN 1 "Yes" 2 "No" 7 "Refused" 8 "Not ascertained" 9 "Don't know" FREQUENCIES GENERAL = RECTYPE. EXECUTE.