topic Re: Hotfix install 41EG02 in SAS Enterprise Guide

Hotfix install 41EG02

deleted_user — Thu, 01 Feb 2007 13:20:54 GMT

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
gseeman@broward.edu

Re: Hotfix install 41EG02

xelat_sas — Fri, 02 Feb 2007 22:26:46 GMT

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).

Re: Hotfix install 41EG02

deleted_user — Mon, 26 Mar 2007 20:16:01 GMT

FYI: This issue has been addressed in Hotfix 41EG03 released in March 07

-Matthew

Re: Hotfix install 41EG02

deleted_user — Fri, 13 Jun 2008 12:33:53 GMT

Hi

May I have the SN-019473 ?

Delphine

Re: Hotfix install 41EG02

deleted_user — Fri, 13 Jun 2008 12:54:04 GMT

Hi
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 3 hours 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 ?

Delphine