use cross\crossdata, clear sort socialgpid individid merge socialgpid using cross\crosshouseholdinfo drop if _merge ==2 egen totalnumbers = count (bod), by (socialgpid) save cross\crossdata, replace