我想用stata处理下面数据,
第一列是年度,第五列是商品的sitc编码,第六列是贸易额,
我想得到以下数据:
1各年度所有商品贸易额的加总
2各年度前两位数相同的所有商品的贸易额加总,即1992年71(7119、7132等都属于71)、72等数据,其他年度的71、72数据
以上得到的结果按照年度以列向量的形式给出
谢谢大家!
a | e | f |
1992 | 7119 | 59604 |
1992 | 7132 | 902019 |
1992 | 7139 | 438246 |
1992 | 7169 | 731000 |
1992 | 71899 | 1864 |
1992 | 72119 | 1916 |
1992 | 7239 | 3153460 |
1992 | 72439 | 767648 |
1992 | 72449 | 2176372 |
1992 | 7246 | 7078545 |
1992 | 72488 | 1125233 |
1992 | 7249 | 1360277 |
1992 | 7259 | 101293 |
1992 | 72635 | 5447 |
1992 | 7269 | 38259 |
1992 | 72719 | 9385 |
1992 | 72729 | 108555 |
1992 | 72819 | 283524 |
1992 | 72839 | 350851 |
1992 | 7285 | 1717466 |
1992 | 735 | 2370534 |
1992 | 73719 | 20641 |
1992 | 73729 | 9962 |
1992 | 73739 | 380387 |
1992 | 73749 | 33723 |
1992 | 74128 | 2691 |
1992 | 74139 | 114304 |
1992 | 74149 | 249246 |
1992 | 74159 | 707917 |
1992 | 74172 | 2133 |
1992 | 7419 | 80740 |
1992 | 7429 | 10885 |
1992 | 7438 | 94593 |
1992 | 7439 | 19981 |
1992 | 7449 | 402024 |
1992 | 74519 | 10600 |
1992 | 74529 | 34593 |
1992 | 74539 | 3884 |
1992 | 74568 | 96634 |
1992 | 74593 | 11669 |
1992 | 746 | 125052 |
1992 | 747 | 465442 |
1992 | 7481 | 2459327 |
1992 | 7482 | 888 |
1992 | 7484 | 28860 |
1992 | 7485 | 757 |
1992 | 7489 | 28074 |
1992 | 7492 | 62264 |
1992 | 7499 | 752210 |
1992 | 759 | 10130124 |
1992 | 7621 | 697409 |
1992 | 7649 | 42203512 |
1992 | 77129 | 4543251 |
1992 | 772 | 5973842 |
1992 | 77313 | 413701 |
1992 | 77324 | 4637 |
1992 | 77429 | 45179 |
1992 | 776 | 97333612 |
1992 | 77812 | 74634 |
1992 | 77822 | 177525 |
1992 | 77824 | 3649 |
1992 | 77831 | 5464 |
1992 | 77833 | 8251 |
1992 | 77834 | 71856 |
1992 | 77848 | 117845 |
1992 | 77869 | 491289 |
1992 | 77879 | 84794 |
1992 | 77885 | 174365 |
1992 | 77886 | 24039 |
1992 | 77889 | 357950 |
1992 | 784 | 794707 |
1992 | 78537 | 18820 |
1992 | 78689 | 753965 |
1992 | 79199 | 221173 |
1992 | 7929 | 59201 |
1993 | 7119 | 1311442 |
1993 | 7131 | 3800 |
1993 | 7132 | 1621601 |
1993 | 71333 | 13093 |
1993 | 7139 | 3474125 |
1993 | 714 | 2647 |
1993 | 7169 | 890940 |
1993 | 71819 | 165673 |
1993 | 71899 | 5362 |
1993 | 72119 | 69804 |
1993 | 72129 | 35309 |
1993 | 7239 | 290879 |
1993 | 72439 | 2594955 |
1993 | 72449 | 3802191 |
1993 | 7246 | 8382857 |
1993 | 72488 | 1111603 |
1993 | 7249 | 683077 |
1993 | 7259 | 89990 |
1993 | 72635 | 47820 |
1993 | 72689 | 9091 |
1993 | 7269 | 255338 |
1993 | 72719 | 17156 |
1993 | 72729 | 163906 |
1993 | 72819 | 410573 |
1993 | 72839 | 487947 |
1993 | 7285 | 8154653 |
1993 | 735 | 1442216 |
1993 | 73719 | 151537 |
1993 | 73729 | 198420 |
1993 | 73739 | 51688 |
1993 | 73749 | 70865 |
1993 | 74128 | 56552 |
1993 | 74135 | 53341 |
1993 | 74139 | 174149 |
1993 | 74149 | 130871 |
1993 | 74159 | 2901739 |
1993 | 7419 | 705385 |
1993 | 7429 | 53600 |
1993 | 7438 | 736253 |
1993 | 7439 | 313083 |
1993 | 7449 | 851476 |
1993 | 74519 | 23673 |
1993 | 74529 | 230958 |
1993 | 74539 | 13649 |
1993 | 74568 | 391689 |
1993 | 74593 | 43603 |
1993 | 746 | 430388 |
1993 | 747 | 888531 |
1993 | 7481 | 1122206 |
1993 | 7482 | 2246 |
1993 | 7484 | 378811 |
1993 | 7485 | 12866 |
1993 | 7486 | 3110 |
1993 | 7489 | 82119 |
1993 | 7492 | 225842 |
1993 | 7499 | 680757 |
1993 | 759 | 33739577 |
1993 | 7621 | 2463062 |
1993 | 7649 | 1.1E+08 |
1993 | 77129 | 11072180 |
1993 | 772 | 20272109 |
1993 | 77313 | 944092 |
1993 | 77323 | 1518 |
1993 | 77324 | 10811 |
1993 | 77429 | 110645 |
1993 | 776 | 2.31E+08 |
1993 | 77812 | 675477 |
1993 | 77822 | 966108 |
1993 | 77823 | 926 |
1993 | 77824 | 7770 |
1993 | 77831 | 112517 |
1993 | 77833 | 39858 |
1993 | 77834 | 348129 |
1993 | 77848 | 92516 |
1993 | 77869 | 2550906 |
1993 | 77879 | 558312 |
1993 | 77885 | 1157344 |
1993 | 77886 | 16543 |
1993 | 77889 | 1303613 |
1993 | 784 | 5060921 |
1993 | 78535 | 206790 |
1993 | 78537 | 117552 |
1993 | 78689 | 1671626 |
1993 | 79199 | 53910 |