topic Re: Keep results entirely in database when possible option in SAS Enterprise Guide

Keep results entirely in database when possible option

BaVe — Fri, 04 Aug 2017 15:00:34 GMT

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.

Re: Keep results entirely in database when possible option

CaseySmith — Fri, 04 Aug 2017 18:22:38 GMT

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

Re: Keep results entirely in database when possible option

BaVe — Mon, 07 Aug 2017 07:08:36 GMT

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.