Hi there! I’m trying to calculate medians of household income for RACED groups, adjusted for household size, using the SDA online data analysis tool.

I’m planning on doing an equivalence scale adjustment to HHINCOME, by diving household income by the square root of the number of people in the household. To do this, what I’m doing is creating a new variable: HHIADJ = HHINCOME / sqrt(NUMPREC). I’m setting the Missing-data code for the new computed var as 9999999.

I’m a little confused by the documentation in SDA on variable computation and missing data codes, but my understanding is that all instances of HHINCOME = 9999999 are now stored in the new variable with the missing data code, so HHIADJ = 9999999.

If I go to calculate median HHIADJ under the Means tab, are the missing data automatically excluded from the median calculations? I tried to test this by filtering for HHIADJ(0-9999998) and got slightly different results. Is it because of instances of HHIADJ between 9999998 and 9999999, or am I doing something wrong?

I’m sure I must be missing some elementary information about how missing data codes work in SDA, but I’ve looked high and low and still feel paranoid that I’m doing something wrong.

Thanks in advance for any help!