Using DataFerrett to Analyze and Extract Census Bureau Data

Select Population Variables

  1. Goto http://www.census.gov/acs/www/data_documentation/data_ferrett_for_pums/
  2. Click on "Launch DataFerrett" to goto http://dataferrett.census.gov/LaunchDFA.html
  3. Click on Run
  4. Enter Email address:
  5. Click OK
  6. Click "Get Data Now" in lower right
  7. In left panel, click "American Community Survey"
  8. Click "Public Use Microdata Sample"
  9. Rt-click year, then "View Variables"
  10. Check Selectable Geographies, Population, and Geographic Entities
  11. Click "Search Variables"
  12. Click on CIT: 2006-current: Citizenship status
  13. Click Select (to select all) and click OK
  14. On "You have added 1 variable for your DataBasket" popup, click OK
  15. Repeat for ESR: 2006-current: Employment status recode
  16. Repeat for OCCP: 2012-current: Occupation recode for 2012 based on 2010 OCC codes
  17. Click on tab "Step 2: DataBasket/Download/Make A Table

Create Recode Variables

  1. Highlight CIT, click Recode Variable
  2. Highlight 1,2, and 3 in left pane, then click on Recode button
  3. Highlight 4 in left pane, then click on Recode button
  4. Change Labels on right pane to match the following:
    1  Citizen by birth                {1,2,3}
    2  U.S. citizen by naturalization  {4}
    3  Not a citizen                   {5}
    
  5. Set CIT recode is label for the Variable Recode of CIT
  6. Click OK (name given by system is RECODE9)
  7. Highlight OCCP, click Recode Variable
  8. Highlight 0100, click Recode
  9. Highlight 1020, click Recode
  10. Highlight 1010, click Recode
  11. Highlight 1005-1007 and 1030-1240, click Recode
  12. Highlight 0300, click Recode
  13. Highlight 1300-1560, click Recode
  14. Highlight 0360, click Recode
  15. Highlight 1600-1965, click Recode
  16. Highlight 0350, click Recode
  17. Highlight 3000-3655, click Recode
  18. Highlight 0120, click Recode
  19. Highlight 0800, click Recode
  20. Highlight 0810-0950, click Recode
  21. Highlight 0010-0430 not grayed out, click Recode
  22. Change labels to match the following:
    1  MGR-COMPUTER AND INFORMATION SYSTEMS MANAGERS                {0110}
    2  CMM-SOFTWARE DEVELOPERS, APPLICATIONS AND SYSTEMS SOFTWARE   {1020}
    3  CMM-COMPUTER PROGRAMMERS                                     {1010}
    4  Other Computer and Mathematical                              {1005-1007 and 1030-1240}
    5  MGR-ARCHITECTURAL AND ENGINEERING MANAGERS                   {0300}
    6  Architectural and Engineering                                {1300-1560}
    7  MGR-NATURAL SCIENCES MANAGERS                                {0360}
    8  Life, physical, and social science                           {1600-1965}
    9  MGR-MEDICAL AND HEALTH SERVICES MANAGERS                     {0350}
    10 Medical and Health Services                                  {3000-3655}
    11 MGR-FINANCIAL MANAGERS                                       {0120}
    12 FIN-ACCOUNTANTS AND AUDITORS                                 {0800}
    13 Other Financial                                              {0810-0950}
    14 Other Managers                                               {0010-0430 (not grayed out)}
    15 Not Elsewhere Classified (nec.)
    
  23. Set OCCP recode is label for the Variable Recode of OCCP
  24. Click OK

