Good day everyone,
I'd like to categorize these variables into 3 or 4 options e.g Father and Mother = Parent (s), Brother and Sister = siblings(s)
clear
input str31 Familycomposition
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother"
"Father, Mother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister"
"Father, Mother"
"Father, Mother"
"Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Mother, Sister"
"Father, Mother, Brother"
"Father, Mother"
"Father, Mother, Sister"
"Brother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister"
"Father, Mother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father"
"Father, Mother"
"Father, Mother, Brother"
"Father, Mother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Mother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Sister"
"Father, Mother, Sister"
"Father, Mother, Sister"
"Father"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother"
"Father, Mother, Sister"
"Father, Mother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother"
"Brother"
"Father, Mother, Brother"
"Father, Mother"
end
I'd like to categorize these variables into 3 or 4 options e.g Father and Mother = Parent (s), Brother and Sister = siblings(s)
clear
input str31 Familycomposition
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother"
"Father, Mother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister"
"Father, Mother"
"Father, Mother"
"Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Mother, Sister"
"Father, Mother, Brother"
"Father, Mother"
"Father, Mother, Sister"
"Brother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister"
"Father, Mother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father"
"Father, Mother"
"Father, Mother, Brother"
"Father, Mother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Mother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Sister"
"Father, Mother, Sister"
"Father, Mother, Sister"
"Father"
"Father, Mother, Brother"
"Father, Mother, Sister"
"Father, Mother, Sister, Brother"
"Father, Mother"
"Father, Mother, Sister"
"Father, Mother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother, Brother"
"Father, Mother, Sister, Brother"
"Father, Mother, Brother"
"Father, Mother"
"Brother"
"Father, Mother, Brother"
"Father, Mother"
end
Comment