Macro Warning message? DEXTROSE?

ybz12003 — Thu, 14 Jul 2022 14:43:56 GMT

Hello,

I got a warning message from Macro. Please advise how to fix it.

495 proc sql noprint;
496 select quote(trim(Mecication_list)) into : Medicationslist separated by ',' from
496! Medications_CIN;
497 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

WARNING: Apparent invocation of macro DEXTROSE not resolved.
WARNING: Apparent invocation of macro DEXTROSE not resolved.
WARNING: Apparent invocation of macro DEXTROSE not resolved.
WARNING: Apparent invocation of macro DEXTROSE not resolved.
498
499 %put &Medicationslist;
WARNING: Apparent invocation of macro OINT not resolved.

Re: Macro Warning message? DEXTROSE?

Tom — Thu, 14 Jul 2022 14:59:36 GMT

Looks like that character variable has values like %DEXTROSE or %OINT in there.

Use SINGLE quotes to prevent the macro processor from trying resolve those apparent macro calls.

select quote(trim(Mecication_list),"'") ....

topic Macro Warning message? DEXTROSE? in SAS Programming

Macro Warning message? DEXTROSE?

Re: Macro Warning message? DEXTROSE?