Dear All,
I need to draw a graph that shows different NO2 measurements for different local authorities during different periods of time.
I generated Dummy variables for measurements by 2005, by 2010 and by 2018, for example, a local authority with NO2 measurement during a period until 2005 is 1 and otherwise 0.
example of the data set that I have
The line graph needed is to have 5 lines, for bytheendof2005, bytheendof2010, bytheendof2015, bytheendof2017 and never on the X-axis
and on the Y-axis NO2 rates.
Many thanks
Ali
I need to draw a graph that shows different NO2 measurements for different local authorities during different periods of time.
I generated Dummy variables for measurements by 2005, by 2010 and by 2018, for example, a local authority with NO2 measurement during a period until 2005 is 1 and otherwise 0.
Code:
describe Contains data from pollutiondata_withLACs.dta obs: 1,595,015 vars: 7 3 Apr 2018 14:34 size: 68,585,645 --------------------------------------------------------------- storage display value variable name type format label variable label --------------------------------------------------------------- no2 int %10.0g Aberdeen localauthority str36 %36s bytheendof2005 byte %8.0g by the end of 2005 bytheendof2010 byte %8.0g by the end of 2010 bytheendof2015 byte %8.0g by the end of 2015 bytheendof2017 byte %8.0g by the end of 2017 never byte %8.0g Never ---------------------------------------------------------------
Code:
no2 localauthority bytheendof2005 bytheendof2010 bytheendof2015 bytheendof2017 never Aberdeen City 1 0 0 0 0 53 Aberdeen City 1 0 0 0 0 30 Aberdeen City 1 0 0 0 0 10 Aberdeen City 1 0 0 0 0 26 Aberdeen City 1 0 0 0 0
The line graph needed is to have 5 lines, for bytheendof2005, bytheendof2010, bytheendof2015, bytheendof2017 and never on the X-axis
and on the Y-axis NO2 rates.
Many thanks
Ali
Comment