Hi all,

I am working with a panel dataset which contains the following variables:
  • wage bin (defined as bin)
  • region identifier (defined as region)
  • employment count (defined as emplcount)
  • month
The panel covers wage bins from 5 to 1000 across 169 different regions and the observations are monthly from 200401 to 201812. I am sending an example of the data below. My apologies for the format, I will use dataex to display examples in future posts, but I am posting from a PC which does not have Stata on it.

bin region emplcount month
5 101 13 200401
5 101 16 200402
5 101 14 200403
5 102 34 200401
5 102 31 200402
5 102 33 200403
10 101 41 200401
10 101 44 200402
10 101 43 200403
10 102 47 200401
10 102 47 200402
10 102 47 200403
15 101 27 200401
15 101 23 200402
15 101 26 200403
15 102 21 200401
15 102 28 200402
15 102 29 200403


I would like to convert the monthly employment counts into quarterly employment counts for each wage bin in each region, but I am not sure how to do this for a panel with multiple variables.


I will be very grateful for any advice.

Thanks,

Frank