合并数据 [推广有奖]

11楼

naujkz 发表于 2012-9-27 14:00:07

蓝色发表于 2012-9-27 10:57
加入在excel里面放数据，你想要什么样子的？
你可以用一个家庭的情况列出来

再次感谢！

[em17][em17]

12楼

蓝色 发表于 2012-9-28 00:39:39

naujkz 发表于 2012-9-27 14:00
再次感谢！

**************************************************************************************
clear
import excel "D:\temp\Demo.xls", sheet("Sheet1") firstrow clear
gen str8 sex=cond(Rgender==1,"father","mother")
tab sex Rgender

reshape wide ID Birth Marital Hukou School Education A024 Rgender,i(communityID householdID ) j(sex) str
sort communityID householdID
saveold "D:\temp\Demo.dta",replace

*******************************************************************************************
clear
import excel "D:\temp\Child.xls", sheet("Sheet1") firstrow clear
sort communityID householdID

merge m:1 communityID householdID using "D:\temp\Demo.dta"
saveold "D:\temp\Child.dta",replace
export excel using "D:\temp\Child_Demo.xls", firstrow(variables) replace
******************************************************************************************

Stata常见问题解答https://bbs.pinggu.org/thread-272681-1-1.html