I changed VARIABLE name in %dqcreadin macro. It resolved the issue. Now, it resets the &variables values for each loop.   Thank you for your help and suggestions. ... View more

Thank you for advise. Will follow it. ... View more

%macro dqcreadin(id=); %xls2sas(_infile=dqc.xlsx, _indir=../../../../../metadata, _sheet=Sheet1, _datarow=2, _outdata=dqcout); data dqcout; set dqcout(rename=(var1=id var3=title var6=variables var7=domain var8=issue var10=exception)); if issue='Yes'; if id="&id"; domain=tranwrd(domain,', ','#'); if index(variables,'--')>0 then variables=tranwrd(variables,'--',"&dsn."); variables=tranwrd(variables,', ',' '); dmvars =tranwrd(exception,',',' '); keep id title variables domain issue dmvars ; run; %global id title variables domain dmvars; proc sql; select id, title , variables, domain, dmvars into :id, :title , :variables, :domain, :dmvars from dqcout ; quit; %put &id &title &variables &domain &dmvars; %mend dqcreadin;   Main code:   %macro missblfl; %symdel variables; %dqcreadin(id=0021); %if %symexist(domain) %then %do; %do i= 1 %to %eval(%sysfunc(count(&domain,#))+1); %let dsn=%scan(&domain,&i,#); %if %sysfunc(exist(&sdtm..&dsn)) %then %do; data &dsn; set &sdtm..&dsn (keep=usubjid &variables); record=_n_; run; %end; %end; %end; %mend; %missblfl;   ... View more

Thank you  so much Tom for your suggestion. The approach you mentioned is working in my program.     ... View more

Yes. This is the macro I am calling in another program.   What will be the best approach to create macro variable which holds the "string" e.g. "%varexist(sdtmcro.&dsn,var1) and %varexist(sdtmcro.&dsn,var2)" and it can be recalled in another program in IF statement?   NOTE: VAR1 and VAR2 can be any variables which are defined in some other macro variable &VARIABLES. This is not constant macro variable, it changes with dataset name. ... View more

Thank you Chris.   In my other program, I am calling this %varcond in %if condition as follow:   %if %varcond(&dsn) %then %do; proc sort data=sdtmcro.&dsn out=&dsn; by usubjid ; run; %end;   But, I get following error:   ERROR: Required operator not found in expression: %varcond(&dsn) MLOGIC(VARCOND): %PUT %superq(varcondn)   I expect to run do loop by checking this condition:   %if %varcond %then %do should be equal to  %if %varexist(sdtmcro.&dsn,var1) and %varexist(sdtmcro.&dsn,var2) %then %do     When I recall macro in following way, there is no error. %varcond(LB);   MLOGIC(VARCOND): %PUT %superq(varcond) %varexist(sdtmcro.LB,LBSTRESC) and %varexist(sdtmcro.LB,LBDRVFL)   However, when I write it in %if condition, I still see this error where "%PUT %superq(varcond)" is blank:   %if %varcond(LB) %then %do; proc sort data=sdtmcro.&dsn out=&dsn; by usubjid ; run; %end;   LOG: SYMBOLGEN: Macro variable DSN resolves to LB ERROR: Required operator not found in expression: %varcond(&dsn) MLOGIC(VARCOND): %PUT %superq(varcond); ... View more

You are saying semicolon after "%superq(varcond)" this right?   I did put it still shows same error. ... View more

Thank you Tom. I made respective changes in my program.   When I recall macro in following way, there is no error. %varcond(LB);   MLOGIC(VARCOND): %PUT %superq(varcond) %varexist(sdtmcro.LB,LBSTRESC) and %varexist(sdtmcro.LB,LBDRVFL)   However, when I write it in %if condition, I still see this error where "%PUT %superq(varcond)" is blank:   %if %varcond(LB) %then %do; proc sort data=sdtmcro.&dsn out=&dsn; by usubjid ; run; %end;   LOG: SYMBOLGEN: Macro variable DSN resolves to LB ERROR: Required operator not found in expression: %varcond(&dsn) MLOGIC(VARCOND): %PUT %superq(varcond)     Thank you.   ... View more

Thank you Tom for your response.   I tried first option you provided. Now, I see "%varexist(sdtmcro.&dsn,var1) and %varexist(sdtmcro.&dsn,var2)" in log or in program where I recall it.   I am having one more trouble.   In my other program, I am calling this %varcond in %if condition as follow:   %if %varcond(&dsn) %then %do; proc sort data=sdtmcro.&dsn out=&dsn; by usubjid ; run; %end;   But, I get following error:   ERROR: Required operator not found in expression: %varcond(&dsn) MLOGIC(VARCOND): %PUT %superq(varcondn) WARNING: Apparent symbolic reference VARCONDN not resolved.   I expect to run do loop by checking this condition:   %if %varcond %then %do= %if %varexist(sdtmcro.&dsn,var1) and %varexist(sdtmcro.&dsn,var2) %then %do   Please let me know what would resolve this problem. ... View more

Here is the log file ... View more

There is no error in log.    I am expecting to get &condition resolved to  "%varexist(sdtmcro.&dsn,var1) and %varexist(sdtmcro.&dsn,var2)"   But, it is getting resolved to :  "1 and 1"    Thank you. ... View more