I have the following programs:. The nonmacro part works but the macro doesn't work. This is the note from log: Table WORK.ETG_999900 created, with 0 rows and 5 columns. I can't figure out why it gives me nothing. Any suggestions/solutions will be greatly appreciated! libname Store "\\nasnpmmds\EBI1\mmds\AHCPII\OPTUMCheck"; PROC SQL; CREATE TABLE WORK.ETG_999900 AS SELECT t1.ETG_NBR, t1.EPI_TYPE_KEY, t1.EPI_NBR, /* DESC */ ('Orphan Record') AS DESC, /* Short_ETG */ (substr(t1.ETG_NBR, 1, 6)) AS Short_ETG FROM store.lost_claims_91 t1 WHERE (CALCULATED Short_ETG) = '999900' ORDER BY t1.EPI_TYPE_KEY, t1.EPI_NBR; QUIT; %macro ETG(DESC, ETG); PROC SQL; CREATE TABLE WORK.ETG_&ETG AS SELECT t1.ETG_NBR, t1.EPI_TYPE_KEY, t1.EPI_NBR, /* DESC */ ('&DESC') AS DESC, /* Short_ETG */ (substr(t1.ETG_NBR, 1, 6)) AS Short_ETG FROM Store.lost_claims_91 t1 WHERE (CALCULATED Short_ETG) = '&ETG' ORDER BY t1.EPI_TYPE_KEY, t1.EPI_NBR; QUIT; %mend ETG; %ETG(Orphan Record, 999900)
... View more