June 26 Webinar: ACS Resources, Shortcuts, and Tools

  • Calculating Standard Error of A Median in SAS

    Working with 2016 ACS PUMS data. Can anyone share how to get the standard error for a median using SAS? For example, if one was looking for the median of gross rent, it's easy enough to multiply grntp by adjhsg and find the median, but how do you calculate…

  • Recent Census Bureau Guidance on Calculating Standard Errors for Derived Estimates

    If you've been using the guidance and formulas in Appendix 3 of the ACS Compass Handbooks to calculate Margins of Error for ACS estimates that you have derived, then you might want to review the updated guidance and formulas that the Census Bureau provided…

  • Calculating Less than 2.00X FPL

    We frequently find ourselves calculating a statistic like "the population (with a margin of error) earning less than 2.00X the FPL". These fields are found in the C17002 (C17002_001 to C17 C17002_008) family of tables. (data.census.gov/table

    …

  • Calculating Standard Error of Median Income in PUMS using R

    Hello,

     

    I would like to use R to calculate the standard error of the median income of a population represented in PUMS. I would like to do this using replicate weights, if possible.

     

    I know how to calculate the standard error of an estimate using replicate…

  • 2013 PUMS error and re-release of data

    Users should note that there was an error in the original 2013 1-year and 3-year ACS PUMS files affecting the "MV" variable (when the householder moved into this house or apartment).

    The files are being re-released.
    Users should replace any…

  • Some tables have field names with dates in them, so to re-run any reports each year = revisit field names / descriptions

    OK, some tables ex B25038 have hard-coded field descriptions that change every 2 years. I think the actual column name would stay the same? and it would just be the description would change. Typicially you never have time dimensions like this. It's last…

  • Total population differences between table for same census tracts

    Hello,

    I have limited experience with the ACS data.   I am working with 2020 ACS data in Los Angeles County.  I am comparing People with Disabilities vs Age & Sex (and other tables that have the same population total).  The total population is different…

  • RE: What's the smallest geographic slice to browse ACS data?

    Hi Diana,

    thanks for your notes here! Would be curious to read your blog post :)

    Aggregating by geography makes sense.

    Regarding aggregating by rows/categories, you said

    > For example, with the age and sex breakdowns in your screenshot, could you live…

  • RE: Small Area Estimation R Package

    Dear DUG,

    I have updated the Windows installer 31 March 2024 (see  https://dorerfoundation.org/software)

    You can now compute replicate weights that take into account the Margin of Error for the adjusting target marginal tables.

    These new functions need…

  • ACS 5-year: Are GQs included in VRE tables?

    I am looking to calculate margin of error for percents calculated using ACS 5-year estimates at the block group level for the variable C17002 (ratio of poverty level to income for the past 6 months). 

    Does the VRE table for this variable include estimates…

For more information about the American Community Survey Census Bureau Website