companyid year ethn
1. 34 2007 a
2. 34 2007 b
3. 34 2007 b
4. 34 2007 a
5. 34 2007 c
6. 35 2007 b
7. 35 2007 a
8. 35 2007 a
9. 35 2007 b
10. 36 2007 a
11. 36 2007 b
12. 34 2008 a
13. 34 2008 b
14. 34 2008 b
15. 34 2008 a
16. 34 2008 c
17. 35 2008 b
18. 35 2008 a
19. 35 2008 a
20. 35 2008 b
21. 36 2008 a
22. 36 2008 b
23. end
----------------------------------------------------------------------------------------------------------------------
-> year = 2007
--------------------------------------
| ethn
companyid | a b c Total
----------+---------------------------
34 | 2 2 1 5
35 | 2 2 4
36 | 1 1 2
--------------------------------------
----------------------------------------------------------------------------------------------------------------------
-> year = 2008
--------------------------------------
| ethn
companyid | a b c Total
----------+---------------------------
34 | 2 2 1 5
35 | 2 2 4
36 | 1 1 2
--------------------------------------
.
. *方法2
. table companyid ethn year,c(count nid) col
--------------------------------------------------------------------
| year and ethn
| ---------- 2007 ---------- ---------- 2008 ----------
companyid | a b c Total a b c Total
----------+---------------------------------------------------------
34 | 2 2 1 5 2 2 1 5
35 | 2 2 4 2 2 4
36 | 1 1 2 1 1 2
--------------------------------------------------------------------
.
. *方法3
. collapse (count) nid , by(companyid year ethn)
. list
+------------------------------+
| compan~d year ethn nid |
|------------------------------|
1. | 34 2007 a 2 |
2. | 34 2007 b 2 |
3. | 34 2007 c 1 |
4. | 34 2008 a 2 |
5. | 34 2008 b 2 |
|------------------------------|
6. | 34 2008 c 1 |
7. | 35 2007 a 2 |
8. | 35 2007 b 2 |
9. | 35 2008 a 2 |
10. | 35 2008 b 2 |
|------------------------------|
11. | 36 2007 a 1 |
12. | 36 2007 b 1 |
13. | 36 2008 a 1 |
14. | 36 2008 b 1 |
+------------------------------+
扫码加好友，拉您进群
全部版块
我的主页
收藏
感激不尽！！！
