• RE: workers in their POWPUMA

    Also if you are looking at employed persons that will most likely be where they live, not where they work. I believe there are a limited number of tables in the ACS that have workers as the universe and geography is by place of work. I am not as familiar…
  • ACS 1 Year Microdata Question

    Hi,

    I am a total novice using MDAT. However, for a research project I am trying to download a CSV of a custom table I've built with several recoded variables with a given state as my selected geography.

    I'm haven't been able to download a CSV that has…

  • RE: Complete ACS data series

    Hi Julio. The PUMS microdata provides detailed linguistic and ancestry data. www.census.gov/.../pums.html. The spatial resolution is lower than the tabular ACS data, but you can gain a great deal in terms of detail. I hope this might be of some help to…
  • Educational attainment data VS CPS ASEC

    Hi everyone!

    Has anybody looked into this apparent statistically significant difference between the two surveys on educational attainment data?

    2020 CPS counts a total of 113381 thousand 18+ civilian noninstitutionalized population with at least an associates…

  • Property Tax Topcodes

    Hi all,

    I am working on cross-state differences in property taxes in 2015.

    If I understand the data dictionary correctly, the ACS variable TAXAMT (PROPTX99 in IPUMS) is topcoded in all states and years at 10,000 USD (category value 68). 

    For states with high…

  • SAS code to calculate Margin of Error/ confidence interval

    I am a relatively new user of PUMS data. I use the 2016 1 year estimate PUMS population data, subset it to a dataset include the individual data for a county within the age group of my interest (ffx). Then I need to calculate the population estimate of…

  • RE: County level estimates

    Bernie, thank you for your suggestions and it's very helpful. Do you know how use the Counties in PUMS data? I have to compute the count of these veterans who would be eligible for VA healthcare using their income and disability fields in the PUMS data…
  • RE: Educational attainment by race/ethnicity and county - can't get totals and subtotals to match

    Using the PUMS data which allow me to get data for planning districts on attainment by race, Spanish/Hispanic/Latino, and gender for all ages, I see what I was getting wrong.   In the regular tables for educational attainment age 25+, I can get match the…

  • RE: Estimating Rental Burden (GRAPI) by Race of Householder

    While I haven't tried to retrace your steps, I think this might be a universe issue. The Census Bureau doesn't calculate cost burden for households with no income or negative income. Because Stata treats missing values as the largest possible value, your…
  • Question about the ESR Variable

    Was looking at occupation data from PUMS, and also using the ESR variable.

    If ESR=6, you are not in the labor force. I assumed that would mean that you had no OCCP value as well.

    That assumption is wrong. Can someone explain why you'd have an OCCP code…