Is there a way to use the online data analysis tool to compute, for example, the share of households receiving food stamps, based on a condition that applies to the household members (for example, 1 or more household members are veterans)?
The only way that I’m aware of to generate counts or percentages of households (rather than individuals) is to use the “relate” variable to select only one household member (relate = 1 to select the head of household). But since that filters out other household members, it seems to preclude creating a variable that is evaluated across other members (such as counting up the number of household members for whom vetstat = 2).
Appreciate any insight!