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
How to run Stata Codes in Mac nvim?Dear all, I want to run Stata codes in nvim. I have set the init.config file below. Code: call plu…
generating compatible ID variablesDear Stata listers, I'm running Stata 17.0. I have several (7) datasets that I would like to merge…
How to overlay distributions using a pie chart using StataMP 17? (plot distributions on the same graph)Dear Statalist, I hope you are well. Please, I need help on how to overlay distributions using a p…
Understanding/Reading Regression Output With Categorical VariablesHello; I have experience with regression, I just haven't done it in a while and am SUPER confused a…
Collapse all values of one string variable to one cell per groupSay I have the following data set: id var1 1 a 1 b 1 c 2 a 2 d 3 a Is there a way to collapse this…
Subscribe to:
Post Comments (Atom)
0 Response to Replace missing values with observations randomly generated based on a prespecified criteria
Post a Comment