• RE: Inflation Adjustment

    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…
  • How to translate STATA code to R (creating flags and new variables)

    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==""

  • RE: Using ACS to construct a socioeconomic index and margins of error

    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…

  • RE: Detailed group quarters type

    Dear Andy,

    Here is some info that I found on intercensal group quarters.  The methods are part of the Population Estimates Program (PEP).  I also emailed with the people in the GQ group. You may be familiar with this info.  Here is how GQ population estimates…

  • RE: Area Median Income Data

    I would encourage you not to give up too quickly. As Cliff pointed out, it isn't trivial to do this, but neither is it so difficult that it isn't worth trying (depending on how much you want the data). To demonstrate, I created & uploaded a tabulation…
  • RE: Family Structure and Income

    Could someone provide a little more background on the RELP variable? My exposure to PUMS is through the IPUMS site. A quick look there does not reveal RELP in the list of variable definitions.
  • RE: statistical methods for comparing of 2 1-year surveys

    Beth,

    Would you say that any statistical test requiring independence would be inappropriate? Another one that has been suggested in my group is to put two years of pums data together and use year as a variable in a regression. This model also requires…
  • RE: Interpolation for median earnings

    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…

  • Aggregating county income medians by sex

    Hello,

    I am trying to calculate the aggregate median income by sex of 10 counties within the same state. This question highlights how to calculate an aggregate median income in general. The answer in the question uses binned incomes from table B19001 to…

  • SSI Estimates

    Looking at 2014 ACS PUMs data and we are looking at persons receiving SSI income. Can anyone answer why/how person can have $30,000 in SSI income? The maximum benefit is $1100 per month if you have an eligible spouse, so it appears that no one should…