Hello,
I'd like to calculate rolling cumulative 4 quarters of earnings (for different cusip).
Currently this is the code I use:
%macro mom(datain=);
%do iter=1 %to 3;
proc sort data=&datain; by cusip line; run;
data &datain; set &datain; by cusip;
if &iter<=1 then C2E=C2E+lag(epspiq);
if &iter<=2 then C3E=C3E+lag&iter(epspiq);
if &iter<=3 then C4E=C4E+lag&iter(epspiq);
run;
%end;
%mend;
%mom(datain=com);
It works well for the first cusip, however since the second cusip, it takes the lag of earnings from the previous cusip, which is not correct.
Please kindly advise.
I'm fine to use other procedures and not only macro procedure.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.