Beginning with Hot Fix 18 for the SAS Add-In 5.1 for Microsoft Office, a change was made to improve performance when accessing RDBMS data. This change required the use of the data set option OBS=1. However, this data set option is not valid when accessing SQL views. For this reason, you might see the following error when you attempt to access SQL views from the SAS add-in.

To eliminate the error and access the SQL view, do the following:

1. Create a text file named SAS.OfficeAddin.dll.config in the SAS Add-In for Microsoft Office install directory. Usually, this directory is C:\Program Files\SASHome\x86\SASAddinforMicrosoftOffice\5.1.
2. In this text file, enter the following code:

<configuration> 
    <assemblySettings> 
        <add key="VerifyDataSets" value="false" /> 
    </assemblySettings> 
</configuration>

Restart Microsoft Excel. You should now be able to access your SQL view.