*SAS PROGRAM; *test67.SAS; ********************************************; OPTIONS OBS = max NOCENTER COMPRESS = YES; FILENAME IN '[afdcqc.sassets]fy67.dat' ; LIBNAME TEMP "UI_SYSDA:[AFDCQC]"; *OPTIONS OBS=100; x 'gunzip [afdcqc.sassets]fy67.dat'; proc format; VALUE FINCOME .Z='Zero' .U='Unknown' ; VALUE $SHLTAST "1"="Yes" "2"="No" "-"="unknown" ; VALUE $FDSTAMP "1"="No food plan in effect" "2"="Donated food-family participates" "3"="Donated food-plan-family doesn't participate" "4"="Donated food-participation unknown" "5"="Food stamp-family participates" "6"="Food stamp-family doesn't participate" "7"="Food stamp-participation unknown" "-"="unknown" ; VALUE $WHOOASD "1"="Retired, disabled, or deceased father" "2"="Retired, disabled, or deceased mother" "3"="Other person" "-"="unknown" "+"="Inapplicable" ; VALUE $DADSTS "0"="Dead" "2"="Unemployed" "1"="Incapacitated" "3"="Divorced" "4"="Legally separated" "5"="Separated without court decree" "6"="Deserted" "7"="Not married to mother" "8"="In Prison" "9"="Absent for another reason" "-"="Stepfather case" "+","Y"="kids not deprivd dad's support but mom's" ; VALUE $DAD_DIA "000"-"999"="000-999" "+++"="Not applicable" "---"="Unknown" ; VALUE $DAD_ALC "1"="Yes" "2"="No" "-"="unknown" "+"="Not applicable" ; VALUE $DADRES "1"="In the home" "2"="Mental institution" "3"="Other medical institution" "4"="Prison or reformatory" "5"="Other institution" "6"="Same county" "7"="Different county, same state" "8"="Different state in the United States" "9"="A foreign country" "-"="Whereabouts unknown" "+"="Inapplicable (father deceased)" ; VALUE $DRCVAFD "1"="Yes" "2"="No" "-"="unknown" ; VALUE $DADEDUC "0"="none -4th grade" "1"="5th to 7th grade" "2"="8th grade" "3"="9th-11th grade" "4"="High school graduate" "5"="1st-3rd year college" "6"="College graduate" "9"="Unknown" "-"="unknown" ; VALUE $DAD_OCC "0"="Professional,manager,official,etc" "1"="Clerical, sales, and kindred workers" "2"="Craftsmen, foremen, kindred workers" "3"="Farm owners and managers" "4"="Farm tenants, renters, sharecroppers" "5"="Farm laborers" "6"="Operatives, other skilled/semi workers" "7"="Service workers except private household" "8"="Private household service workers" "9"="Unskilled laborers" "-"="Never held full-time employment" "+"="Unknown" ; VALUE $MOMSTS "0"="employed full-time (35 hrs/week or more)" "1"="employed part-time (< 35 hrs/week)" "2"="phys or mentally incapacitated for work" "3"="no marketable skills or suitable employ" "4"="needed in home full time as homemaker" "5"="None of the above-actively seeking work" "6"="None of the above-not seeking work" "7"="Dead" "8"="Deserted" "9"="In medical institution other than mental" "-"="In a mental institution" "+"="Absent for another reason" ; VALUE $MOMEDUC "0"="none -4th grade" "1"="5th to 7th grade" "2"="8th grade" "3"="9th-11th grade" "4"="High school graduate" "5"="1st-3rd year college" "6"="College graduate" "-"="Unknown" ; VALUE $MOM_OCC "0"="Professional,manager,official,etc" "1"="Clerical, sales, and kindred workers" "2"="Craftsmen, foremen, kindred workers" "3"="Farm owners and managers" "4"="Farm tenants, renters, sharecroppers" "5"="Farm laborers" "6"="Operatives, other skilled/semi workers" "7"="Service workers except private household" "8"="Private household service workers" "9"="Unskilled laborers" "-"="Never held full-time employment" "+"="Unknown" ; VALUE $MRCVAFD "1"="Yes" "2"="No" "-"="unknown" ; VALUE $MOM_ALC "1"="Yes" "2"="No" "-"="unknown" "+"="Inapplicable (mother deceased)" ; VALUE $CHDCARA "0"="Inapplicable" "1"="Kids cared for in own home by relative" "2"="Kids cared for in own home by nonrelative" "3"="Kids cared for in oth home by relative" "4"="Kids cared for in oth home by nonrelative" "5"="Group care (day care, nursery sch, etc)" "6"="Child looks after self" "7"="Mom cares for kid while working/training" "8"="Other" "-"="Arrangements unknown" "+"="Inapplicable" ; VALUE $CHDCARB "0"="Inapplicable" "1"="Kids cared for in own home by relative" "2"="Kids cared for in own home by nonrelatve" "3"="Kids cared for in oth home by relative" "4"="Kids cared for in oth home by nonrelative" "5"="Group care (day care, nursery sch, etc)" "6"="Child looks after self" "7"="Mom cares for kid while working/training" "8"="Mother works only during childs school hours" "9"="Other" "-"="Arrangements unknown" "+"="Inapplicable" ; VALUE $AGECARE "1"="Under 13 years of age" "2"="13-15 years of age" "3"="16 years of age or older" "-"="Unknown" "+"="Inapplicable" ; VALUE $STATE "11"="MAINE" "12"="NEW HAMPSHIRE" "13"="VERMONT" "14"="MASSACHUSETTS" "15"="RHODE ISLAND" "16"="CONNECTICUT" "21"="NEW YORK" "22"="NEW JERSEy" "23"="PENNSYLVANIA" "3"="PUERTO RICA" "31"="OHIO" "32"="INDIANA" "33"="ILLINOIS" "34"="MICHIGAN" "35"="WISCONSIN" "4"="OTHER TERRITORIES" "41"="MINNESOTA" "42"="IOWA" "43"="MISSOURI" "44"="NORTH DAKOTA" "45"="SOUTH DAKOTA" "46"="NEBRASKA" "47"="KANSAS" "51"="DELAWARE" "52"="MARYLAND" "53"="DIST. OF COL." "54"="VIRGINIA" "55"="WEST VIRGINIA" "56"="NORTH CAROLINA" "57"="SOUTH CAROLINA" "58"="GEORGIA" "59"="FLORIDA" "61"="KENTUCKy" "62"="TENNESSEE" "63"="ALABAMA" "64"="MISSISSIPPI" "71"="ARKANSAS" "72"="LOUISIANA" "73"="OKLAHOMA" "74"="TEXAS" "81"="MONTANA" "82"="IDAHO" "83"="WYOMING" "84"="COLORADO" "85"="NEW MEXICO" "86"="ARIZONA" "87"="UTAH" "88"="NEVADA" "91"="WASHINGTON" "92"="OREGON" "93"="CALIFORNIA" "94"="ALASKA" "95"="HAWAII" "03"="Puerto Rica" "--"="Unknown" other="Other territories" ; VALUE $RESIDE "0"="In SMSA city of 400,00 or more" "1"="In SMSA city of 400,00 or more" "2"="In SMSA city of 400,00 or more" "3"="In SMSA city of 250,00 to 399,999" "4"="In SMSA city of 100,000 to 249,000" "5"="In SMSA city of Less than 100,000" "6"="In SMSA Outside of the central city" "7"="Not SMSA,town 2,500 or more" "8"="Not SMSA,on a farm" "9"="Not SMSA,not farm/town > than 2,500" "+"="Does not currently reside in this state" "-"="Unknown" ; VALUE $XNUM "-","--"="Unknown" "+","++"="Inapplicable" ; VALUE FMONOPEN 001-024="001-024" 025-100="025-100" 101-200="101-200" 201-300="201-300" 301-400="301-400" ; VALUE $RCV_PA "00"="No-never received public assistance" "01"="Aid to the permanently/ totally disabled" "02"="General assistance" "10"="A separate AFDC case" "20"="Old-age assistance" "40"="Aid to the blind" "--"="Unknown" "++"="Inapplicable" other="Combination of assistance (see codebook)" ; VALUE $WTH_REC "01"="Grandparents" "02"="Other relatives" "04"="Nonrelatives" "10"="Mother or stepmother" "20"="Father or stepfather" "40"="Other brothers or sisters" "--"="Unknown" other="Combination of persons (see codebook)" ; VALUE $RACE "1"="White" "2"="Black" "3"="American Indian" "4"="Other" "-"="Unknown" ; VALUE $SHELTER "1"="Home being bought by AFDC group" "2"="Home is being bought by oth hhld members" "3"="Home is rented: public housing" "4"="Home is rented: private housing" "5"="Home is occupied rent-free" "-"="Ownership unknown" "+"="Inapplicable: home is group quarters" ; VALUE $PRIAFDC "1"="Yes, AFDC received <12 months prior" "2"="Yes, AFDC received 12-23 months prior" "3"="Yes, AFDC received 2-4 years prior" "4"="Yes, AFDC received 5-9 years prior" "5"="Yes, AFDC received 10 or more yrs prior" "6"="Yes, AFDC received, time unknown" "7"="No, AFDC not received prior to monopen" "-"="Unknown" ; VALUE $ORIGIN "1"="Mexican" "2"="Puerto Rican" "3"="Cuban" "4"="Other Hispanic Origin" "5"="Not Hispanic Origin" "-"="Dont know" ; VALUE $SAMEPAR "1"="Same mom and same dad" "2"="Same mom, but two or more diff dads" "3"="Same dad but two or more diff moms" "4"="2 or more diff dads, 2 or more diff moms" "-"="Unknown" ; VALUE $SRV_PRO "000"="Not a defined service case" "001"="Money management" "002"="Absence other than desertion" "004"="All other" "010"="Children in need of protection" "020"="Children with serious special problems" "040"="Serious problem in family functioning" "100"="Unmarried parenthood" "200"="Desertion" "400"="Self-support of adult or older child" "---"="No specific problem area yet identified" other="Combination of services (see codebook)" ; VALUE $SRV_PRV "0000"="No" "0001"="Self-care services" "0002"="Self-support services" "0004"="Other" "0010"="Protection of children" "0020"="Protective services for adults" "0040"="Returning persons from inst care" "0100"="Maintaining improved family life" "0200"="Maintain/improve social/community" "0400"="Maintaining home" "1000"="Educational or vocational training" "2000"="Health care" "4000"="Improved finanancial functioning" "9999"="unknown whether services give" "----"="Unknown" other="Combination of services (see codebook)" ; VALUE $SRV_NEE "1"="No- homemaker services not needed" "2"="Services needed but not available" "3"="Needed,available but not provided" "4"="Yes, homemaker services were provided" "-"="unknown" ; VALUE $FAM_PLA "00"="No" "01"="Yes: family planning agency" "02"="Yes: religious counselor" "04"="Yes: other agency or individual" "10"="Yes: public welfare caseworker" "20"="Yes: Public health department" "40"="Yes: Medical clinic or private physician" "--"="unknown" other="Combination of services (see codebook)" ; VALUE $FAM_LAS "1"="Within the past year" "2"="At least 1 but less than 3 years ago" "3"="At least 3 but less than 5 years ago" "4"="5 or more years ago" "+"="Inapplicable" "-"="unknown" ; VALUE $VOC_REF "1"="Accepted for voc rehab, still receiving" "2"="Accepted for voc rehab,case now closed" "3"="Accepted for voc rehab,unk if still open" "4"="Accepted for voc rehab,refused service" "5"="Not accepted for voc rehab services" "6"="Unknown whether accepted for sevices" "7"="Yes. Referral made more than 2 yrs ago" "8"="No. Never referred" "-"="unknown whether ever referred" ; VALUE $VOC_WHO "1"="The father" "2"="The mother" "3"="One of the children" "4"="Other member of the family" "+"="Inapplicable- no member referred" "-"="Unknown" ; VALUE $VOC_RCV "00"="No services yet received" "01"="Med trtment and/or prosthetic appliances" "02"="Medical examination" "04"="Other" "10"="Job placement and/or follow up" "20"="Vocational training" "40"="Self-care or pre-vocational training" "--"="Type of service unknown" "++"="Inapplicable" other="Combination of voc rehab (see codebook)" ; VALUE $TRAIN "1"="Currently: under Title V Econ Opptnty Act" "2"="Currently:Manpower Develp & Training Act" "3"="Currently:Commnty Work & Training Pgm" "4"="Currently:other work or training program" "5"="Formerly:under Title V Econ Opptnty Act" "6"="Formerly:Manpower Develp & Training Act" "7"="Formerly:Commnty Work & Training Pgm" "8"="Formerly:other work or training program" "9"="No: not enrolled in past 2 years" "-"="Dont know" ; VALUE $WHO_TRN "1"="The father" "2"="The mother" "3"="One of the children" "4"="Other member of the family" "+"="Inapplicable: no one enrolled" "-"="Unknown" ; ; VALUE $CHLD_SR "1"="Yes: Crippled Childrens Services only" "2"="Yes: Child Welfare Services only" "3"="Yes: Crippled Children & Child Welfare" "4"="No" "-"="unknown" ; VALUE $CINAFDC "1"="Yes" "2"="No- child is not eligible" "3"="No-unk if eligib,incl in application" "4"="No-unk if eligib,not incl in application" ; VALUE $MMCBIRT "01"="January" "02"="February" "03"="March" "04"="April" "05"="May" "06"="June" "07"="July" "08"="August" "09"="September" "10"="October" "11"="November" "12"="December" "++"="Inapplicable" "--"="Unknown" ; VALUE $YEAR "++"="Inapplicable" "--"="Unknown" ; VALUE $SEX "1"="Male" "2"="Female" "+"="Inapplicable" ; VALUE $INSCHOO "1"="Yes" "2"="No: because of physical incapacity" "3"="No: because of mental incapacity" "4"="No: too young to attend any available" "5"="No: other reason" "-"="unknown" "+"="Inapplicable" ; VALUE $GRADE "00"="None" "01"="First grade" "02"="Second grade" "03"="Third grade" "04"="Fourth grade" "05"="Fifth grade" "06"="Sixth grade" "07"="Seventh grade" "08"="Eighth grade" "09"="Nineth grade" "10"="Tenth grade" "11"="Eleventh grade" "12"="Twelf grade" "40"="Head Start school" "41"="Nursery school" "42"="Kindergarten" "50"="Special school for the mentally retarded" "++"="Inapplicable" "--"="Unknown" ; VALUE $cdadsts "0"="Dead" "1"="Incapacitated" "2"="Unemployed" "3"="Dad absent: parents divorced" "4"="Dad absent: parents legally separated" "5"="Dad absent: parents separtd wo court ord" "6"="Dad absent: has deserted" "7"="Dad absent: not married to mom" "8"="Dad absent: in prison" "9"="Dad absent: another reason" "-"="Other status" "+"="Inapplicable: child not AFDC recipient" ; VALUE $PHYSEXA "0"="Med inf: Child dosnt have this condition" "1"="Med inf: Needs being met or planned for" "2"="Med inf: Needs not being met/planned for" "3"="Med inf: No known needs for medical care" "4"="Med inf: does not have this condition" "5"="Oth inf: Child dosnt have this condition" "6"="Oth inf: Needs being met or planned for" "7"="Oth inf: Needs not being met/planned for" "8"="Oth inf: No known needs for medical care" "-"="Oth inf: does not have this condition" "+"="Inapplicable" ; *UNIT LEVEL; DATA TEMP.U001; INFILE IN LRECL = 80 MISSOVER; INPUT @7 CARDNO $char1. @; IF CARDNO = '1' THEN INPUT @1 STATE $char2. @3 S_CODE 4. @8 COUNTY $char2. @11 RESIDE $char1. @12 NUMADL $char1. @13 NUMCHD $char2. @15 NUMOTHR $char1. @16 NUMTOT $char2. @18 OTHRHH $char1. @19 NUMHH $char2. @21 RCV_PA $char2. @23 WTH_RECP $char2. @25 RACE $char1. @26 SHELTER $char1. @27 NUM_ROOM $char1. @28 PER_ROOM $char2. @30 MONOPEN 3. @33 PRIAFDC $char1. @34 ORIGIN $char1. @35 SAMEPAR $char1. @36 SRV_PROB $3. @39 SRV_PRV $3. @43 SRV_NEED $char1. @44 FAM_PLAN $char2. @46 FAM_LAST $char1. @47 VOC_REF $char1. @48 VOC_WHO $char1. @49 VOC_RCV $char2. @51 TRAIN $char1. @52 WHO_TRN $char1. @53 CHLD_SRV $char1. @54 INAFDC1 $char1. @55 INAFDC2 $char1. @56 INAFDC3 $char1. @57 INAFDC4 $char1. @58 INAFDC $char2. ; ELSE DELETE; label STATE="State code (1960 census)"; label S_CODE="Study code"; label RESIDE="In what type of place does family live?"; label NUMADL="# adults receiving AFDC wth fed matching"; label NUMCHD="# kids receiving AFDC with fed matching"; label NUMOTHR="# others in the AFDC assistance group"; label NUMTOT="Total in AFDC assistant group"; label OTHRHH="Other persons in household"; label NUMHH="Number in household"; label RCV_PA="Others receive public assistance in mo?"; label WTH_RECP="Persons in houselhold wth recipient kids"; label RACE="Race of payee"; label SHELTER="Home owned, bought, rented by occupnts"; label NUM_ROOM="How many rooms occupied by household?"; label PER_ROOM="Average number of persons per room"; label MONOPEN="# Mos from most recnt opening AFDC case"; label PRIAFDC="Did family receive AFDC prior monopen"; label ORIGIN="Origin or race of payee"; label SAMEPAR="All kids AFDC grp have same dad & mom?"; label SRV_PROB="75% federal financial particpation case?"; label SRV_PRV="Social services provided last 90 days?"; label SRV_NEED="Fam need homemaker services in last yr?"; label FAM_PLAN="Received family planning services?"; label FAM_LAST="How long ago family planning received?"; label VOC_REF="Vocational rehabilitation referral?"; label VOC_WHO="Who referred for vocational rehab?"; label VOC_RCV="What voc rehab services in past 2 yrs?"; label TRAIN="Anyone enrolled non voc rehab training?"; label WHO_TRN="Who enrolled in this program?"; label CHLD_SRV="Kid rcvd crippled chld/welfare past?"; label INAFDC1="# AFDC children under 6 years"; label INAFDC2="# AFDC children 6-12 years"; label INAFDC3="# AFDC children 13-17 years"; label INAFDC4="# AFDC children 18-20 years"; label INAFDC="Total AFDC recipient children"; DATA TEMP.U002; INFILE IN LRECL = 80 MISSOVER; INPUT @7 CARDNO $char1. @; IF CARDNO = '2' THEN INPUT @1 STATE $char2. @3 S_CODE 4. @8 DADSTS $char1. @9 DAD_DIAG $char3. @12 YYDBIRTH $char2. @14 PLDBIRTH $char2. @16 DAD_ALC $char1. @17 DADRES $char1. @18 DRCVAFDC $char1. @19 DADEDUC $char1. @20 DAD_OCCP $char1. @21 MOMSTS $char1. @22 YYMBIRTH $char2. @24 PLMBIRTH $char2. @26 MOMEDUC $char1. @27 MOM_OCCP $char1. @28 MRCVAFDC $char1. @29 YEARMOVE $char2. @31 MOMRES $char2. @33 MOM_ALC $char1. @34 CHDCARE1 $char1. @35 AGECARE1 $char1. @36 CHDCARE2 $char1. @37 AGECARE2 $char1. ; ELSE delete; label DADSTS="Dad's status relative kid's AFDC eligib"; label DAD_DIAG="If dad incapacitated, major diagnosis"; label YYDBIRTH="Year of father's birth"; label PLDBIRTH="Father's place of birth"; label DAD_ALC="Father regularly impaired by alcholol?"; label DADRES="Where is father currently residing"; label DRCVAFDC="Did the father receive AFDC as a child?"; label DADEDUC="Highest grade school completed by father"; label DAD_OCCP="Usual occupational class of the father."; label MOMSTS="What is the status of the mother?"; label YYMBIRTH="Mother's year of birth"; label PLMBIRTH="Mother's place of birth"; label MOMEDUC="Highest grade completed by mother"; label MOM_OCCP="Current or usual occupation mother"; label MRCVAFDC="Did this mother receive AFDC as a child."; label YEARMOVE="When mom move to state of residence"; label MOMRES="Where mom live prior to St of residence"; label MOM_ALC="mother regularly impaired by alcholol?"; label CHDCARE1="How kids<6 cared for while mom works"; label AGECARE1="Age individual caretaker of kids <6"; label CHDCARE2="How kids 6-12 cared for while mom works"; label AGECARE2="Age individual caretaker of kids 6-12"; DATA TEMP.U003; INFILE IN LRECL = 80 MISSOVER; INPUT @7 CARDNO $char1. @; IF CARDNO = '3' THEN INPUT @1 STATE $char2. @3 S_CODE 4. @8 MOMINC 3. @11 DADINC 3. @14 CHDINC 3. @17 OTRINC 3. @20 SUPPAY 3. @23 OASDIRR 3. @26 UCOMP 3. @29 CONOTHR 3. @32 OTHRCASH 3. @35 INKIND 3. @38 TOTINC 3. @41 DDWORK 3. @44 OUTAFDC 3. @47 DDCHLD 3. @50 OTHEREXP 3. @53 CHDNEED 3. @56 DDINC 3. @59 NETINC 3. @62 AFDC 3. @65 GENAST 3. @68 TOTAST 3. @71 TOTNEED 3. @74 UNMET 3. @77 SHLTAST $char1. @78 FDSTAMP $char1. @79 WHOOASDI $char1. ; ELSE DELETE; * convert missing codes to .; array array3 MOMINC DADINC CHDINC OTRINC SUPPAY OASDIRR UCOMP CONOTHR OTHRCASH INKIND TOTINC DDWORK OUTAFDC DDCHLD OTHEREXP CHDNEED DDINC NETINC AFDC GENAST TOTAST TOTNEED UNMET ; do over array3; if (array3 eq 0) then array3=.Z; else if (array3 eq 999) then array3=.U; end; label MOMINC="Nonassistance income (mother)"; label DADINC="Nonassistance income(Father)"; label CHDINC="Nonassistance income(Child)"; label OTRINC="Nonassistance income(Other)"; label SUPPAY="Contributions from absent father"; label OASDIRR="OASDI and/or railroad Retirement benefit"; label UCOMP="Unemployment compensation"; label CONOTHR="Contribs other persons in the household"; label OTHRCASH="Oher cash income"; label INKIND="Other income inkind $ value is given"; label TOTINC="Total monthly nonassistance income"; label DDWORK="Allowed emply expense: Other"; label OUTAFDC="Alloc support depends outside AFDC grp"; label DDCHLD="Allowed emply expense: Childcare"; label OTHEREXP="Alloc oth expenses not in assist budget"; label CHDNEED="Set aside for future needs dpndnt chldrn"; label DDINC="Additional disregard income"; label NETINC="Net remaining income in AFDC budget"; label AFDC="Monthly assistant Income: AFDC payment"; label GENAST="Monthly assistant Income: Gen assist"; label TOTAST="Total monthly nonassistance income"; label TOTNEED="Amts budgeted 1969:Full standard need"; label UNMET="Recognize unmet need"; label SHLTAST="Shelter assistance(rent, mortgage,taxes)"; label FDSTAMP="Food program participation"; label WHOOASDI="Whose OASDI benefits"; DATA PERSON; INFILE IN LRECL = 80 MISSOVER; INPUT @7 CARDNO $char1. @; IF CARDNO = '-' THEN INPUT @1 STATE $char2. @3 S_CODE 4. @8 PLINENO $char2. @10 CINAFDC $char1. @11 MMCBIRTH $char2. @13 YYCBIRTH $char2. @15 SEX $char1. @16 INSCHOOL $char1. @17 GRADE $char2. @19 cdadsts $char1. @20 cincome1 $char3. /* CHDINC in character data */ @23 cincome1 $char3. /* DDCHDINC in character data */ @26 PHYSEXAM $char1. @27 VISUAL $char1. @28 HEARING $char1. @29 SPEECH $char1. @30 DENTAL $char1. @31 ORTHO $char1. @32 MENTAL $char1. @33 NERVOUS $char1. @34 HEART $char1. @35 OTH_COND $char1. ; label PLINENO="Adult/child indentifier"; label CINAFDC="Is this child an AFDC recipient?"; label MMCBIRTH="Month of child's birth"; label YYCBIRTH="Year of child's birth"; label SEX="Sex"; label INSCHOOL="Attending school end of Oct 1967?"; label GRADE="Current/highest grade completed"; label cdadsts="Status child's natural/adoptive dad"; label CHDINC="Child's total gross monthly income"; label DDCHDINC="Childs $ disregarded computing AFDC"; label PHYSEXAM="Child receive med exam past 2 yrs?"; label VISUAL="Some visual defect"; label HEARING="Hearing impairments"; label SPEECH="Speech defects"; label DENTAL="Dental impairments"; label ORTHO="Orthopedic impairments"; label MENTAL="Mental retardation"; label NERVOUS="Emotional or other nervous disorders"; label HEART="Heart abnormality or rhuematic fever"; label OTH_COND="Other chronic conditions"; ELSE DELETE; *convert cincome1 cincome2 to numeric; drop cincome1 cincome2; if (cincome1 eq '+++') then cincome1='.Z'; if (cincome2 eq '+++') then cincome2='.Z'; CHDINC=INPUT(cincome1,F3.); DDCHDINC=INPUT(cincome2,F3.); DATA UNIT; RETAIN UNIT_ID 0; MERGE TEMP.U001 TEMP.U002 TEMP.U003 ; BY STATE S_CODE; UNIT_ID +1; label UNIT_ID="Unit Identifier"; RUN; proc print data=unit (obs=30); title 'Unit level -- 1967'; proc print data=Person (obs=30); title 'Person level -- 1967'; PROC CONTENTS DATA=UNIT; title 'Unit level -- 1967'; PROC CONTENTS DATA=Person; title 'Person level -- 1967'; PROC FREQ DATA=PERSON; tables STATE PLINENO CINAFDC MMCBIRTH YYCBIRTH SEX INSCHOOL GRADE cdadsts PHYSEXAM VISUAL HEARING SPEECH DENTAL ORTHO MENTAL NERVOUS HEART /list missing; FORMAT STATE $STATE. CINAFDC $CINAFDC. MMCBIRTH $MMCBIRT. YYCBIRTH $YEAR. SEX $SEX. INSCHOOL $INSCHOO. GRADE $GRADE. cdadsts $cdadsts. PHYSEXAM VISUAL HEARING SPEECH DENTAL ORTHO MENTAL NERVOUS HEART OTH_COND $PHYSEXA. ; title 'Person level -- 1967'; Proc means data=person; var CHDINC DDCHDINC; title 'Person level -- 1967'; PROC FREQ DATA=UNIT; tables STATE COUNTY RESIDE NUMADL NUMCHD NUMOTHR NUMTOT OTHRHH NUMHH RCV_PA WTH_RECP RACE SHELTER NUM_ROOM PER_ROOM MONOPEN PRIAFDC ORIGIN SAMEPAR SRV_NEED FAM_PLAN FAM_LAST VOC_REF VOC_WHO VOC_RCV TRAIN WHO_TRN CHLD_SRV INAFDC INAFDC1 INAFDC2 INAFDC3 INAFDC4 DADSTS DAD_DIAG YYDBIRTH PLDBIRTH DAD_ALC DADRES DRCVAFDC DADEDUC DAD_OCCP MOMSTS YYMBIRTH PLMBIRTH MOMEDUC MOM_OCCP MRCVAFDC YEARMOVE MOMRES MOM_ALC CHDCARE1 AGECARE1 CHDCARE2 AGECARE2 SHLTAST FDSTAMP WHOOASDI /list missing; FORMAT STATE $STATE. RESIDE $RESIDE. MONOPEN FMONOPEN. OTHRHH NUMHH NUM_ROOM PER_ROOM $XNUM. FDSTAMP $FDSTAMP. SHLTAST $SHLTAST. WHOOASDI $WHOOASD. DADSTS $DADSTS. DAD_DIAG $DAD_DIA. YYDBIRTH YYMBIRTH $YEAR. PLDBIRTH $STATE. DAD_ALC $DAD_ALC. DADRES $DADRES. DRCVAFDC $DRCVAFD. DADEDUC $DADEDUC. DAD_OCCP $DAD_OCC. MOMSTS $MOMSTS. PLMBIRTH $STATE. MOMEDUC $MOMEDUC. MOM_OCCP $MOM_OCC. YEARMOVE $YEAR. MRCVAFDC $MRCVAFD. MOMRES $STATE. MOM_ALC $MOM_ALC. CHDCARE1 $CHDCARA. CHDCARE2 $CHDCARB. AGECARE1-AGECARE2 $AGECARE. STATE $STATE. RCV_PA $RCV_PA. WTH_RECP $WTH_REC. RACE $RACE. SHELTER $SHELTER. PRIAFDC $PRIAFDC. ORIGIN $ORIGIN. SAMEPAR $SAMEPAR. SRV_PROB $SRV_PRO. SRV_PRV $SRV_PRV. SRV_NEED $SRV_NEE. FAM_PLAN $FAM_PLA. FAM_LAST $FAM_LAS. VOC_REF $VOC_REF. VOC_WHO $VOC_WHO. VOC_RCV $VOC_RCV. TRAIN $TRAIN. WHO_TRN $WHO_TRN. CHLD_SRV $CHLD_SR. ; title 'Unit level -- 1967'; proc means data=unit; var S_CODE MOMINC DADINC CHDINC OTRINC SUPPAY OASDIRR UCOMP CONOTHR OTHRCASH INKIND TOTINC DDWORK OUTAFDC DDCHLD OTHEREXP CHDNEED DDINC NETINC AFDC GENAST TOTAST TOTNEED UNMET ; title 'Unit level -- 1967'; RUN; x 'gzip [afdcqc.sassets]fy67.dat';