Dear all,
I have city-level data on expected future climate hazard frequency (future_haz_freq_codes), which is coded as follows: 0 indicates a decrease, 1 uncertainty, and 2 an increase. I want to aggregate this data to generate a country-specific perception of future climate hazard frequency. Kindly see my data below:
I use the command "egen country_future_haz_freq_codes = mean(future_haz_freq_codes), by(country)" to aggregate the future risk perceptions at the city level. Is this a proper aggregation mechanism? I have a country-level Co2 emissions (emis) which is not provided here, and I want to see the effect of country_future_haz_freq_codes on emis. How should I interpret the coefficient? Your suggestions are crucial in this regard. Thank you!
I have city-level data on expected future climate hazard frequency (future_haz_freq_codes), which is coded as follows: 0 indicates a decrease, 1 uncertainty, and 2 an increase. I want to aggregate this data to generate a country-specific perception of future climate hazard frequency. Kindly see my data below:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float year str87 city_name str52 country float future_haz_freq_codes 2021 "Aarhus Kommune" "Denmark" 2 2021 "Aarhus Kommune" "Denmark" 2 2021 "Aarhus Kommune" "Denmark" 2 2023 "Aarhus Municipality" "Denmark" 2 2022 "Aarhus Municipality" "Denmark" 2 2023 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2021 "Abasan Al-Kabira Municipality" "State of Palestine" 0 2019 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2021 "Abasan Al-Kabira Municipality" "State of Palestine" 0 2021 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2023 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2022 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2022 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2022 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2023 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2022 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2021 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2021 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2019 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2020 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2022 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2019 "Abasan Al-Kabira Municipality" "State of Palestine" 0 2019 "Abasan Al-Kabira Municipality" "State of Palestine" 0 2020 "Abasan Al-Kabira Municipality" "State of Palestine" 0 2020 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2021 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2019 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2020 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2023 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2019 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2020 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2023 "Abasan Al-Kabira Municipality" "State of Palestine" 2 2020 "Abasan Al-Kabira Municipality" "State of Palestine" 0 2022 "Abejorral" "Colombia" . 2023 "Aberdeenshire Council" "United Kingdom of Great Britain and Northern Ireland" 2 2023 "Aberdeenshire Council" "United Kingdom of Great Britain and Northern Ireland" 2 2023 "Aberdeenshire Council" "United Kingdom of Great Britain and Northern Ireland" 2 2023 "Aberdeenshire Council" "United Kingdom of Great Britain and Northern Ireland" 2 2023 "Aberdeenshire Council" "United Kingdom of Great Britain and Northern Ireland" 2 2023 "Aberdeenshire Council" "United Kingdom of Great Britain and Northern Ireland" 2 2023 "Aberdeenshire Council" "United Kingdom of Great Britain and Northern Ireland" 2 2023 "Aberdeenshire Council" "United Kingdom of Great Britain and Northern Ireland" 2 2020 "Abington Township" "United States of America" 1 2020 "Abington Township" "United States of America" 1 2020 "Abington Township" "United States of America" 2 2020 "Abington Township" "United States of America" 1 2019 "Abington Township" "United States of America" . 2020 "Abington Township" "United States of America" 2 2020 "Abington Township" "United States of America" 2 2019 "Abington Township" "United States of America" . 2022 "Abington Township, PA" "United States of America" 2 2021 "Abington Township, PA" "United States of America" 1 2023 "Abington Township, PA" "United States of America" 2 2022 "Abington Township, PA" "United States of America" 2 2023 "Abington Township, PA" "United States of America" 2 2019 "Abington Township, PA" "United States of America" 2 2023 "Abington Township, PA" "United States of America" 2 2021 "Abington Township, PA" "United States of America" 2 2021 "Abington Township, PA" "United States of America" 2 2019 "Abington Township, PA" "United States of America" 2 2023 "Abington Township, PA" "United States of America" 2 2021 "Abington Township, PA" "United States of America" 1 2019 "Abington Township, PA" "United States of America" 1 2021 "Abington Township, PA" "United States of America" 1 2022 "Abington Township, PA" "United States of America" 2 2019 "Abington Township, PA" "United States of America" 1 2022 "Abington Township, PA" "United States of America" 2 2021 "Abington Township, PA" "United States of America" 2 2019 "Abington Township, PA" "United States of America" 2 2022 "Abington Township, PA" "United States of America" 1 2019 "Abuja Federal Capital Territory" "Nigeria" 2 2020 "Abuja Federal Capital Territory" "Nigeria" 2 2023 "Abuja Federal Capital Territory" "Nigeria" . 2021 "Abuja Federal Capital Territory" "Nigeria" 2 2022 "Abuja Federal Capital Territory" "Nigeria" . 2020 "Accra Metropolitan Assembly" "Ghana" 2 2023 "Accra Metropolitan Assembly" "Ghana" . 2022 "Accra Metropolitan Assembly" "Ghana" . 2021 "Accra Metropolitan Assembly" "Ghana" 2 2022 "Accra Metropolitan Assembly" "Ghana" . 2023 "Accra Metropolitan Assembly" "Ghana" . 2020 "Accra Metropolitan Assembly" "Ghana" 2 2019 "Accra Metropolitan Assembly" "Ghana" 2 2019 "Accra Metropolitan Assembly" "Ghana" 2 2021 "Accra Metropolitan Assembly" "Ghana" 2 2021 "Adana Metropolitan Municipality" "Turkey" 0 2020 "Adana Metropolitan Municipality" "Turkey" 0 2019 "Addis Ababa City Administration" "Ethiopia" 2 2021 "Addis Ababa City Administration" "Ethiopia" 2 2020 "Addis Ababa City Administration" "Ethiopia" 2 2021 "Addis Ababa City Administration" "Ethiopia" 2 2023 "Addis Ababa City Administration" "Ethiopia" 2 2022 "Addis Ababa City Administration" "Ethiopia" 2 2023 "Addis Ababa City Administration" "Ethiopia" 2 2020 "Addis Ababa City Administration" "Ethiopia" 2 2020 "Addis Ababa City Administration" "Ethiopia" 2 2019 "Addis Ababa City Administration" "Ethiopia" 2 2021 "Addis Ababa City Administration" "Ethiopia" 2 2023 "Addis Ababa City Administration" "Ethiopia" 2 2019 "Addis Ababa City Administration" "Ethiopia" . end label values future_haz_freq_codes future_haz_freq_codes label def future_haz_freq_codes 0 "Decreasing", modify label def future_haz_freq_codes 1 "Uncertainty", modify label def future_haz_freq_codes 2 "Increasing", modify
I use the command "egen country_future_haz_freq_codes = mean(future_haz_freq_codes), by(country)" to aggregate the future risk perceptions at the city level. Is this a proper aggregation mechanism? I have a country-level Co2 emissions (emis) which is not provided here, and I want to see the effect of country_future_haz_freq_codes on emis. How should I interpret the coefficient? Your suggestions are crucial in this regard. Thank you!
Comment