Dear Stata users,
I have a panel data set consisting of municipalities in my country from 2000-2020, I have three variables which tells what percentage of land is currently used for. So Built_area is one variable, Agricultural_area is the second variable and third variable is NaturalForest_area. So what I want to do is I create 3 variables indicating low_dev,high_dev and med_dev and then each municipality will be in one of these categories. The problem I am facing is that some of my municipalites are not captured in one of these categories. I am not sure but I might think the range is not set properly, hopefully someone could address me the issue and what the solution to this problem is.
These are my commands:
gen med_dev=1 if (Built_area<=32.71& Built_area>10.13 & Agri_area>33.03 & Agri_area<56.32 & NaturalForest_area<15.18) & !missing(Built_area,Agri_area,NaturalForest_area)
gen high_dev=1 if (Built_area>32.71 & Agri_area<=33.03 & NaturalForest_area<11.11) & !missing(Built_area, Agri_area, NaturalForest_area)
gen low_dev=1 if (Built_area<10.13 & Agri_area>=56.32 & NaturalForest_area>=15.18) & !missing(Built_area,Agri_area,NaturalForest_area)
I thank everyone for taking the time to read and hopefully helps me with the solution.
Br,
Adam
Related Posts with dummy variable conditional not working for all panel IDs
Fixed effect correlation matrixDear all, What is the command in stata to excecute a fixed effects correlation matrix of the variab…
Please help insert a column of year having max (ratio)Hello, I need your help. I have a panel data having corporate code, year and ratios. I would like t…
Help with table and export to word fileHi, I'm having some trouble to make a basic table. I don't want any summary statistics, just make a…
Problem with gaps in data in Stata- problem with commands like dfuller. Please help!Hello, I have a big problem with my data. When I am writing a command in Stata (for example dfuller)…
standardized difference (SD) Burgstahler & DichevDear all, I want to compute the standardized difference statistic using histograms for panel data s…
Subscribe to:
Post Comments (Atom)
0 Response to dummy variable conditional not working for all panel IDs
Post a Comment