SAS Enterprise Guide tasks do not take advantage of in-database processing because a SAS view is created during the processing of the task. Although the view is created for SAS data set optimization, the view is created whether you are accessing a SAS data set or a database table. Therefore, the view prevents the task code from being sent directly to the database.

A circumvention is to execute the code manually from the SAS Enterprise Guide code node instead of using the task.

Select the Hot Fix tab in this note to access the hot fix for this issue.

After applying the hot fix (A53005), you must modify the SEGuide.exe.config file as described next. The default location for this file is C:\program files\SAS\EnterpriseGuide\4.2.

In the SEGuide.exe.config file, add the following key:

Here is a sample of a complete file:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="microsoft.web.services3" type="Microsoft.Web.Services3.Configuration.WebServicesConfiguration,
Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35" />
  </configSections>
  <microsoft.web.services3>
    <policy fileName="wse3policyCache.config" />
  </microsoft.web.services3>
  <appSettings>
     <add key="SupportInDbSyntax" value="true" />
  </appSettings>
</configuration>

Operating System and Release Information

A fix for this issue for SAS Enterprise Guide 4.22 is available at:

A fix for this issue for SAS Add-in for Microsoft Office 4.22 is available at: