topic Re: How to avoid this WARNING: Apparent invocation of macro MYTABLE not resolved. in SAS Programming

How to avoid this WARNING: Apparent invocation of macro MYTABLE not resolved.

havmaage — Tue, 23 Jun 2020 09:06:52 GMT

I am trying to add '% before and at the end of a macro variable

it does the job but i cannot avoid the warning.

it seems that it has something to do with the % that sas try to resolve in a certain way.

my code

%MACRO squote(value);
	%unquote(%str(%')%qsysfunc(tranwrd(%superq(value),%str(%'),''))%str(%'))
%MEND squote;

%MACRO GET_VIEWS(TABLENAME);

	DATA _NULL_;
		CALL SYMPUTX ('TABLE', &TABLENAME);
 	RUN;

	%PUT table=&TABLE;
	%LET TEST=%squote(%SYSFUNC(CAT(%,&TABLE,%)));
	%PUT TEST=&TEST;

%MEND;

%GET_VIEWS('MYTABLE');

Is there a way to escape % and single quotes and add them dynamically

Re: How to avoid this WARNING: Apparent invocation of macro MYTABLE not resolved.

Kurt_Bremser — Tue, 23 Jun 2020 09:21:20 GMT

You are overcomplicating this. It is quite easy to "mask" this in a data step by building a string from pieces:

%macro get_views(tablename);
data _null_;
call symputx('table',"'%"!!"&tablename."!!"%'",'g');
run;
%put &=table;
%mend;
%get_views(MYTABLE)

Re: How to avoid this WARNING: Apparent invocation of macro MYTABLE not resolved.

havmaage — Tue, 23 Jun 2020 09:25:57 GMT

ohh of course
thank you

Re: How to avoid this WARNING: Apparent invocation of macro MYTABLE not resolved.

yabwon — Tue, 23 Jun 2020 11:59:23 GMT

Hi,

You already have the answer for your question, but I'm just guessing that you want to get something like "dynamic like condition" in where clause? If yes, you could do it also like that:

%let table=CLASS;

proc sql;
  select * from dictionary.tables
  where memname like '%'!!"&table"!!'%'
  ;
quit;

All the best

Bart