CAN I PUT THIS TWO IN ONE?

[wfiona020]

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;

[Tom]

Yes.

PROC SQL;
CREATE TABLE D AS
SELECT
        A.*
      , B.PRC_DAY_AFTER
      , (A.INITIAL_OFFER-B.PRC_DAY_AFTER)/B.PRC_DAY_AFTER as GAP
FROM D_MERGER AS A
   , D_PRC AS B
WHERE A.DEALNO=B.DEALNO
;
QUIT;