Ok, so we are running a SAS EBI 9.4TS1M3 environment on RHEL 6.7 (Linux x64). EG is 7.100.0.1966 64-bit. I have a user that creates projects with Query Builder tasks. When he creates the tasks they appear and run as normal. Here is an example using data from SASHELP: %_eg_conditional_dropds(WORK.QUERY_FOR_CARS);
PROC SQL;
CREATE TABLE WORK.QUERY_FOR_CARS AS
SELECT t1.Make,
/* Calculation */
(COUNT(DISTINCT(t1.Model))) AS COUNT_DISTINCT_of_Model
FROM SASHELP.CARS t1
GROUP BY t1.Make;
QUIT; He runs it and has no problems. However, if he saves the project and sends it to someone else to run, the same Query Builder task changes the code to this: %_eg_conditional_dropds(WORK.QUERY_FOR_CARS);
PROC SQL;
EXECUTE (
CREATE TABLE WORK.QUERY_FOR_CARS AS SELECT t1.Make,
/* COUNT_DISTINCT_of_Model */
(COUNT(DISTINCT(t1.Model))) AS COUNT_DISTINCT_of_Model
FROM SASHELP.CARS t1
GROUP BY t1.Make;) by con1;
QUIT; Notice how it sandwhiched the original SQL code inside of "EXECUTE( ) by con1;". Of course, this makes it errors out: ERROR: The CON1 engine cannot be found.
ERROR: A Connection to the con1 DBMS is not currently supported, or is not installed at your site. Obviously because I have no idea what con1 is supposed to be and where it's coming from. If we do this in reverse (i.e. I create the project with Query Builder task and then send to him) this issue does not occur. I've tried uninstalling EG, removing the EG settings from ..\appdata\Roaming\SAS\EnterpriseGuide\, but that didn't help. Thoughts?
... View more