It looks like you are using the SDA online analysis tool; please let me know if that is not the case.

Unfortunately, it may not be realistic to replicate this table using SDA. Family income as measured by FTOTINC is an IPUMS-created variable that sums individual income for family members based on families defined as FAMUNIT. IPUMS USA only offers the Census Bureau measure of family income as an unharmonized or source variable (US2018C_FINCP for the 2014-2018 5-year ACS data); source variables are not available for SDA , but you may include them as part of a data extract for analysis in a statistical package. I encourage you to review the documentation in FTOTINC and this information on families and income in ACS data for some context about the different definitions of families.

If you want to use FTOTINC and SDA to create a table of the median family income as measured by FTOTINC, remember to exclude any missing/out of universe values for FTOTINC. If you weight with HHWT, you should restrict your analytical sample to a single person per household (I recommend doing this by specifying `pernum(1-1)`

in the selection filters field). Note that if a household contains more than one family, this approach will not capture the second family’s unique value for FTOTINC. You may be interested in including the IPUMS USA variable HHTYPE in your selection filters to try and mimic the family households that Census uses in its version of the table; I suspect that this is what you are getting at with your selection filter using FAMSIZE. It seems like you are using the “Means” tab and selecting median as the percentile to display under the “Median/Percentile Options” drop down menu; I don’t know of another way to use SDA to calculate the median for continuous variables with as many values as FTOTINC.