Create Multi-Variable Data Step

  1. Highlight ESR and RECODE9
  2. Click "Create Multi-Variable Data Step"
  3. Check "Display Values in Variable List" in lower right
  4. Paste the following formula in the left pane:
    if (ESR == 1) {D_RCD11 = RECODE9;} else {D_RCD11 = 4;}
    
  5. Check "Assign labels to values" in upper left
  6. Click "Add a new value" 4 times
  7. Add Labels to match the following:
    1  Citizen by birth
    2  U.S. citizen by naturalization
    3  Not a citizen
    4  Not employed
    
  8. Click OK
  9. Click File|Save As|job2012 (Files of type: Ferrett Session Files)
  10. (in later seesion, retrieve job2012 and click on tab "Step 2: DataBasket/Download/Make A Table)

Generate United States numbers

  1. Click "Make A Table" and click OK
  2. Drag RECODE10 OCCP recode to R2C1
  3. Drag D_RCD11 Dynamic recode11 to R1C2
  4. Click "GO Get Data" (Total D_RCD11=313,914,040)
  5. File|Save As|job2012|Ferrett Tabulation Files|Save
  6. File|Save As|job2012c|Text Documents - Comma Delimited|Save

Generate California numbers

  1. Close table (click X in upper right)
  2. Click Step1: Select Dataset & Variable
  3. Under Public Use Microdata Sample in left panel, highlight 2012
  4. Rt-click|View Variables
  5. Check Selectable Geographies
  6. Click Search Variables
  7. Double-click "Selectable Geographies" (Ferrett Geography Codebook window comes up)
  8. Highlight "State" in left panel
  9. Highlight "State of current residence" in middle pane
  10. Click "Use Hierarchy"
  11. Drag "California" from left pane to right pane
  12. Click "Finish" in lower right
  13. Click tab "Step 2: DataBasket/Download/Make A Table"
  14. Click "Make A Table"
  15. Drag RECODE10 OCCP recode to R2C1
  16. Drag D_RCD11 Dynamic recode11 to R1C2
  17. Click "GO Get Data" (Total D_RCD11=38,041,430)
  18. File|Save As|job2012ca|Ferrett Tabulation Files|Save
  19. File|Save As|job2012cac|Text Documents - Comma Delimited|Save

Generate Silicon Valley numbers

  1. Close table (click X in upper right)
  2. Click Step1: Select Dataset & Variable (skip prior steps)
  3. Double-click "Selectable Geographies" (Ferrett Geography Codebook window comes up)
  4. Highlight "State" in left panel
  5. Highlight "State of current residence > Public use of microdata area code (PUMA) based on 2010 Census" in middle pane
  6. Click "Use Hierarchy"
  7. Drag "California" from left pane to MIDDLE pane
  8. Click "Next Level"
  9. Highlight 6 San Mateo Regions and drag to right pane
  10. Highlight 14 Santa Clara Regions and drag to right pane
  11. Click "Finish" in lower right
  12. Highlight GEOG-101 FIPS State Code and click "Delete Variable(s)" (not deleting will cause state to be used)
  13. Click tab "Step 2: DataBasket/Download/Make A Table"
  14. Click "Make A Table"
  15. Drag RECODE10 OCCP recode to R2C1
  16. Drag D_RCD11 Dynamic recode11 to R1C2
  17. Click "GO Get Data" (Total D_RCD11=2,577,187)
  18. File|Save As|job2012sv|Ferrett Tabulation Files|Save
  19. File|Save As|job2012svc|Text Documents - Comma Delimited|Save

Generate Alameda/SF counties numbers

  1. Close table (click X in upper right)
  2. Click Step1: Select Dataset & Variable
  3. Double-click "Selectable Geographies" (Ferrett Geography Codebook window comes up)
  4. Highlight "State" in left panel
  5. Highlight "State of current residence > Public use of microdata area code (PUMA) based on 2010 Census" in middle pane
  6. Click "Use Hierarchy"
  7. Drag "California" from left pane to MIDDLE pane
  8. Click "Next Level"
  9. Click "Clear All" to clear right pane
  10. Highlight 10 Alameda County Regions and drag to right pane
  11. Highlight 7 San Francisco County Regions and drag to right pane
  12. Click "Finish" in lower right
  13. Click tab "Step 2: DataBasket/Download/Make A Table"
  14. Click "Make A Table"
  15. Drag RECODE10 OCCP recode to R2C1
  16. Drag D_RCD11 Dynamic recode11 to R1C2
  17. Click "GO Get Data" (Total D_RCD11=2,380,584)
  18. File|Save As|job2012sf|Ferrett Tabulation Files|Save
  19. File|Save As|job2012sfc|Text Documents - Comma Delimited|Save

Go to Budget Home Page