Right, but this is just a simplified code I wrote quickly. No repercussions here. This is the actual code if you need it (but it'll confuse the question) (I'am trying to change %missvars with %dropmiss right now but it's the same issue : it produces weird logs with no errors (cf. attached log) ) : data NRC_GERMVARIABLE(where=(Germ ne ""));   length Source Germ Variable $30;   run; %macro germvars(subject);   %put 0--- subject=&subject;   %put 1--- select germ ;   data WORK.NRC_VARIABLES1;   set ID_DATA.NRC_CLEAN;   where Subject="&subject";   run;   %put 2--- remove empty variables ; /* %missvars(NRC_VARIABLES1);   %put &_miss_;   data NRC_VARIABLES2;   set NRC_VARIABLES1(drop=&_miss_);   run;*/   %dropmiss(NRC_VARIABLES1,NRC_VARIABLES2);   %put 3--- list variables vertically ;   proc transpose   data= WORK.NRC_VARIABLES2 (obs=1)   out= WORK.NRC_VARIABLES3(rename=(_NAME_=Variable) drop=_LABEL_);   var _all_;   run;   %put 4--- append them in NRC_GERMVARIABLE ;   data  WORK.NRC_VARIABLES4 (drop=col1);   length col1 $20;   set  WORK.NRC_VARIABLES3;   col1=col1;   Source="NRC";   Germ="&subject";   run;   PROC APPEND BASE=NRC_GERMVARIABLE DATA= WORK.NRC_VARIABLES4 FORCE NOWARN; /* */ %mend germvars; data _null_;   set NRC_germ;   call execute('%germvars('||trim(Germ)||')');   run; (this forum still needs sas syntaxing) from the log it looks like de the order of execution is not right. ... View more

Big thanks to PGstats ! found it with proc sql : proc sql;   create table test   (germs char(100));   quit;   proc sql;   insert into test   (germs)   values("('BORPER','BRR_SP','CHL_PN')");   quit;   data _null_(keep=germs latinGerm);   attrib latinGerm length=$100;   set test;   do i = 1 by 1;   word = scan(germs,i,"'() ,'");   if missing(word) then leave;   latinGerm = catx(" & ",latinGerm,cats("",put(word,&formatGerm.),""));   end;   /*latinGerm = cats('(',latinGerm,')');*/   call symputx ('displayGerms',latinGerm);   run;   %put &displayGerms; ... View more

Works great outside a macro, but how would you run this inside a macro (which does not accept datalines statements) ? ... View more

Final thing : %macro conditionalstpbegin() / store DES='Conditionally executes %stpbegin';   %put &_CLIENTAPP;   %if &_CLIENTAPP = 'SAS Enterprise Guide' %then %do;   %put Not Stored Process °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°;   %end;   %else %do;   /* SAS Enterprise Guide; CLR 2.0.50727.3620; Microsoft Windows NT 5.1.2600 Service Pack 3   OR   StoredProcessService 9.2; JVM 1.6.0_16; Windows Server 2008 (amd64) 6.1 */   %put Stored Process °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°;   %STPBEGIN   %end; %mend conditionalstpbegin; %conditionalstpbegin; ... View more