• RE: Census Bureau plans to stop production of 3-year ACS data

    I don't often use the 3-year data, but I just found myself looking forward to a 3-year PUMS data set with all 3 years aligned with the 2010 PUMAs. Our PUMA boundaries changed significantly, making it very hard to work with multiple year data that straddle…
  • Calculating a Weighted Share of a Larger Group

    Hi folks, 

    I've got a bit of a conundrum. I am trying to replicate a Pew analysis of multi-racial groups by mapping ancestry onto race (Pew's methodology is here, and is not super clear). Basically, I am using R to try to create a simple racial…

  • RE: ACS and EEO Employment Tables

    Hi Cliff--
    This past spring, I worked on a similar thing. I summarized Census ACS PUMS data into an updated report of metro area civilian workforce composition, by race, gender, and disability -- each of those variabless crosstabulated with EEO-4 job…
  • RE: Android app: Gateway To MAST

    It has recently come to my attention that when people search the Google Play Store for Gateway To MAST (which creates custom tabulations of ACS PUMS), it sometimes does not appear first in the search results, but may be buried by a few pages, even though…

  • RE: ACS 5-Year 2019 (demographic groups under income threshold)

    There are a couple aspects of the CHAS data about which users should be aware and that are not well documented. 

    If you are familiar with how federal housing funds works, you probably know that what we call "80%" of Area Median Income (AMI) is often not…

  • RE: Stata error with ACS API

    Hi ,

    Unfortunately, I did not. My experience has been that I've had issues from both Stata's end and from the Census, and things work one day and break the next.

    One of my colleagues has adapted a work around to use Stata and Python…
  • Making The Most of 2017 ACS 5 Year Data

    Greetings Colleagues,

    I have been trying to find a time efficient way of sourcing census data for all block groups in a State. The AFF site only allows this for one county at a time. Data Ferrett looks like it is no longer maintained. Whether or not that…

  • Creating Multi-Year estimates

    Since Census Bureau discontinued the 3-year multiyear estimates files in 2014, I'm attempting to create 3-year estimate files for more recent years using PUMS. After contacting ACS support, they mentioned a simple approach of combining the 1-year files…

  • Missing values for replicate weights

     Good morning,

    I am using SAS to generate estimates from pooled 2012-2015 ACS PUMS data. Below is the macro I am using to average the 4 years of replicate weights. Also shown below is the error message indicating that missing values are produced. How have…