新浪博客

SAS if then do else

2010-09-18 05:22阅读：

http://blog.sina.cn/dpool/blog/u/1646621462

data peoplesoft;
set test.PeopleSoft(keep=SA_type Date_of_Assignment__Conveyance Date_of_Final_Settlement
Claim_Paid_to_Date Amount_Due_to_HUD
rename=(Date_of_Assignment__Conveyance=Claim_date
Date_of_Final_Settlement=PPC_date));
Claim_Amount=Claim_Paid_to_Date Amount_Due_to_HUD;
PPC_Amount=Claim_Paid_to_Date Amount_Due_to_HUD;
Regular_claim=
'yes';
Partial_Payment_of_Claim='yes';
if SA_type='MC_PPCC' then do; Regular_claim='no'; Claim_Amount=.; end;
else if SA_type='MC_RENC' then do; Regular_claim='no'; Partial_Payment_of_Claim='no';
Claim_Amount=.; PPC_Amount=.; end;
else if SA_type='MC_REND' then do; Regular_claim='no'; Partial_Payment_of_Claim='no';
Claim_Amount=.; PPC_Amount=.; end;
else do; Partial_Payment_of_Claim='no'; PPC_Amount=.; end;
run;

我的更多文章

下载客户端阅读体验更佳

APP专享