• RE: Statistically comparing estimates

    Here is the response I got from the Census Bureau directly.  Just some food for thought!

    "You are correct that the poverty rate for Cook county is not independent from Illinois.  Depending on what they are using…

  • 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: 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…
  • having problems recreating table B09021 "Living Arrangements of Adults 18 Years and Over by Age"

    Hi:

    I'm running these variables

    Where AGEP >17;
    TABLES HHT*RELSHIPP*SPORDER ;
          WEIGHT PWGTP;

    I only get good estimates for  householder living with spouse or spouse of householder,  Child of householder and Lives alone.and total

    the problem is because…

  • 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…

  • RE: 2012 ACS 1-year estimates are now available

    For many reasons I use AFF only when I have to. For many of my projects I use Data Ferrett or PUMS data, both of which have a steep learning curve, but has allowed me to dig much deeper into the data than I could otherwise. Honestly, I usually just do…