SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 66214: PROC SQL queries might generate exceptions if you use the CORRESPONDING (CORR) keyword with the EXCEPT set operator to combine tables

DetailsCodeHotfixAboutRate It

SQL procedure queries that combine data sets using the EXCEPT set operator in conjunction with the CORRESPONDING (CORR) keyword generate exceptions. The same code does not generate exceptions in SAS® 9.4M5 (TS1M5) and earlier. See the Full Code tab for example code that triggers this issue.

If you set the SORTEDBY flag on one of the data sets, the exception does not occur. Also, if you use the ALL keyword in a query along with the CORR keyword, the exception does not occur.

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



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemBase SASz/OS9.4_M69.4 TS1M6
z/OS 64-bit9.4_M69.4 TS1M6
Microsoft® Windows® for x649.4_M69.4 TS1M6
Microsoft Windows 8 Enterprise 32-bit9.4_M69.4 TS1M6
Microsoft Windows 8 Enterprise x649.4_M69.4 TS1M6
Microsoft Windows 8 Pro 32-bit9.4_M69.4 TS1M6
Microsoft Windows 8 Pro x649.4_M69.4 TS1M6
Microsoft Windows 8.1 Enterprise 32-bit9.4_M69.4 TS1M6
Microsoft Windows 8.1 Enterprise x649.4_M69.4 TS1M6
Microsoft Windows 8.1 Pro 32-bit9.4_M69.4 TS1M6
Microsoft Windows 8.1 Pro x649.4_M69.4 TS1M6
Microsoft Windows 109.4_M69.4 TS1M6
Microsoft Windows Server 2012 Datacenter9.4_M69.4 TS1M6
Microsoft Windows Server 2012 R2 Datacenter9.4_M69.4 TS1M6
Microsoft Windows Server 2012 R2 Std9.4_M69.4 TS1M6
Microsoft Windows Server 2012 Std9.4_M69.4 TS1M6
Microsoft Windows Server 20169.4_M69.4 TS1M6
Microsoft Windows Server 20199.4_M69.4 TS1M6
Windows 7 Enterprise 32 bit9.4_M69.4 TS1M6
Windows 7 Enterprise x649.4_M69.4 TS1M6
Windows 7 Home Premium 32 bit9.4_M69.4 TS1M6
Windows 7 Home Premium x649.4_M69.4 TS1M6
Windows 7 Professional 32 bit9.4_M69.4 TS1M6
Windows 7 Professional x649.4_M69.4 TS1M6
Windows 7 Ultimate 32 bit9.4_M69.4 TS1M6
Windows 7 Ultimate x649.4_M69.4 TS1M6
64-bit Enabled AIX9.4_M69.4 TS1M6
64-bit Enabled Solaris9.4_M69.4 TS1M6
HP-UX IPF9.4_M69.4 TS1M6
Linux for x649.4_M69.4 TS1M6
Solaris for x649.4_M69.4 TS1M6
* 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.