ACS Data Users Group

 View Only
  • 1.  Table not generating data

    Posted 02-27-2020 05:59 PM

    Hello,

    I am trying to get summary data to compare to another survey I am using for my dissertation. Working with the 2012 PUMS 1-year estimates, for people ages 55 to 64, I am trying to get counts by sex, income groups, race, and educational attainment. When I set up my table with the variables, I am getting all ??? for my counts. I feel like I am missing something simple but cannot figure it out. I've followed the step-by-step guide to create custom groups but am not having luck generating data when I try to view my table.

    Any suggestions?

    Kindly,

    Aaron



  • 2.  RE: Table not generating data

    Posted 02-28-2020 01:57 PM
    What tool(s) are you using to work with the data?


  • 3.  RE: Table not generating data

    Posted 02-28-2020 02:57 PM
    Thanks for asking! I used the custom table tool from the data.census.gov site. I suppose I could go to the files on the FTP site and try to create the data using STATA but I was hoping to get the table builder to work first.


  • 4.  RE: Table not generating data

    Posted 02-28-2020 03:18 PM
    Gottcha. The MDAT system is still in Beta testing, so I suspect there may be something that isn't working quite right. (Colleagues and PRB and I also could not get results.)
    So for now I would suggest downloading the PUMS tables and using STATA.

    Please also submit a comment about this issue to cedsci.feedback@census.gov
    Census Bureau staff take user input into consideration as they're working on upgrades and new releases of their tools, and they really do appreciate a heads-up when something doesn't work.


  • 5.  RE: Table not generating data

    Posted 02-28-2020 04:17 PM
    Another option is to use the IPUMS USA online data analysis system: https://usa.ipums.org/usa/sda/. You'll find basic instructions and tutorials through the same link, and with those, I think you'd be able to request the info you're looking for fairly quickly.


  • 6.  RE: Table not generating data

    Posted 03-04-2020 03:18 PM
    Thanks, Jonathan! I was not previously familiar with IPUMS. Great resource, thank you for sharing.