you're right @Astounding  ¡¡¡, newbie "silly" mistake 🙄 ... View more

I'm studying %do while/until loops, I need to use loops (your solution is valid but it not use loops)   ... View more

ok about the image @PaigeMiller   using your solution, same error continues: 77 %macro storms(list); 78 %local i; 79 %let i=1; 80 %do until(%scan(&list,&i) eq ); ERROR: An unexpected semicolon occurred in the %DO statement. ERROR: A dummy macro will be compiled. 81 %let n=%scan(&list,&i); 82 title "&n Storms"; 83 proc means data=mc1.storm_final n min mean max maxdec=0; 84 class season; 85 var MaxWindMPH MinPressure; 86 where season=&n; 87 run; 88 %let i=%sysevalf(&i + 1); 89 %end; 90 %mend storms; 91 92 %storms(2011 2014) _ 180 WARNING: Apparent invocation of macro STORMS not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. message error is about %do until loop, no about proc means. ... View more

ok. you're right @ballardw, I wanted to say: %if &clase1=A %then .......... ... View more

Thanks @yabwon , if there's only one sentence why I need to close %if🤔? if I use more than one sentence, can I use double semicolon ?? ..................; .................; %if "&clase1"="SEXO_1F" %then format &clase1 SEXO.;; run; %mend; ... View more

Sorry for my delay @ballardw, you're right 👍 ( IF don't exist in SQL, I used it in MySQL) @Tom& @Patrick yours codes are perfect for me 👍, I don't want receive WARNINGs if table doesn't exist ... View more

That code is from another post in this foro, it use "IF" in his/her code @ballardw       ... View more

Thanks for you reply @PaigeMiller 👍, you are right, macro-variable is  LOCAL to the macro What do you mean  " to make sure it doesn't define NOW as logic" @Tom ?? what is "logic"?? 🤔   ... View more