ACS Data Users Group

 View Only
Back to discussions
Expand all | Collapse all

having problems recreating table B09021 "Living Arrangements of Adults 18 Years and Over by Age"

  • 1.  having problems recreating table B09021 "Living Arrangements of Adults 18 Years and Over by Age"

    Posted 10-31-2024 04:10 PM

    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 I can get what is the "reference person" situation I think.

    Love some help. I need to recreate this table to be able to then use it to get it by ethnicity

    thanks



  • 2.  RE: having problems recreating table B09021 "Living Arrangements of Adults 18 Years and Over by Age"

    Posted 11-06-2024 02:32 PM

    The householder is the reference person SPORDER == 1 Also RELSHIPP == 20

    Universe is 18 years and older in households. Make sure to drop group quarters records RELSHIPP 37 or 38

    Also are you grouping the RELSHIPP values to agree with B09021 ?

    Dave Dorer