CAN I PUT THIS TWO IN ONE?

wfiona020 — Sun, 06 Nov 2022 22:56:50 GMT

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;

Re: CAN I PUT THIS TWO IN ONE?

Tom — Sun, 06 Nov 2022 23:40:07 GMT

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;

topic CAN I PUT THIS TWO IN ONE? in New SAS User

CAN I PUT THIS TWO IN ONE?

Re: CAN I PUT THIS TWO IN ONE?