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.
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),"'") ....
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),"'") ....
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.