An attempt to use WHERE constraints with a VIEW might cause SAS Scalable Performance Data Server to disconnect.

The problem occurs because WHERE constraints are not supported in a VIEW.

The error might look similar to the following:

14         proc spdo lib=foo;
NOTE: Enter "?;" to get info on all the SPDO commands.
      Enter "SPDSMAC;" to get list and setting of all SPD macros.
15          set acluser;
NOTE: Acluser has been set to anonymou.
16          constraint remove _all_;
NOTE: Member does not exist in LIBNAME domain.
17          constraint add myview;
18          where x=1;
ERROR: .
ERROR: Error on server LIBNAME socket.
ERROR: .
ERROR: CONSTRAINT ADD did not complete.
19         quit;

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

Operating System and Release Information

A fix for this issue for SAS Scalable Performance Data Server 5.2 is available at:

A fix for this issue for SAS Scalable Performance Data Server 5.1 is available at: