topic macro error in SAS Programming

macro error

Renee1984 — Tue, 22 Jun 2021 16:14:56 GMT

Hello All, I've created the macro below, however when I run the very first SQL statement of my code I keep getting errors??

Macro below:

%MACRO NEEDDT(PLM12019,BEGDATE,ENDDATE);
%LET BEGDATE = MDY(12,31,2019);
%LET ENDDATE = MDY(01,31,2020);
%LET CYABSTR =PLM12020; /*use if pulling from a ASQ abstract*/
%LET PRABSTR =PLM12019;
%MEND NEEDDT;

My first SQL statement below:

PROC SQL; create table r.originalPLMPOP as select
PLDOCNUM AS CIDORNUM LABEL='CIDORNUM'
FROM &PRABSTR
WHERE EVNTTYPE='07'; /*Prison Population*/
QUIT;

Errors below:

PROC SQL;
10 ! create table r.originalPLMPOP as select
11 PLDOCNUM AS CIDORNUM LABEL='CIDORNUM'
12 FROM &PRABSTR
WARNING: Apparent symbolic reference PRABSTR not resolved.
12 FROM &PRABSTR
-
22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (,
CONNECTION, DICTIONARY.

12 FROM &PRABSTR
-
200
ERROR 200-322: The symbol is not recognized and will be ignored.

13 WHERE EVNTTYPE='07';
13 ! /*Prison Population*/
14 QUIT;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds

Re: macro error

PaigeMiller — Tue, 22 Jun 2021 16:29:43 GMT

&PRABSTR has not been defined in the current scope where SQL is running. You probably need to learn about macro scopes.

When you define &PRABSTR inside the macro named %NEEDDT, then &PRABSTR does not exist outside of that macro. There are two way to get around this. The easiest is to not define &PRABSTR inside %NEEDDT, define &PRAVSTR outside of a macro, and then it is consider Global and can be accessed anywhere in your program.

By the way, your macro %NEEDDT as shown, doesn't seem to be needed, as all of the commands in that macro can be (and should be) issued outside of a macro.

Re: macro error

Renee1984 — Tue, 22 Jun 2021 18:59:56 GMT

Thank you very much, this worked perfectly...making it global!! Problem Solved

Re: macro error

Tom — Tue, 22 Jun 2021 20:11:55 GMT

You don't show any code that is using that macro. If you want to use the value it is assigning to PRABSTR after it ends make sure that PRABSTR exists before you call the macro.

%let PRABSTR=;
%let BEGDATE=;
%let ENDDATE=;
%NEEDDT;