Hey,
I've been working with a code from a colleague (who's on vacation for the coming weeks), but at some point a normal query builder fails.
after some troubleshooting I've come to the conclusion that the cause is the option 'Keep results entirely in database when possible option', which is checked in the query builder's options (options --> pass-through). However, both 'checkable' options are locked for me to change. This causes the code to automatically add an 'Execute (' and a 'by con1;' statement in the code. Upon checking, this is not what my colleague did in his last submitted code.
Is there a way to uncheck this box?
Best regards,
BaVe.
I'm pretty sure you are encountering a bug that was fixed in EG 7.12, where the EXECUTE statement was incorrectly added to the generated code. (So, I assume you are using a EG 7.11 or 7.1.) If you upgrade to EG 7.12 or later, the issue should be resolved.
Casey
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
I'm pretty sure you are encountering a bug that was fixed in EG 7.12, where the EXECUTE statement was incorrectly added to the generated code. (So, I assume you are using a EG 7.11 or 7.1.) If you upgrade to EG 7.12 or later, the issue should be resolved.
Casey
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
Hi Casey,
Thanks for your reply. I do work in 7.11, but my employer has yet to become eager to upgrade to 7.12. Maybe this additional fix will persuade him.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.