dear members
I have a data of household survey. the households are divided into PSU's (primary sampling units). these PSU's are defined on the basis of location i.e. if they collected data from 5 different areas in a city, these 5 areas are defined by 5 PSUs, placing all the households in an area in a single PSU. Number of households vary in each PSU. Other information given is on the income and consumption of each household
I want to calculate median income for each PSU and then add a variable in my dataset, calculated by using formula, (Income of the household) / (Median income in PSU).
please help me how I can do it in stata
Thank you
I have a data of household survey. the households are divided into PSU's (primary sampling units). these PSU's are defined on the basis of location i.e. if they collected data from 5 different areas in a city, these 5 areas are defined by 5 PSUs, placing all the households in an area in a single PSU. Number of households vary in each PSU. Other information given is on the income and consumption of each household
I want to calculate median income for each PSU and then add a variable in my dataset, calculated by using formula, (Income of the household) / (Median income in PSU).
please help me how I can do it in stata
Thank you
Comment