Syntax errors occur when you attempt to filter a data set in SAS Universal Viewer 1.0. If you use the FilterEditor ► Standard tab and select the IN operator with either a single or multiple values, the following error is generated:

The current default action of using the IN operator encloses the entered criteria in single quotes (for example, 'val1 val2'). Enclosing the values in parentheses, single quotes, and separating by commas as the error states does not correctly format the syntax. The FilterEditor ► Standard filter encloses all entered criteria in single quotes (as in 'var1 var2'), which hinders the possibility of entering the correct syntax on this tab.

To circumvent the error above, select the Advanced tab of the FilterEditor and edit the IN operator syntax in the Filter string text field to represent the values surrounded by parentheses with each value enclosed in single quotes ('var1', 'var2').

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Universal Viewer	Microsoft® Windows® for x64	9.21	9.22		9.2 TS2M3
		Microsoft Windows Server 2003 Datacenter Edition	9.21	9.22		9.2 TS2M3
		Microsoft Windows Server 2003 Enterprise Edition	9.21	9.22		9.2 TS2M3
		Microsoft Windows Server 2003 Standard Edition	9.21	9.22		9.2 TS2M3
		Microsoft Windows Server 2008	9.21	9.22		9.2 TS2M3
		Microsoft Windows XP Professional	9.21	9.22		9.2 TS2M3
		Windows 7 Enterprise 32 bit	9.21	9.22		9.2 TS2M3
		Windows 7 Enterprise x64	9.21	9.22		9.2 TS2M3
		Windows 7 Professional 32 bit	9.21	9.22		9.2 TS2M3
		Windows 7 Professional x64	9.21	9.22		9.2 TS2M3
		Windows 7 Ultimate 32 bit	9.21	9.22		9.2 TS2M3
		Windows 7 Ultimate x64	9.21	9.22		9.2 TS2M3
		Windows Vista	9.21	9.22		9.2 TS2M3

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

---

The SAS Universal Viewer FilterEditor is not formatting the IN operator syntax correctly, which causes syntax errors. You see the following error message: "Syntax error: The items following the IN keyword must be separated by commas and be enclosed in parentheses."

Type:	Problem Note
Priority:	medium

Date Modified:	2009-05-22 12:24:59
Date Created:	2009-05-06 16:57:26