I am about to test the Hotfix install of 41EG02 for Enterprise Guide 4. Assuming all goes well, I will recommending it be included in our colleges PC ghost. Has anyone had any problems with this Hotfix or the previous one 41EG01?
I'm running EG under Win XP, with SAS 9.1.3.
I use EG to work on a SAS BI installation on
Win 2003 Enterprise HP servers.
- Matthew Seeman
Broward Community College
This hotfix is considered to be an ALERT hotfix as it has fixed a lot of issues.
Having said that, just be careful if you have INNER JOIN and WHERE clause with OR operator in a query. After you applied the hotfix, the generated SQL will have missing parentheses in the OR operator and make the result unexpected. This is because of the change to SN-019152. The current work-around is to separate the Join and WHERE queries by creating multiple queries. See SN-019473 (currently pending, should be releasing soon).
One more question about Inner join in Proc SQL.
We do have the Hotfix install 41EG06 but we still have problems with this kind of join.
For example one query with the inner join has a 3hours response time and the same result with a left join has a 7 minutes response time ...
Have you ever had this problem, I mean an inner join longer that an outer join ?