hi
I have a long data. i would like that each categorie of one variable "class" became a collumn, without change the shape of my dataset. and drop the two additional rows of each date by state.

+----------------------------------------+
| year month state class count |
|----------------------------------------|
1. | 2010 1 11 CZS 4 |
2. | 2010 1 11 Non CZS 8 |
3. | 2010 1 11 Normal 2047 |
4. | 2010 1 12 Non CZS 4 |
5. | 2010 1 12 Normal 1299 |
|----------------------------------------|
6. | 2010 1 13 CZS 7 |
7. | 2010 1 13 Non CZS 35 |
8. | 2010 1 13 Normal 6411 |
9. | 2010 1 14 CZS 1 |
10. | 2010 1 14 Non CZS 5 |
+----------------------------------------+