Hi everyone,
I am using DHS data for all countries for some exploratory analysis. The variable religion in the DHS dataset has some missing values for some countries (either whole or partly).
a) For countries where religion is missing completely:
From external sources, I can get the proportion of people that belong to a certain religion in a specific country. Say for instance India (country code=10) is 94% Hinduism (religion_code=1), 3% Muslims (religion_code=2), 2 Christians (religion_code=3), and 1% others (religion_code=4). Is there a way I can replace the missing values for religion in India in a random manner but based on the criteria above? i.e. randomly replace 94% missing values in religion for India with 1 (i.e. Hinduism), 2 (Muslim) and so on.
b) For countries where religion is partly missing
How to replace the missing values randomly based on the existing distribution of religion data for that country. So if a particular country has 50% Hindus and 50% Christians, then 50% of the religion's missing values are replaced by Hindus and son on.
Any help on this will be appreciated.
Danish
P.S. I understand that I'll have to calculate religion shares for each country and each year separately. For now, however, let's assume the religion shares remain constant across all years.
Related Posts with Replace missing values with observations randomly generated based on a prespecified criteria
Instrumental variable regressionI have an unbalanced panel dataset (N=504, T=3) and I am trying to run instrumental variable regress…
Keeping a variable value over years that was only answered onceHi there, I'm investing the role of house prices on happiness and am using a FE model. The data has…
reporting marginal effect of all outcomes at once after mprobitIf I run the following code then it generates marginal effect for 2nd outcome. Code: webuse sysds…
Creating bilateral indicators for a pair of countries in a Panel dataHi all, I am looking to create the following ratio t_ij= Xii*Xjj / Xij*Xji in STATA, where Xij is t…
Help creating different sequences for multiple events - same individual - longitudinal datasetDear all, I have a dataset in a long format with the same individual having multiple start dates for…
Subscribe to:
Post Comments (Atom)
0 Response to Replace missing values with observations randomly generated based on a prespecified criteria
Post a Comment