SUPPORT / SAMPLES & SAS NOTES
Problem Note 59625: The message "ERROR: CONSTRAINT ADD did not complete" occurs when you use the GROUP keyword in the WHERE constraint
 |  |  |  |  |
If you use the GROUP keyword in the WHERE constraint, an error message similar to the following is written to the SAS log:
24 constraint add whconstraint; 25 where (GROUP = "@SPDSGRP"); ERROR: CONSTRAINT ADD did not complete. 26 quit;
To circumvent this issue, you would need to escape the GROUP keyword as shown in the following example:
constraint add whconstraint; where (\GROUP = "@SPDSGRP");
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | SAS Scalable Peformance Data Server | Microsoft® Windows® for x64 | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
| Microsoft Windows Server 2012 Datacenter | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Std | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Std | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| HP-UX IPF | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Linux for x64 | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Solaris for x64 | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 | ||