如何转成宽形数据

如何将下列数据转成宽形？宽形见表二
表一   

t	go	country
1995	1	372
1995	1	410
1995	1	417
1995	2	36
1995	2	344
1995	2	410
1995	2	446
1995	2	554
1995	2	702
1995	2	757
1995	3	392
1995	3	711
1995	3	554
1995	4	124
1995	4	392
1995	4	408
1995	4	757

表二

t	1	2	3	4
1995		36
1995				124
1995		344
1995	372
1995			392	392
1995				408
1995	410	410
1995	417
1995		446
1995		554	554	554
1995		702
1995			711
1995		757
1995		764

bys t (country go): g i=_n
reshape wide country,i(t i) j(go)
egen c=rowtotal(country*)
collapse (sum)country*,by(t c)

gen id=_n
reshape wide country, i(id) j(go)

hplcdadong 发表于 2012-4-7 18:12
gen id=_n
reshape wide country, i(id) j(go)

兄弟，不行啊

hplcdadong 发表于 2012-4-7 18:12
gen id=_n
reshape wide country, i(id) j(go)

要配对的

egen id2=tag(country)
egen id3=rank(country) if id2==1
bysort country: gen id1=id3[1]
drop id2 id3
reshape wide country, i(id1) j(go)

Sorry, should be this:

sort country
egen id2=tag(country)
egen id3=rank(country) if id2==1
bysort country: gen id1=id3[1]
drop id2 id3
reshape wide country, i(id1) j(go)

感谢万分

可参考，https://bbs.pinggu.org/thread-2235689-1-1.html