topic Re: Need to convert Stata codes into SAS in SAS Programming

Need to convert Stata codes into SAS

bd_user_10 — Tue, 01 Sep 2020 16:00:10 GMT

Hi Everyone,

Can someone please help me convert this Stata codes into SAS?

expand 2, gen(trade_leg)
foreach v in broker {
gen `v'= buy_`v' if trade_leg==0
replace `v' = sell_`v' if trade_leg==1
drop buy_`v' sell_`v'
}

Thanks in advance for your help. Cheers!

Re: Need to convert Stata codes into SAS

pink_poodle — Tue, 01 Sep 2020 20:45:08 GMT

data part1; set have; trade_leg=0; run;
data part2; set have; trade_leg=1; run;
data whole; set part1 part2;
if trade_leg=0 then broker = catx("buy_",broker);
else if trade_leg=1 then broker = catx("sell_", broker);
drop buy: sel:; run;