/**************************************************************************/ /* PROGRAM : FORMAT_SECH00.TXT */ /* */ /* PURPOSE : THIS SAS PROGRAM ASSOCIATES FORMATS TO VARIABLES */ /* FROM THE 2000 NSECH PUBLIC USE SAS DATA SET. */ /* */ /**************************************************************************/ *------------------------------------*; * DIRECTORY WHERE FILES ARE LOCATED *; *------------------------------------*; libname puf 'c:\sech00'; ** "puf" REFERS TO THE DIRECTORY WHERE THE **; ** DATASECH.SD2 FILE IS LOCATED. IF YOU **; ** HAVE STORED THE DATA FILE IN A DIRECTORY **; ** OTHER THAN C:\SECH00, CHANGE THE LIBNAME **; ** STATEMENT TO POINT TO THE DIRECTORY WHERE **; ** YOU HAVE STORED THE FILE. **; *----------------------------*; * VARIABLE FORMATS *; *----------------------------*; PROC FORMAT ; VALUE GENDERF 1='1-MALE ' 2='2-FEMALE' 7='REF' ; VALUE RANGE 1="04-09 MONTHS" 2="10-18 MONTHS" 3="19-35 MONTHS" ; VALUE INTLANG 1= 'ENGLISH' 2= 'SPANISH' ; VALUE YN 1='1-YES ' 0='0-NO' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE YN3X 1='1-YES ' 0='0-NO' 3='3-CHILD DOES NOT USE BOTTLE' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE NUM2D 96='96-DK ' 97='97-REF' 98='98-SKIP' .='(MISSING)' ; VALUE AGEFOOD 95='FOOD NOT INTRODUCED YET' 96='96-DK ' 97='97-REF' 98='98-SKIP' .='(MISSING)' ; VALUE NUM3D 996='996-DK ' 997='997-REF' 998='998-SKIP' .='(MISSING)' ; VALUE H2Q11Q 01='1-EXCELLENT ' 02='2-VERY GOOD' 03='3-GOOD' 04='4-FAIR' 05='5-POOR' 06='6-DID NOT WANT ANYONE COORDINATING' 96='96-DK' 97='97-REF' ; VALUE A1Q03Q 01='1-DOCTOR OR NURSE PRACTITIONER IN PRIVATE OR GROUP PRACTICE' 02='2-URGENT CARE OR WALK-IN CLINIC' 03='3-COMMUNITY HEALTH CENTER/PUBLIC CLINIC' 04='4-HOSPITAL CLINIC' 05='5-EMERGENCY ROOM' 06='6-NO ONE PLACE' 07='7-OTHER' 96='96-DK' 97='97-REF' .='(MISSING)' 98='98-SKIP' ; VALUE A1Q05Q 1='1-PEDIATRICIAN ' 2='2-FAMILY PRACTITIONER' 3='3-PEDIATRIC NURSE PRACTITIONER' 4='4-PHYSICIAN_S ASSISTANT' 5='5-OTHER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A1Q06Q 1='1-URBAN - IN A CITY ' 2='2-SUBURBAN - IN THE SUBURBS' 3='3-RURAL - OUTSIDE A CITY OR SUBURBS' 4='4-OTHER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A1Q07Q 1='1-MAN ' 2='2-WOMAN ' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A1Q09Q 01='1-WHITE ' 02='2-BLACK' 03='3-HISPANIC' 04='4-AMERICAN INDIAN' 05='5-ASIAN' 06='6-SOME OTHER GROUP' 96='96-DK' 97='97-REF' .='(MISSING)' 98='98-SKIP' ; VALUE A1Q10Q 1='1-ALREADY BEING USED BY SOMEONE ELSE IN THE FAMILY' 2='2-RECOMMENDED BY SOMEONE YOU TRUST' 3='3-CHOSEN BY YOU FROM A LIST OF HEALTH PROVIDERS' 4='4-ASSIGNED TO YOU BY THE CLINIC OR PRACTICE' 5='5-OTHER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A1Q10_AQ 1='1-RECOMMENDED BY SOMEONE YOU TRUST ' 2='2-CHOSEN BY YOU FROM A LIST OF HEALTH PROVIDERS.' 3='3-ASSIGNED TO YOU BY THE CLINIC OR PRACTICE.' 5='5-OTHER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A2Q02Q 1='1-TOO MUCH TIME ' 2='2-ABOUT THE RIGHT AMOUNT OF TIME' 3='3-NOT ENOUGH TIME' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A2Q06Q 1='1-VERY LIKELY ' 2='2-SOMEWHAT LIKELY' 3='3-SOMEWHAT UNLIKELY' 4='4-VERY UNLIKELY' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A2Q07Q 1='1-VERY IMPORTANT ' 2='2-IMPORTANT' 3='3-SOMEWHAT IMPORTANT' 4='4-NOT IMPORTANT AT ALL' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A3Q38Q 1='1-ALWAYS ' 2='2-USUALLY' 3='3-SOMETIMES' 4='4-NEVER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A4Q05Q 1='1-ALWAYS ' 2='2-SOMETIMES' 3='3-RARELY' 4='4-NEVER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE AGEFOOD 95='FOOD NOT INTRODUCED YET' 96='96-DK ' 97='97-REF' 98='98-SKIP' .='(MISSING)' ; VALUE A4Q01Q 1='1-SAME EVERY DAY ' 2='2-CHANGES FROM DAY TO DAY' 3='3-NOT APPLICABLE' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A4Q02Q 1='1-EVERY DAY ' 2='2-ONE TO TWO DAYS' 3='3-THREE TO SIX DAYS' 4='4-NEVER' 0='0-NOT APPLICABLE' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A4Q06Q 1='1-RIGHT AMOUNT OF TIME ' 2='2-A LOT MORE TIME' 3='3-A LITTLE MORE TIME' 4='4-A LITTLE LESS TIME' 5='5-A LOT LESS TIME' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A4Q07Q 1='1-OFTEN ' 2='2-SOMETIMES' 3='3-RARELY' 4='4-NEVER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A4Q08Q 1='1-YES ' 0='0-NO' 3='3-NOT APPLICABLE' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A4Q11Q 1='1-RELATIVE ' 2='2-NON-RELATIVE' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A4Q12Q 1='1-IN YOUR HOME ' 2='2-IN SOMEONE ELSES HOME' 3='3-IN A DAYCARE CENTER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A5Q01Q 1='1-ALL OF THE TIME ' 2='2-MOST OF THE TIME' 3='3-A GOOD BIT OF THE TIME' 4='4-SOME OF THE TIME' 5='5-A LITTLE OF THE TIME' 6='6-NONE OF THE TIME' 96='96-DK' 97='97-REF' .='(MISSING)' 98='98-SKIP' ; VALUE A5Q02Q 1='1-VERY WELL ' 2='2-SOMEWHAT WELL' 3='3-NOT VERY WELL' 4='4-NOT WELL AT ALL' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A5Q05Q 1='1-A LOT ' 2='2-A LITTLE' 3='3-NOT AT ALL' 4='4-N/A' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A6Q13Q 01='1-YES ' 00='0-NO' 03='3-DO NOT KNOW ABOUT THE PROGRAM' 06='96-DK' 07='97-REF' .='(MISSING)' 08='98-SKIP' ; VALUE A7Q05Q 01='1-MOTHER (STEP,FOSTER,ADOPTIVE) ' 02='2-FATHER (STEP,FOSTER,ADOPTIVE)' 03='3-SISTER OR BROTHER (STEP,FOSTER,HALF,ADOPTIVE)' 04='4-IN-LAW OF ANY TYPE' 05='5-AUNT/UNCLE' 06='6-GRANDPARENT' 07='7-OTHER FAMILY MEMBER' 08='8-FRIEND' 96='96-DK' 97='97-REF' .='(MISSING)' 98='98-SKIP' ; VALUE A7Q08Q 1='1-EMPLOYED FULL TIME' 2='2-EMPLOYED PART TIME' 3='3-NOT EMPLOYED' 4='4-OTHER' 6='6-DK' 7='7-REF' .='(MISSING)' 8='8-SKIP' ; VALUE A7Q07Q 1='1-MARRIED ' 2='2-WIDOWED' 3='3-DIVORCED' 4='4-SEPARATED' 5='5-NEVER MARRIED' 96='6-DK' 97='7-REF' .='(MISSING)' 98='8-SKIP' ; VALUE A6Q01X 1='1-LOT OF TROUBLE ' 2='2-SOME TROUBLE ' 3='3-NO TROUBLE AT ALL ' 4='4-NA ' 6='96-DK' 7='97-REF' .='(MISSING)' 8='98-SKIP' ; VALUE EDUCM 1='LESS THAN HIGH SCHOOL' 2='HIGH SCHOOL GRAD ' 3='MORE THAN HS GRAD ' 6='6-DK' 7='7-REF' ; VALUE XINCBRAC .='(MISSING)' 1='1-UP TO $7500' 2='2-$7501 - 17500' 3='3-$17501 - 25000' 4='4-$25001 - 35000' 5='5-$35001 - 45000' 6='6-$45001 - 60000' 7='7-$60001 - 75000' 8='8-OVER $75000' 96='96-DK' 97='97-REF' 98='98-SKIP' ; VALUE A1Q01R 16='16+' 996='996-DK ' 997='997-REF' 998='998-SKIP' .='(MISSING)' ; VALUE A1Q02R 11='11+' 996='996-DK ' 997='997-REF' 998='998-SKIP' .='(MISSING)' ; VALUE A4Q10R 60='60+' 995='995-NO TIME WITH CHILDCARE PROVIDER' 996='996-DK ' 997='997-REF' 998='998-SKIP' .='(MISSING)' ; VALUE A5Q10R 7='7+' 996='996-DK ' 997='997-REF' 998='998-SKIP' .='(MISSING)' ; VALUE A5Q11R 7='7+' 996='996-DK ' 997='997-REF' 998='998-SKIP' .='(MISSING)' ; VALUE A5Q12R 50='50+' 996='996-DK ' 997='997-REF' 998='998-SKIP' .='(MISSING)' ; VALUE A7Q01R 10='10+' 96='96-DK ' 97='97-REF' 98='98-SKIP' .='(MISSING)' ; VALUE A7Q01AR 6='6+' 96='96-DK ' 97='97-REF' 98='98-SKIP' .='(MISSING)' ; VALUE NUMCHILR 4='4+' 96='96-DK ' 97='97-REF' 98='98-SKIP' .='(MISSING)' ; VALUE A7Q11R 17='<=17' 49='49+' 96='96-DK ' 97='97-REF' 98='98-SKIP' .='(MISSING)' ; VALUE RACERF 1='1-WHITE ' 2='2-BLACK' 3='3-NAT AME/ALASKA NAT' 4='4-ASIAN' 5='5-OTHER' 96='96-DK' 97='97-REF' .='(MISSING)' 98='98-SKIP' ; VALUE BTHWGTR 1='1-<1500 GRAMS' 2='2-1500-2499 GRAMS' 3='3-2500-2999 GRAMS' 4='4-3000-3499 GRAMS' 5='5-3500-3999 GRAMS' 6='6-4000-4499 GRAMS' 7='7-4500+ GRAMS' 96='96-DK' .='(MISSING)' ; VALUE BFEEDR 31='31) 31-60 ' 61='61) 61-90 ' 91='91) 91-120 ' 121='121) 121-150 ' 151='151) 151-180 ' 181='181) 181-210 ' 211='211) 211-240 ' 241='241) 241-270 ' 271='271) 271-300 ' 301='301) 301-330 ' 331='331) 331-360 ' 361='361) 361+ ' 996='996-DK' 999='999-STILL B-FEEDING' ; VALUE REGIONF 1='1-NORTHEAST' 2='2-MIDWEST' 3='3-SOUTH' 4='4-WEST' ; run; *----------------------------------------------*; * ASSIGN FORMATS TO VARIABLES *; *----------------------------------------------*; data puf.frmtsech; set puf.datasech; FORMAT A1Q01R A1Q01R. A1Q02R A1Q02R. A1Q03 A1Q03Q. A1Q04R YN. A1Q05R A1Q05Q. A1Q06R A1Q06Q. A1Q07R A1Q07Q. A1Q08R NUM2D. A1Q09R A1Q09Q. A1Q10_AR A1Q10_AQ. A1Q10BZ1-A1Q10BZ4 YN. A1Q10R A1Q10Q. A2Q01 NUM2D. A2Q02 A2Q02Q. A2Q03 YN. A2Q04X01-A2Q04X06 YN. A2Q05 NUM2D. A2Q06 A2Q06Q. A2Q07 A2Q07Q. A2Q08 H2Q11Q. A3Q01 YN. A3Q01_A YN. A3Q02 YN. A3Q02_A YN. A3Q03 YN. A3Q03_A YN. A3Q04 YN. A3Q04_A YN. A3Q05 YN. A3Q05_A YN. A3Q06 YN. A3Q06_A YN. A3Q07 YN. A3Q07_A YN. A3Q08 YN. A3Q08_A YN. A3Q09 YN. A3Q09_A YN. A3Q10 YN. A3Q10_A YN. A3Q11 YN. A3Q12 YN. A3Q12_A YN. A3Q13 YN. A3Q13_A YN. A3Q14 YN. A3Q14_A YN3X. A3Q15 YN. A3Q15_A YN3X. A3Q16 YN. A3Q16_A YN. A3Q17 YN. A3Q17_A YN. A3Q18 YN. A3Q18_A YN. A3Q19 YN. A3Q19_A YN. A3Q20 YN. A3Q20_A YN. A3Q21 YN. A3Q21_A YN. A3Q22 YN. A3Q22_A YN. A3Q23 YN. A3Q23_A YN. A3Q24 YN. A3Q25 YN. A3Q25_A YN. A3Q26 YN. A3Q26_A YN. A3Q27 YN. A3Q27_A YN. A3Q28 YN. A3Q28_A YN. A3Q29 YN. A3Q29_A YN. A3Q30 YN. A3Q30_A YN. A3Q31 YN. A3Q31_A YN. A3Q32 YN. A3Q32_A YN. A3Q33 YN. A3Q33_A YN. A3Q34 YN. A3Q34_A YN. A3Q35 YN. A3Q35_A YN. A3Q36 YN. A3Q36_A YN. A3Q37 YN. A3Q38_A A3Q38Q. A3Q38_B A3Q38Q. A3Q38_C A3Q38Q. A3Q38_D A3Q38Q. A3Q39 YN. A3Q39_A YN. A3Q40 YN. A3Q40_A YN. A3Q41 YN. A3Q41_A YN. A3Q42 YN. A3Q42_A YN. A3Q43 YN. A3Q43_A YN. A3Q44 YN. A3Q44_A YN. A3Q45 YN. A3Q45_A YN. A3Q46 YN. A3Q46_A YN. A3Q47 YN. A3Q47A01-A3Q47A07 YN. A3Q48 YN. A3Q48A01--A3Q48A04 YN. A3Q49 YN. A3Q49_A YN. A3Q50 YN. A3Q50_A YN. A3Q51 YN. A3Q51_A YN. A3Q51_B YN. A3Q52 YN. A3Q54 YN. A3Q55 YN. A3Q56 AGEFOOD. A4Q01_A A4Q01Q. A4Q01_B A4Q01Q. A4Q01_C A4Q01Q. A4Q02X1R A4Q02Q. A4Q02X2R A4Q02Q. A4Q02X3R A4Q02Q. A4Q02X4R A4Q02Q. A4Q02X5R A4Q02Q. A4Q03 NUM2D. A4Q04 NUM3D. A4Q05 A4Q05Q. A4Q06 A4Q06Q. A4Q06 NUM2D. A4Q07X01-A4Q07X05 A4Q07Q. A4Q08X01-A4Q08X05 A4Q08Q. A4Q09 YN. A4Q10R A4Q10R. A4Q11 A4Q11Q. A4Q12 A4Q12Q. A5Q01X01-A5Q01X05 A5Q01Q. A5Q02 A5Q02Q. A5Q03 YN. A5Q04 YN. A5Q05X01-A5Q05X11 A5Q05Q. A5Q06X01-A5Q06X05 YN. A5Q07 YN. A5Q07_A YN. A5Q07_B YN. A5Q08 YN. A5Q08_A YN. A5Q08_B YN. A5Q09_A YN. A5Q09_B YN. A5Q09CX1-A5Q09CX4 YN. A5Q09D11-A5Q09D14 YN. A5Q09D21-A5Q09D24 YN. A5Q09D31-A5Q09D34 YN. A5Q09D41--A5Q09D44 YN. A5Q09D51--A5Q09D54 YN. A5Q09E11-A5Q09E14 YN. A5Q09E21-A5Q09E24 YN. A5Q09E31-A5Q09E34 YN. A5Q10R A5Q10R. A5Q11R A5Q11R. A5Q12R A5Q12R. A6Q01X01-A6Q01X05 A6Q01X. A6Q03--A6Q09 YN. A6Q09_A1--A6Q09_A8 YN. A6Q09_B YN. A6Q09_C NUM2D. A6Q09_C NUM2D. A6Q10 YN. A6Q10_A NUM2D. A6Q10_A NUM2D. A6Q11 YN. A6Q12 YN. A6Q13 A6Q13Q. A6Q14 YN. A7Q01_AR A7Q01AR. A7Q01R A7Q01R. A7Q05 A7Q05Q. A7Q07 A7Q07Q. A7Q08R A7Q08Q. A7Q11R A7Q11R. A7Q12 YN. ARANGE2 RANGE. BASE9 YN. BFEEDR BFEEDR. BTHWGTR BTHWGTR. I_EDUCM EDUCM. I_GENDER GENDERF. I_HISP_K YN. I_RACEKR RACERF. IND_OTH YN. INSURE YN. INT_LANG INTLANG. KFLG_EDU YN. KFLG_HIS YN. KFLG_RAC YN. MED_SCHP YN. MOMHISP YN. MOMRACER RACERF. NUMCHILR NUMCHILR. OVERSAMP YN. REGION REGIONF. XBESTINC XINCBRAC. ; run;