BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ybz12003
Rhodochrosite | Level 12

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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),"'") ....

View solution in original post

1 REPLY 1
Tom
Super User Tom
Super User

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),"'") ....

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 458 views
  • 3 likes
  • 2 in conversation