如何将月度数据求和变成年度数据?-----满足当ID,country,TZ三个指标都相同时,则将相对应的value与quantity相加,不满足相加条件的则保持原值不变,最后以包含所有ID的形式呈现在一张表中作为年度汇总???不知道STATA怎样达到,求各位大哥大姐帮帮忙,教教怎么处理,十分感谢!!!
数据库大概形式如下:
01月
| ID | country | TZ | quantity | value |
| 1001 | US | A | * | * |
| 1002 | CHN | B | * | * |
| 1003 | EU | A | * | * |
| 1004 | US | B | * | * |
| 1005 | CHN | A | * | * |
| 1006 | EU | B | * | * |
| 1007 | US | A | * | * |
| 1008 | CHN | B | * | * |
| 1009 | EU | A | * | * |
| 1010 | US | B | * | * |
| 1011 | CHN | A | * | * |
| 1012 | EU | B | * | * |
02月
| ID | country | TZ | quantity | value |
| 1006 | US | A | * | * |
| 1007 | CHN | B | * | * |
| 1008 | EU | A | * | * |
| 1009 | US | B | * | * |
| 1010 | CHN | A | * | * |
| 1011 | EU | B | * | * |
| 1012 | US | A | * | * |
| 1013 | CHN | B | * | * |
| 1014 | EU | A | * | * |
| 1015 | US | B | * | * |
| 1016 | CHN | A | * | * |
| 1017 | EU | B | * | * |
03~12