topic Re: Error in a DO loop in SAS Programming

Error in a DO loop

newtriks — Fri, 16 Feb 2024 18:02:57 GMT

I wrote the code below to consolidate mutually-exclusive variables into 2 "catch-all" variables, but the only line that's copying correctly is the one outside of the DO loop. What am I missing? I appreciate any and all help - thanks.

IF Q_4_1_1 NE . THEN DO;
ChatGPT41 = Q_4_1_1; ChatGPT42 = Q_4_1_2; ChatGPT43 = Q_4_1_3; ChatGPT5 = Q_5_1; ChatGPT6 = Q_6_1; ChatGPT7 = Q_7_1;
END;
IF Q_4_2_1 NE . THEN DO;

ChatGPT41 = Q_4_2_1; ChatGPT42 = Q_4_2_2; ChatGPT43 = Q_4_2_3; ChatGPT5 = Q_5_2; ChatGPT6 = Q_6_2; ChatGPT7 = Q_7_2;
END;
IF Q_4_3_1 NE . THEN DO;
ChatGPT41 = Q_4_3_1; ChatGPT42 = Q_4_3_2; ChatGPT43 = Q_4_3_3; ChatGPT5 = Q_5_3; ChatGPT6 = Q_6_3; ChatGPT7 = Q_7_3;
END;
IF Q_4_4_1 NE . THEN DO;
ChatGPT41 = Q_4_4_1; ChatGPT42 = Q_4_4_2; ChatGPT43 = Q_4_4_3; ChatGPT5 = Q_5_4; ChatGPT6 = Q_6_4; ChatGPT7 = Q_7_4;
END;
ELSE ChatGPT41 = Q_4_5_1; ChatGPT42 = Q_4_5_2; ChatGPT43 = Q_4_5_3; ChatGPT5 = Q_5_5; ChatGPT6 = Q_6_5; ChatGPT7 = Q_7_5;

Re: Error in a DO loop

Kurt_Bremser — Fri, 16 Feb 2024 18:21:37 GMT

ELSE is part of the immediately preceding IF.

To build a chain of mutually exclusive branches, you need to use

if /* condition 1 */
then /* branch 1 */;
else if /* condition 2 */
then /* branch 2 */;
else if /* condition 3 */
then /* branch 3 */;
else /* global else branch */;

Re: Error in a DO loop

Kurt_Bremser — Fri, 16 Feb 2024 18:27:05 GMT

And you have no DO loop here, only several DO/END blocks. "Loop" is used for repeating DO uses, like

do x = 1 to 5,
end;

(iterative)

or DO WHILE (condition)

or DO UNTIL (condition)

Re: Error in a DO loop

ballardw — Fri, 16 Feb 2024 18:31:45 GMT

As a minimum on suspects that your ELSE is improperly structured.

First, restructure the code for a certain amount of legibility:

IF Q_4_1_1 NE . THEN DO;
   ChatGPT41 = Q_4_1_1; 
   ChatGPT42 = Q_4_1_2; 
   ChatGPT43 = Q_4_1_3; 
   ChatGPT5 = Q_5_1; 
   ChatGPT6 = Q_6_1; 
   ChatGPT7 = Q_7_1;
END;

IF Q_4_2_1 NE . THEN DO;
   ChatGPT41 = Q_4_2_1; 
   ChatGPT42 = Q_4_2_2; 
   ChatGPT43 = Q_4_2_3; 
   ChatGPT5 = Q_5_2; 
   ChatGPT6 = Q_6_2; 
   ChatGPT7 = Q_7_2;
END;
IF Q_4_3_1 NE . THEN DO;
   ChatGPT41 = Q_4_3_1; 
   ChatGPT42 = Q_4_3_2; 
   ChatGPT43 = Q_4_3_3; 
   ChatGPT5 = Q_5_3; 
   ChatGPT6 = Q_6_3; 
   ChatGPT7 = Q_7_3;
END;
IF Q_4_4_1 NE . THEN DO;
   ChatGPT41 = Q_4_4_1; 
   ChatGPT42 = Q_4_4_2; 
   ChatGPT43 = Q_4_4_3; 
   ChatGPT5 = Q_5_4; 
   ChatGPT6 = Q_6_4; 
   ChatGPT7 = Q_7_4;
END;
ELSE ChatGPT41 = Q_4_5_1; 
ChatGPT42 = Q_4_5_2; 
ChatGPT43 = Q_4_5_3; 
ChatGPT5 = Q_5_5; 
ChatGPT6 = Q_6_5; 
ChatGPT7 = Q_7_5;

This shows that the ELSE only applies to one variable ChatGPT41. The other following variable assignments are not conditional in any way. So any values set previously in the do loops would be unconditionally set.

I suspect you may have meant for the Else to look more like this:

IF Q_4_1_1 NE . THEN DO;
   ChatGPT41 = Q_4_1_1; 
   ChatGPT42 = Q_4_1_2; 
   ChatGPT43 = Q_4_1_3; 
   ChatGPT5 = Q_5_1; 
   ChatGPT6 = Q_6_1; 
   ChatGPT7 = Q_7_1;
END;

IF Q_4_2_1 NE . THEN DO;
   ChatGPT41 = Q_4_2_1; 
   ChatGPT42 = Q_4_2_2; 
   ChatGPT43 = Q_4_2_3; 
   ChatGPT5 = Q_5_2; 
   ChatGPT6 = Q_6_2; 
   ChatGPT7 = Q_7_2;
END;
IF Q_4_3_1 NE . THEN DO;
   ChatGPT41 = Q_4_3_1; 
   ChatGPT42 = Q_4_3_2; 
   ChatGPT43 = Q_4_3_3; 
   ChatGPT5 = Q_5_3; 
   ChatGPT6 = Q_6_3; 
   ChatGPT7 = Q_7_3;
END;
IF Q_4_4_1 NE . THEN DO;
   ChatGPT41 = Q_4_4_1; 
   ChatGPT42 = Q_4_4_2; 
   ChatGPT43 = Q_4_4_3; 
   ChatGPT5 = Q_5_4; 
   ChatGPT6 = Q_6_4; 
   ChatGPT7 = Q_7_4;
END;
ELSE do;
   ChatGPT41 = Q_4_5_1; 
   ChatGPT42 = Q_4_5_2; 
   ChatGPT43 = Q_4_5_3; 
   ChatGPT5 = Q_5_5; 
   ChatGPT6 = Q_6_5; 
   ChatGPT7 = Q_7_5;
end;

HOWEVER that else ONLY applies when the IF Q_4_4_1 is missing ( So values that should have been assigned in the other IF then do are replaced. For example if all of Q_4_1_1, Q_4_2_1, Q_4_3_1, Q_4_4_1 are not missing which assignment should take priority? You do have 4 Do loops.

You have something like 30+ variables with no provided values or expected results. You should fix that, as in provide values for the variables and the expected results.

Personally seeing ChatGPT in those variables makes be cringe that some other terrible almost working code is being modified blindly without a clear knowledge of what the code is supposed to actually do.

Re: Error in a DO loop

newtriks — Fri, 16 Feb 2024 19:59:14 GMT

That did the trick. Thanks so much for your help!

Re: Error in a DO loop

newtriks — Fri, 16 Feb 2024 19:59:38 GMT

Thanks for your help!

Re: Error in a DO loop

Patrick — Sat, 17 Feb 2024 03:20:12 GMT

@newtriks Can you please mark the answer that helped you most as the solution so the rest of us know that your question has been resolved. ...and in the future others with a similar problem searching the communities can find the solution quicker.