please help me form the STATA command for the following,.. I am not able to formulate it. please
I am using a data set which is in this form
householdid Personid religion gender expenditure
101 1 1 1 100
102 1 1 1 200
102 2 1 1 300
103 1 2 1 300
103 2 2 2 500
104 1 1 2 100
104 2 1 2 50
and so on
Say gender 1- boy 2 is girl
religion 1 is hindu 2- muslims
I need command help to find:
1. How many HH s have 2 sons and how many have 1 daughter and 1 son or both daughters
2. difference between the two child consumption expenditure if a family has more than one child?
There are families with even 3 or more child but i need to focus more on 2 child part
Plese help
I am using a data set which is in this form
householdid Personid religion gender expenditure
101 1 1 1 100
102 1 1 1 200
102 2 1 1 300
103 1 2 1 300
103 2 2 2 500
104 1 1 2 100
104 2 1 2 50
and so on
Say gender 1- boy 2 is girl
religion 1 is hindu 2- muslims
I need command help to find:
1. How many HH s have 2 sons and how many have 1 daughter and 1 son or both daughters
2. difference between the two child consumption expenditure if a family has more than one child?
There are families with even 3 or more child but i need to focus more on 2 child part
Plese help
Comment