As below my code, I have to create a table d, and then run it again to add a new column. My question is: Can I add the "GAP" directly in table d? Thanks PROC SQL; CREATE TABLE D AS SELECT A.*, B.PRC_DAY_AFTER FROM D_MERGER AS A, D_PRC AS B WHERE A.DEALNO=B.DEALNO; RUN; DATA D_GAP; SET D; GAP=(INITIAL_OFFER-PRC_DAY_AFTER)/PRC_DAY_AFTER; RUN;
... View more