Problem Note 19018: Filter might cause error when attempting to change input table in the
Query Builder
You might receive an error when you attempt to change the input table in
the Query Builder of SAS Enterprise Guide. In the Query Builder, if you
select the Join button to open the Join window, right-click on the
table, select properties and attempt to change the input table, you
might receive the following error:
The table c:\cfar_subvar.sas7bdat that you are attempting to switch is not valid for use with the current settings of this query.
This error can result even if the file you are changing to is an
identical copy of the original input data.
The workaround is to remove the filter prior to changing the table name.
You can cut the current filter into a Notepad window or text file,
modify your input table, and then reapply the filter by copying and
pasting the filter back into the query.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 9.2 TS2M0 |
| Microsoft Windows NT Workstation | 4.1 | | 9.1 TS1M3 SP1 | |
| Microsoft Windows 2000 Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2007-02-15 14:43:30 |
| Date Created: | 2006-11-20 15:58:37 |
