2025 ACS CONFERENCE RECORDINGS AND PRESENTATIONS ARE NOW AVAILABLE ON THE CONFERENCES PAGE.
American Community Survey Data Users Group
American Community Survey Data Users Group
  • Sign Up
  • Log in
  • Site
  • Search for topics, people, or keywords
  • User
  • Home
  • Discussion Forum
  • ACS Resources
  • Webinars
  • Conferences
  • Steering Committee
  • More
  • Cancel
  • Home
  • Discussion Forum
  • ACS Resources
  • Webinars
  • Conferences
  • About
  • More
  • Cancel
  • How to translate STATA code to R (creating flags and new variables)

    regonzalez
    regonzalez

    Hello,I have the following STATA code that I am needing to translate over to R (this code uses the 2019 5-year ACS PUMS file):

    /*Create a flag to identify workers in the household*/
    gen worker=(wkl=="1")
    replace worker=. if wkl==""

    …
    • over 3 years ago
    • Discussion Forum
    • Forum
  • RE: Same Sex married Couples

    Beth Jarosz
    Beth Jarosz
    What geographic level are you looking for?
    National, single-year data (through 2015) can be found at www.census.gov/.../ssc-house-characteristics.html
    But I also do not recall seeing small-area data in any of the summary files (and I did recently look…
    • over 7 years ago
    • Discussion Forum
    • Forum
  • Design Factor for Poverty Status

    Elizabeth
    Elizabeth

    Hi, 

     

    I'm looking to cross tabulate a few different variables with a dichotomous poverty variable (below threshold or not) in the 1-year PUMS.  I derived the poverty status variable by recoding the income to poverty ratio.  Unfortunately the statistical…

    • over 8 years ago
    • Discussion Forum
    • Forum
  • RE: Adjusting Income in ACS

    John Grumbine
    John Grumbine
    After reading David's response, I realized that the answer may depend on whether you're using PUMS or pre-tabulated data.
    • over 9 years ago
    • Discussion Forum
    • Forum
  • RE: Using ACS to construct a socioeconomic index and margins of error

    Beth Jarosz
    Beth Jarosz

    This ACS Handbooks provide a set of formulas you can use to calculate MOE. (See Chapter 8 https://www.census.gov/content/dam/Census/library/publications/2020/acs/acs_general_handbook_2020_ch08.pdf)

    The only challenge is (as you described above) the formulas…

    • over 4 years ago
    • Discussion Forum
    • Forum
  • RE: sum of grouped PUMA estimates within a state not equalling state estimate

    Doug Hillmer
    Doug Hillmer
    Is the state-level estimate that you're trying to match from the published 05-07 tables? If so, those estimates cannot be matched exactly by the PUMS estimates because the PUMS data is a sub-sample from the full sample which is used to create the published…
    • over 10 years ago
    • Discussion Forum
    • Forum
  • RE: Question of ACS 5 year Income

    Diana Lavery
    Diana Lavery
    Hi Gan,

    My understanding is that the summary tables are already adjusted into 2014 dollars. I'm assuming they would have to use the same adjustments that users have to use when working with PUMS data, if you wanted to create your own tables not published…
    • over 9 years ago
    • Discussion Forum
    • Forum
  • RE: Inflation Adjustment

    Diana Lavery
    Diana Lavery
    The income/earnings questions don't go by calendar years, they go by "earnings/income in the past 12 months." I think what they are doing is somehow averaging the current survey year's and the previous year's CPI-U-RS (although...not everyone would be…
    • over 7 years ago
    • Discussion Forum
    • Forum
  • RE: Interpolation for median earnings

    Justin Keller
    Justin Keller

    7455.median_with_linear_interpolation.docx8712.median_with_linear_interpolation.txt

     

     

     

    Hello-

    Attached are a .txt and Word version that were provided by some colleagues here at Census. It doesn't look like I can upload the SAS file directly.

    Just…

    • over 8 years ago
    • Discussion Forum
    • Forum
  • RE: 2012-2016 Language - no local geographies

    Cliff Cook
    Cliff Cook
    I came across this problem yesterday and was quite surprised in light of a Census Bureau press release that featured the break out of additional languages in this table. I'll be able to work around this problem once the PUMS data is available, but it…
    • over 7 years ago
    • Discussion Forum
    • Forum
<>
For more information about the American Community Survey Census Bureau Website
prb logo prb