Creating a variable based on year and exposure

[Cansu Oymak]

Dear Statalist Users,


I am trying to generate a variable, named city_treatment. This variable should appear like this;

If variable "rn_" (which stands for number of refugees) is greater than zero in any year (child_birth_year), then I want city_treatment variable to take 1 and 0 otherwise.
For example, if a city has no refugees in year 2016, I want this city to take 0. Afterwards, if this city started to have refugees in year 2017, then i want it to take 1 in 2017.

There are 81 cities, and variable "plate" uniquely defines each city. For example, city Adana has an identifier of 1. City Adiyaman has an identifier of 2 and etc.

Thank you very much!

* Example generated by -dataex-. To install: ssc install dataex
clear
input byte plate int child_birth_year str13 city long rn_ float city_treatment
1 2003 "Adana"         0 0
1 2004 "Adana"         0 0
1 2005 "Adana"         0 0
1 2006 "Adana"         0 0
1 2007 "Adana"         0 0
1 2008 "Adana"         0 0
1 2009 "Adana"         0 0
1 2010 "Adana"         0 0
1 2011 "Adana"         0 0
1 2012 "Adana"         0 0
1 2013 "Adana"     19337 .
1 2014 "Adana"     61226 .
1 2015 "Adana"    136698 .
1 2016 "Adana"    149738 .
1 2017 "Adana"    155645 .
1 2018 "Adana"    192542 .
2 2003 "Adiyaman"      0 0
2 2004 "Adiyaman"      0 0
2 2005 "Adiyaman"      0 0
2 2006 "Adiyaman"      0 0
2 2007 "Adiyaman"      0 0
2 2008 "Adiyaman"      0 0
2 2009 "Adiyaman"      0 0
2 2010 "Adiyaman"      0 0
2 2011 "Adiyaman"      0 0
2 2012 "Adiyaman"      0 0
2 2013 "Adiyaman"  10193 .
2 2014 "Adiyaman"  33354 .
2 2015 "Adiyaman"  22081 .
2 2016 "Adiyaman"  24797 .
2 2017 "Adiyaman"  26344 .
2 2018 "Adiyaman"  29522 .
3 2003 "Afyon"         0 0
3 2004 "Afyon"         0 0
3 2005 "Afyon"         0 0
3 2006 "Afyon"         0 0
3 2007 "Afyon"         0 0
3 2008 "Afyon"         0 0
3 2009 "Afyon"         0 0
3 2010 "Afyon"         0 0
3 2011 "Afyon"         0 0
3 2012 "Afyon"         0 0
3 2013 "Afyon"         0 .
3 2014 "Afyon"       500 .
3 2015 "Afyon"      2841 .
3 2016 "Afyon"      4181 .
3 2017 "Afyon"      4932 .
3 2018 "Afyon"      5943 .
4 2003 "Agri"          0 0
4 2004 "Agri"          0 0
4 2005 "Agri"          0 0
4 2006 "Agri"          0 0
4 2007 "Agri"          0 0
4 2008 "Agri"          0 0
4 2009 "Agri"          0 0
4 2010 "Agri"          0 0
4 2011 "Agri"          0 0
4 2012 "Agri"          0 0
4 2013 "Agri"          0 .
4 2014 "Agri"        100 .
4 2015 "Agri"        796 .
4 2016 "Agri"        857 .
4 2017 "Agri"       1008 .
4 2018 "Agri"       1136 .
5 2003 "Amasya"        0 0
5 2004 "Amasya"        0 0
5 2005 "Amasya"        0 0
5 2006 "Amasya"        0 0
5 2007 "Amasya"        0 0
5 2008 "Amasya"        0 0
5 2009 "Amasya"        0 0
5 2010 "Amasya"        0 0
5 2011 "Amasya"        0 0
5 2012 "Amasya"        0 0
5 2013 "Amasya"        0 .
5 2014 "Amasya"      100 .
5 2015 "Amasya"      144 .
5 2016 "Amasya"      217 .
5 2017 "Amasya"      402 .
5 2018 "Amasya"      570 .
6 2003 "Ankara"        0 0
6 2004 "Ankara"        0 0
6 2005 "Ankara"        0 0
6 2006 "Ankara"        0 0
6 2007 "Ankara"        0 0
6 2008 "Ankara"        0 0
6 2009 "Ankara"        0 0
6 2010 "Ankara"        0 0
6 2011 "Ankara"        0 0
6 2012 "Ankara"        0 0
6 2013 "Ankara"        0 .
6 2014 "Ankara"    30000 .
6 2015 "Ankara"    53972 .
6 2016 "Ankara"    67141 .
6 2017 "Ankara"    80245 .
6 2018 "Ankara"    96169 .
7 2003 "Antalya"       0 0
7 2004 "Antalya"       0 0
7 2005 "Antalya"       0 0
7 2006 "Antalya"       0 0
end

[Ken Chui]

Did you mean this?

generate wanted = (rn_ > 0) if !missing(rn_)

Or did you mean that you want that indicator to stay as "1" even later the city showed that they have no refugees?

[Cansu Oymak]

Did you mean this?



Or did you mean that you want that indicator to stay as "1" even later the city showed that they have no refugees?

this is exactly what I want! Thank you !!