Dear Reeza or any other senior members, I have been trying to solve this on my own but I am stuck. I have been using SAS Studio UE since 2015 and I have no issue running this proc transpose and rename statement. But since I migrate to SAS on Demand, and running the same code, I received this error. WARNING: The variable _1 in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable _2 in the DROP, KEEP, or RENAME list has never been referenced. My codes; Proc means data=msia.mewretdat mean t probt;
class momr;
var mewret;
run;
/* Calculate Buy-Sell Portfolio Returns */
Proc sort data=msia.mewretdat; by date momr; run;
proc transpose data=msia.mewretdat out=msia.mewretdat1 (rename=(_1=Sell _2=BUY));
by date;
id momr;
var mewret;
data msia.mewretdat2;
set msia.mewretdat1;
BUY_SELL=BuY-Sell;
Run;
Proc means data=msia.mewretdat2 n mean t probt;
var Sell Buy Buy_Sell;
Run; Appreciate the guidance. Best regards, Alpha
... View more
