Children and Parents Employment Status

1
Children and Parents Employment Status

• Nancy Oliver and Leonard Gaines
• New York State Data Center
• Empire State Development

2
Client Request

• Reason
• Determine need for additional daycare centers in
  each county
  
• Data needed
• Number of children under 13 living with
  unemployed parents by county

3
Solution Requirements

• Children in age group
• Adults responsible for childs care
• Employment status of adults

4
Problems Encountered

• Summary data counts adults by
• their employment status
• presence of children
• Wrong age groups
• Geography
• PUMS structured the wrong way

5
Solution Method

• Use PUMAs instead of counties
• Restructure PUMS
• Identify responsible adults
• Tabulate children by responsible adults
  employment statuses

6
Original PUMS Structure
7
SPSS PUMS Structure
8
Desired PUMS Structure
9
Restructuring PUMS

• Create temporary files
• Children
• Householders
• Spouses
• Subfamily heads
• Subfamily spouses
• Merge files based on common ID field

10
Final Steps

• Identify the employment status of responsible
  adults
  
• All responsible adults employed
• 1 responsible adult unemployed
• All responsible adults unemployed
• At least 1 responsible adult not in the labor
  force
  
• Complicated IF statement
• Run cross tabulation

11
Final Table