topic Re: confuse with %do until loop in New SAS User

confuse with %do until loop

ppinedo — Wed, 05 Jun 2024 10:25:33 GMT

Hi everyone,

I'm getting crazy to find out the error. Can anybody help me??

Thanks

Re: confuse with %do until loop

PaigeMiller — Wed, 05 Jun 2024 11:14:16 GMT

How about this:

proc means data=mc1.storm_final n mean max maxdec=0;
    class season;
    var maxwindmph minpressure;
run;

So, my solution is to not use a %DO loop or any macro language at all.

From now on, please post code as text in the box that appears when you click on the "little running man" icon and please post logs as text in the box that appears when you click on the </> icon. DO NOT POST LOGS AND CODE AS SCREEN CAPTURES.

Re: confuse with %do until loop

ppinedo — Wed, 05 Jun 2024 11:18:39 GMT

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.

Re: confuse with %do until loop

PaigeMiller — Wed, 05 Jun 2024 11:17:35 GMT

You have completely misunderstood. My solution does not use any macro %DO loops, it does not use any macro language at all. It uses PROC MEANS with a CLASS statement, that's all you need.

Re: confuse with %do until loop

ppinedo — Wed, 05 Jun 2024 11:22:46 GMT

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

Re: confuse with %do until loop

Astounding — Wed, 05 Jun 2024 11:22:23 GMT

You have omitted the % sign: %do %until, not %do until

Re: confuse with %do until loop

PaigeMiller — Wed, 05 Jun 2024 11:26:08 GMT

@ppinedo wrote:

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

I would say that the idea of learning macros is good, but you also need to learn when NOT to use macros. I would never want to see someone write a macro to do that same thing as a SAS PROC.

Re: confuse with %do until loop

ppinedo — Wed, 05 Jun 2024 11:29:16 GMT

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