作者fairwind (应天风)
看板Statistics
标题[程式] SAS 家户资料抓太太资讯
时间Wed Apr 2 12:17:43 2014
------------------------------------------------------------------------
[软体程式类别]: SAS
[程式问题]: 资料处理
[软体熟悉度]: 高(1年以上)
[问题叙述]:
现有家户资料 想请问看看是否有好一点的方法抓取太太的资料
Example:
Original data Desired variable
HHID PID MARRIED SPID Income SP_Income
1 1 1 2 10 20
1 2 1 1 20 10
1 3 1 4 30 40
1 4 1 3 40 30
1 5 0 . 50 .
2 1 0 . 11 .
2 2 0 . 12 .
2 3 1 5 13 15
2 4 0 . 14 .
2 5 1 3 15 13
[程式范例]:
我目前的做法虽然可以抓到太太的资料, 但太慢了,
尤其我有 monthly marriage status and income 变数, 整个CODE变得很乱
想请教有没有在一个data setp就完成的做法, 谢谢!
/*** Sample code ***/
/* Seperate married sample */
data married; set household; if married=1; run;
data spouse; set married;
sp_income=income;
SPID=PID; /* Define SP_ID=PID to get the spouse data */
keep HHID SPID sp_income;
run;
proc sort data=spouse; by HHID SPID; run;
proc sort data=household; by HHID SPID; run;
data final;
merge household(in=a) spouse(in=b);
by HHID SPID;
if a;
run;
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 174.102.100.213
※ 文章网址: http://webptt.com/cn.aspx?n=bbs/Statistics/M.1396412267.A.ADB.html
1F：推 tew:proc sql 04/02 15:26