请问如何统计家庭个数,在前面加出一列代表家庭序号。fid16代表家庭编码,pid代表个人编码,相同fid16的个人即为一家,想通过个人统计一共有多少家庭样本。比如,下图一共有十三户家庭,应顺次标出1,2,……13。谢谢!
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input str7 fid16 long pid
- "[backcolor=darkorange]100051" 100051501[/backcolor]
- [backcolor=darkorange]"100051" 100051502[/backcolor]
- [backcolor=olive]"100453" 430111102[/backcolor]
- [backcolor=olive]"100453" 430111101[/backcolor]
- [backcolor=olive]"100453" 430111103[/backcolor]
- [backcolor=yellowgreen]"100551" 130281103[/backcolor]
- [backcolor=seagreen]"101023" 130815105[/backcolor]
- [backcolor=lime]"102438" 210206103[/backcolor]
- [backcolor=royalblue]"102473" 210263102[/backcolor]
- "[backcolor=darkorchid]102888" 210966105[/backcolor]
- [backcolor=darkorchid]"102888" 210966102[/backcolor]
- "[backcolor=purple]103465" 103465551[/backcolor]
- [backcolor=purple]"103465" 211584103[/backcolor]
- "[backcolor=slategray]103476" 211600103[/backcolor]
- "[backcolor=mediumturquoise]103788" 211952103[/backcolor]
- "[backcolor=deepskyblue]103924" 103924503[/backcolor]
- [backcolor=deepskyblue]"103924" 220098103[/backcolor]
- [backcolor=blue]"105492" 310912103[/backcolor]
- [backcolor=royalblue]"106335" 312144106[/backcolor]
- [backcolor=royalblue]"106335" 312144431[/backcolor]
- end
复制代码