creating a dummy with conditions in panel data

[Zariab Hossain]

Dear Stata users

I am working with a panel dataset and an excerpt of the dataset is below:

----------------------- copy starting from the next line -----------------------


	
	
* Example generated by -dataex-. For more info, type help dataex
clear
input str15 kom_name int year byte office_WS int l_close
"Älvkarleby" 2010 0 2017
"Älvkarleby" 2011 1 2017
"Älvkarleby" 2012 0 2017
"Älvkarleby" 2013 0 2017
"Älvkarleby" 2014 0 2017
"Älvkarleby" 2015 1 2017
"Älvkarleby" 2016 1 2017
"Älvkarleby" 2017 1 2017
"Älvkarleby" 2018 0 2017
"Älvkarleby" 2019 0 2017
"Älvkarleby" 2020 0 2017
"Älvkarleby" 2021 0 2017
"Älvkarleby" 2022 . 2017
"Älvkarleby" 2023 . 2017
"Knivsta"     2010 0 2015
"Knivsta"     2011 1 2015
"Knivsta"     2012 1 2015
"Knivsta"     2013 0 2015
"Knivsta"     2014 0 2015
"Knivsta"     2015 0 2015
"Knivsta"     2016 0 2015
"Knivsta"     2017 0 2015
"Knivsta"     2018 0 2015
"Knivsta"     2019 0 2015
"Knivsta"     2020 0 2015
"Knivsta"     2021 0 2015
"Knivsta"     2022 . 2015
"Knivsta"     2023 . 2015
end

I want to create a dummy variable called "dummy" that will take the value 1 for each kom_name that has office_WS>0 in l_close-1 year. For example, for Knivsta, the dummy will take 0 since l_close==2015 and office_WS was 0 in 2014. However, it will take the value 1 for Älvkarleby since in 2016 (which is l_close-1) office_WS>0.

Any help would be highly appreciated.

Thanks,

Zariab Hossain
Uppsala University

[Clyde Schechter]

by kom_name (year), sort: egen wanted = ///
    max(office_WS > 0 & !missing(office_WS) & year == l_close-1)