Calculate Member of Household Rooster Value with Source from Repeat and Non-repeat Question

Thank you for reaching out and providing the necessary details. To generate a “Vulnerability” variable for each child in the Household Rooster (Repeated Group), we need to consider composite questions from both the repeated group and the household level.

Based on the provided formulation, we will calculate the factors A, B, and C for each child. If a child meets at least two factors, they will be classified as vulnerable.

To ensure separate data for children, we will filter the dataset to include only the children in the Household Rooster. Then, we’ll calculate the factors and determine vulnerability accordingly.

Please let me know if you have any further questions or if there’s anything else I can assist you with.