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)
