topic Re: Macro in SAS Programming

Macro

JHE — Mon, 21 Aug 2017 17:59:47 GMT

Not sure why this code has the errors, could not find out why :

%macro dellob(lobname,lobdate);

PROC SQL;

delete * from reworko.rework&lobname_sumamry

WHERE MONTH=&lobdate;

QUIT;

%mend dellob;

%dellob(0500,'2017-07');

Error message:

delete * from reworko.rework&lobname_sumamry WHERE MONTH=&lobdate; QUIT;

200

WARNING: Apparent symbolic reference LOBNAME_SUMAMRY not resolved.

ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, AS, WHERE.

ERROR 200-322: The symbol is not recognized and will be ignored.

Re: Macro

Shmuel — Mon, 21 Aug 2017 18:04:49 GMT

Try:

%macro dellob(lobname,lobdate);
PROC SQL;
delete * from reworko.rework&lobname._sumamry
WHERE MONTH=&lobdate;
QUIT;
%mend dellob;
%dellob(0500,'2017-07');

see message in log:

WARNING: Apparent symbolic reference LOBNAME_SUMAMRY not resolved.

Your macro variable is LOBNAME so you need a dot to assing end of macro variable name.

Re: Macro

PaigeMiller — Mon, 21 Aug 2017 18:06:43 GMT

The proper syntax for the PROC SQL DELETE statement is:

DELETE FROM tablename ...

http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=sqlproc&docsetTarget=n0wvt1t0egww81n1nrdqjvc32oyl.htm&locale=en

Re: Macro

JHE — Mon, 21 Aug 2017 18:10:12 GMT

works now... thank you