Dear all,

I am trying to analyse the effect of Incentives on Electric Vehicle adoption (Panel Data). One Variable should be the number of ChargingPoints per county per month.

For this variable I was only able to get the the opening date of the ChargingPoints per month per county and not the number of ChargingPoints. See dataset below:

HTML Code:
County    ChargingPoints    OpeningDate    type
6    1    5/10/2010    Visitors
5    8    5/10/2010    Public
50    2    4/20/2016    Public
19    3    2/15/2017    Visitors
6    12    12/23/2015    Visitors
6    3    2/15/2016    Public
6    8    5/19/2014    Public
18    1    10/15/2012    By appointment
12    2    4/29/2010    Visitors
12    16    5/10/2010    Visitors
3    4    7/5/2013    Visitors
3    4    4/14/2014    Public
So in order to get the number of ChargingPoints per county per month (and type) I thought I could compound the data.
Example for County 6 the data should then look the following:

HTML Code:
County    ChargingPoints    OpeningDate    type
6    1    5/10/2010    Visitors
6    13    12/23/2015    Visitors
6    11    2/15/2016    Public
6    8    5/19/2014    Public
Is there an easy way to do this in STATA?

Thanks a lot for you help. I would really appreciate it.

Regards,
Alex