********************************************************************* JUNE 27, 2001 4:37 PM THIS IS AN EXAMPLE OF A SAS PROGRAM THAT CREATES A SAS FILE FROM THE 1999 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:\NHIS1999\'; LIBNAME LIBRARY 'C:\NHIS1999\'; * DEFINE VARIABLE VALUES FOR REPORTS; PROC FORMAT LIBRARY=LIBRARY; VALUE FAP001X 60 = "Family" ; VALUE FAP002X 1999 = "1999" ; 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 FAP010X 01 - 30 = "01-30" ; VALUE FAP011X 00 - 29 = "00-29" ; 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 FAP015X 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 FAP020X 00 - 30 = "00-30 children" . = "" ; VALUE FAP023X 1 = "Yes" 2 = "No" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE FAP024X 00 - 30 = "00-30 family members" ; VALUE FAP026X 00 - 30 = "00-30 family members" . = "" ; VALUE FAP028X 00 - 30 = "Number of members" . = "" ; VALUE FAP042X 00 - 99 = "Injury episodes" ; VALUE FAP045X 00 - 99 = "Number of poisoning episodes" ; VALUE FAP071X 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 FAP073X 00 - 30 = "00-30 fam members" . = "" ; VALUE FAP100X 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 FAP101X 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 FAP102X 1 = "Owned or being bought" 2 = "Rented" 3 = "Other Arrangement" 7 = "Refused" 8 = "Not ascertained" 9 = "Don't know" ; VALUE FAP111X 00 - 30 = "00-30 fam members" ; VALUE FAP113X 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 FAP115X 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 FAP116X 01 - 30 = "Person number" 98 = "Not ascertained" ; DATA NHIS.FAMILYXX; * CREATE A SAS DATA SET STORED IN DIR 'C:\NHIS1999\'; INFILE 'C:\NHIS1999\FAMILYXX.DAT' MISSOVER TRUNCOVER LRECL=199; * 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 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 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 FINTRSYN 3 FINTRSCT 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 FM_KIDS 3 FM_ELDR 3 FMTYPE 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 MSASIZEP 30 - 30 WTFA_FAM 31 - 36 STRATUM 37 - 39 PSU 40 - 40 FCHLMYN 41 - 41 FCHLMCT 42 - 43 FSPEDYN 44 - 44 FSPEDCT 45 - 46 FLAADLYN 47 - 47 FLAADLCT 48 - 49 FLIADLYN 50 - 50 FLIADLCT 51 - 52 FWKLIMYN 53 - 53 FWKLIMCT 54 - 55 FWALKYN 56 - 56 FWALKCT 57 - 58 FREMEMYN 59 - 59 FREMEMCT 60 - 61 FANYLYN 62 - 62 FANYLCT 63 - 64 FHSTATEX 65 - 66 FHSTATVG 67 - 68 FHSTATG 69 - 70 FHSTATFR 71 - 72 FHSTATPR 73 - 74 FINJYN 75 - 75 FINJCT1 76 - 77 FINJCT2 78 - 79 FPOISYN 80 - 80 FPOISCT1 81 - 82 FPOISCT2 83 - 84 FDMEDYN 85 - 85 FDMEDCT 86 - 87 FNMEDYN 88 - 88 FNMEDCT 89 - 90 FHOSPYN 91 - 91 FHOSPCT 92 - 93 FHCHMYN 94 - 94 FHCHMCT 95 - 96 FHCPHYN 97 - 97 FHCPHCT 98 - 99 FHCDVYN 100 - 100 FHCDVCT 101 - 102 F10DVYN 103 - 103 F10DVCT 104 - 105 FHICOVYN 106 - 106 FHICOVCT 107 - 108 FHIPRVCT 109 - 110 FHISINCT 111 - 112 FHICARCT 113 - 114 FHICADCT 115 - 116 FHICHPCT 117 - 118 FHIMILCT 119 - 120 FHIIHSCT 121 - 122 FHIPUBCT 123 - 124 FHIOGVCT 125 - 126 FHICOST 127 - 127 FHDSTCT 128 - 129 FDGLWCT1 130 - 131 FDGLWCT2 132 - 133 FWRKLWCT 134 - 135 FSALYN 136 - 136 FSALCT 137 - 138 FSEINCYN 139 - 139 FSEINCCT 140 - 141 FSSRRYN 142 - 142 FSSRRCT 143 - 144 FPENSYN 145 - 145 FPENSCT 146 - 147 FOPENSYN 148 - 148 FOPENSCT 149 - 150 FSSIYN 151 - 151 FSSICT 152 - 153 FTANFYN 154 - 154 FTANFCT 155 - 156 FOWBENYN 157 - 157 FOWBENCT 158 - 159 FINTRSYN 160 - 160 FINTRSCT 161 - 162 FDIVDYN 163 - 163 FDIVDCT 164 - 165 FCHSPYN 166 - 166 FCHSPCT 167 - 168 FINCOTYN 169 - 169 FINCOTCT 170 - 171 FINCGRP 172 - 173 FRAT_CAT 174 - 175 FHOUSE 176 - 176 FSSAPLYN 177 - 177 FSSAPLCT 178 - 179 FSDAPLYN 180 - 180 FSDAPLCT 181 - 182 FFDSTYN 183 - 183 FFDSTCT 184 - 185 FWICYN 186 - 186 FWICCT 187 - 188 FM_KIDS 189 - 190 FM_ELDR 191 - 192 FMTYPE 193 - 193 FMSTR2 194 - 195 FM_EDUC 196 - 197 FM_RESP 198 - 199; * 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" MSASIZEP ="Geographic Distribution - MSA size" WTFA_FAM ="Weight - Final Annual" STRATUM ="Stratum for variance estimation" PSU ="PSU for variance estimation" FCHLMYN ="Any child lt age 5 in fam with play lim?" FCHLMCT ="# children lt 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, 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 ="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 ="# 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 ="Any fam member injured in past 3 m?" FINJCT1 ="# fam members injured in past 3 m" FINJCT2 ="# injury episodes in family past 3 m" FPOISYN ="Any fam member poisoned (last 3 m)?" FPOISCT1 ="# fam members poisoned past 3 m" FPOISCT2 ="# poison episodes in family past 3 m" FDMEDYN ="Med care delayed* for any fam member?" FDMEDCT ="# fam members for whom med care delayed*" FNMEDYN ="Any fam member not get med care*, 12m?" FNMEDCT ="# fam members 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" FHCPHYN ="Any fam member phone a hlth prof, 2 wk?" FHCPHCT ="# fam members phone hlth care prof, 2 wk" FHCDVYN ="Any fam member see hlth prof in office*?" FHCDVCT ="# fam members see hlth prof in office*" 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/ otr 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 6 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 member rec inc from otr asst prg" FOWBENCT ="# fam members rec inc from otr asst prgm" FINTRSYN ="Any fam member rec int from savings?" FINTRSCT ="# fam members rec interest from savings" FDIVDYN ="Any fam member rec div from stocks?" 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" FM_KIDS ="# fam members aged 17 and younger" FM_ELDR ="# fam members aged 65 and older" FMTYPE ="Family Type" FMSTR2 ="Family Structure" 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. MSASIZEP FAP015X. FCHLMYN FAP009X. FCHLMCT FAP020X. FSPEDYN FAP009X. FSPEDCT FAP020X. FLAADLYN FAP023X. FLAADLCT FAP024X. FLIADLYN FAP009X. FLIADLCT FAP026X. FWKLIMYN FAP009X. FWKLIMCT FAP028X. FWALKYN FAP023X. FWALKCT FAP024X. FREMEMYN FAP023X. FREMEMCT FAP024X. FANYLYN FAP023X. FANYLCT FAP024X. FHSTATEX FAP024X. FHSTATVG FAP024X. FHSTATG FAP024X. FHSTATFR FAP024X. FHSTATPR FAP024X. FINJYN FAP023X. FINJCT1 FAP024X. FINJCT2 FAP042X. FPOISYN FAP023X. FPOISCT1 FAP024X. FPOISCT2 FAP045X. FDMEDYN FAP023X. FDMEDCT FAP024X. FNMEDYN FAP023X. FNMEDCT FAP024X. FHOSPYN FAP023X. FHOSPCT FAP024X. FHCHMYN FAP023X. FHCHMCT FAP024X. FHCPHYN FAP023X. FHCPHCT FAP024X. FHCDVYN FAP023X. FHCDVCT FAP024X. F10DVYN FAP023X. F10DVCT FAP024X. FHICOVYN FAP023X. FHICOVCT FAP024X. FHIPRVCT FAP024X. FHISINCT FAP024X. FHICARCT FAP024X. FHICADCT FAP024X. FHICHPCT FAP024X. FHIMILCT FAP024X. FHIIHSCT FAP024X. FHIPUBCT FAP024X. FHIOGVCT FAP024X. FHICOST FAP071X. FHDSTCT FAP020X. FDGLWCT1 FAP073X. FDGLWCT2 FAP073X. FWRKLWCT FAP073X. FSALYN FAP009X. FSALCT FAP026X. FSEINCYN FAP009X. FSEINCCT FAP026X. FSSRRYN FAP023X. FSSRRCT FAP024X. FPENSYN FAP023X. FPENSCT FAP024X. FOPENSYN FAP023X. FOPENSCT FAP024X. FSSIYN FAP023X. FSSICT FAP024X. FTANFYN FAP023X. FTANFCT FAP024X. FOWBENYN FAP009X. FOWBENCT FAP026X. FINTRSYN FAP023X. FINTRSCT FAP024X. FDIVDYN FAP023X. FDIVDCT FAP024X. FCHSPYN FAP023X. FCHSPCT FAP024X. FINCOTYN FAP023X. FINCOTCT FAP024X. FINCGRP FAP100X. FRAT_CAT FAP101X. FHOUSE FAP102X. FSSAPLYN FAP023X. FSSAPLCT FAP024X. FSDAPLYN FAP023X. FSDAPLCT FAP024X. FFDSTYN FAP023X. FFDSTCT FAP024X. FWICYN FAP009X. FWICCT FAP026X. FM_KIDS FAP111X. FM_ELDR FAP111X. FMTYPE FAP113X. FM_EDUC FAP115X. FM_RESP FAP116X.; PROC CONTENTS DATA=NHIS.FAMILYXX; PROC FREQ DATA=NHIS.FAMILYXX; TITLE1 'FREQUENCY REPORT FOR 1999 NHIS FAMILYXX FILE'; TITLE2 '(WEIGHTED)'; TABLES RECTYPE/LIST MISSING; WEIGHT WTFA_FAM ; PROC FREQ DATA=NHIS.FAMILYXX; TITLE1 'FREQUENCY REPORT FOR 1999 NHIS FAMILYXX FILE'; TITLE2 '(UNWEIGHTED)'; TABLES RECTYPE/LIST MISSING; * USER NOTE: TO SEE UNFORMATTED VALUES IN PROCEDURES, ADD THE STATEMENT: FORMAT _ALL_; RUN;