I have the following value
1=1
1=2
1=3
2=1
2=2
2=3
2=4
9=1
9=2
9=3
9=4
9=5
9=6
9=7
9=8
9=9
9=10
1=1
1=2
1=3
2=1
2=2
2=3
2=4
9=1
9=2
9=3
9=4
9=5
9=6
9=7
9=8
9=9
9=10
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte whatever
1
1
1
2
2
2
2
9
9
9
9
9
9
9
9
9
9
end
bysort whatever : gen wanted = _n
list, sepby(whatever)
+-------------------+
| whatever wanted |
|-------------------|
1. | 1 1 |
2. | 1 2 |
3. | 1 3 |
|-------------------|
4. | 2 1 |
5. | 2 2 |
6. | 2 3 |
7. | 2 4 |
|-------------------|
8. | 9 1 |
9. | 9 2 |
10. | 9 3 |
11. | 9 4 |
12. | 9 5 |
13. | 9 6 |
14. | 9 7 |
15. | 9 8 |
16. | 9 9 |
17. | 9 10 |
+-------------------+
Comment