If you make a query to SASHELP.VCOLUMN using a where clause including the MEMTYPE field, it returns the wrong columns associated with the correct table. It appears to be returning the columns from the last table created. This is a new bug in M7, as the code that failed because of this ran fine last year at this time, and a colleague ran it in M6 without problems I have boiled it down to the very simple example included in the diagnostic step section. The first query return the wrong information, the second works correctly.  The third is a work around using like instead of equality.  SAS support has been notified and "notif(ied) R&D of this issue." data temp.table1; Var_A = "Hello"; Var_B = "There"; run; data temp.table2; Var_C = "Hello"; Var_D = "Again"; run; proc sql; select libname,memname,memtype,name from sashelp.vcolumn where libname = "TEMP" and memname = "TABLE1" and memtype = 'DATA'; select libname,memname,memtype,name from sashelp.vcolumn where libname = "TEMP" and memname = "TABLE1"; select libname,memname,memtype,name from sashelp.vcolumn where libname = "TEMP" and memname = "TABLE1" and memtype like 'DATA%'; quit; However, I just ran all of the latest hotfixes to fix a different bug, and it solved the problem!  So the fix is in one of these hotfixes.  Sorry I don't know which one, but just install them all.   I9R002 11/06/20 Issue(s) Addressed Documentation Download I9R003 11/03/20 Issue(s) Addressed Documentation Download I9R004 10/27/20 Issue(s) Addressed Documentation Download I9R006 11/17/20 Issue(s) Addressed [ 1 ] Documentation Download I9R009 11/30/20 Issue(s) Addressed Documentation Download I9S001 [ C ] 11/12/20 Issue(s) Addressed Documentation [ D  ] Download   SAS Enterprise Guide 8.3 for Windows for x64 Hot Fix Released       I8T001 11/09/20 Issue(s) Addressed Documentation Download   SAS/ETS 15.2 for Windows for x64 Hot Fix Released       J4K001 11/30/20 Issue(s) Addressed [ S ] Documentation Download     See: 58607   SAS Add-In for Microsoft Office 8.3 for Windows for x64 Hot Fix Released       I8U001 11/09/20 Issue(s) Addressed Documentation Download   SAS Middle Tier 9.4_M7 for Windows for x64 Hot Fix Released       J2L001 [ C ] 11/11/20 Issue(s) Addressed [ S ] Documentation [ D  ] Download     See: 58607   SAS/STAT 15.2 for Windows for x64 Hot Fix Released       I5L002 [ C ] 11/17/20 Issue(s) Addressed [ A ] [ 1 ] Documentation Download   Base SAS 9.4_M7 for Windows for x64 Hot Fix Released       I8G001 [ C ] 11/16/20 Issue(s) Addressed Documentation [ D  ] Download   SAS Threaded Kernel User Functions 9.4_M7 for Windows for x64 Hot Fix Released       I7U001 10/22/20 Issue(s) Addressed Documentation Download   SAS Threaded Kernel Grid 9.4_M8 for Windows for x64 Hot Fix Released       I8C001 10/09/20 Issue(s) Addressed Documentation Download   SAS Threaded Kernel Extensions for High-Performance Data Mining 15.2 for Windows for x64 Hot Fix Released       I7I001 10/05/20 Issue(s) Addressed Documentation Download   SAS Threaded Kernel Extensions for Interactive Matrix Language 15.2 for Windows for x64 Hot Fix Released       J3B001 11/30/20 Issue(s) Addressed [ A ] Documentation Download   Threaded Kernel Metadata Component 9.4_M7 for Windows for x64 Hot Fix Released       J5A001 12/08/20 Issue(s) Addressed Documentation Download   Threaded Kernel Extensions for Operations Research and GRAPH Analytics 15.2 for Windows for x64 Hot Fix Released       J4N001 11/25/20 Issue(s) Addressed Documentation Download   SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M7 for Windows for x64 Hot Fix Released       J1F001 12/04/20 Issue(s) Addressed Documentation Download   SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M5 for Windows for x64 Hot Fix Released       I9H002 11/10/20 Issue(s) Addressed Documentation Download   SAS Threaded Kernel 9.4_M7 for Windows for x64 Hot Fix Released       I5V002 12/08/20 Issue(s) Addressed Documentation Download   SAS ODBC Drivers for the Web Infrastructure Platform Data Server 9.46 for Windows for x64 Hot Fix Released       J1Q001 ... View more

How do you raise a custom error(exception) in DS2. In traditional DATA step you can use a put statement with a string starting with "ERROR:".  This will show as an error highlighted in red in the log. In EG it is also listed in the errors list, making it very obvious that an error was thrown.  In DS2, it doesn't highlight the statement in red and it does not show in the error list. The same thing is true of "NOTE:" and "WARNING:".  I am using the STOP statement which will stop execution, but if you don't carefully look at the log, it looks like a successful execution.   Here is some code demonstrating what I am talking about:   proc ds2; package work.test/overwrite=yes; method test(); put 'ERROR: This is a test error in a called package method'; end; run; data _null_ ; method init(); declare package work.test test1; test1 = _new_ work.test(); put 'ERROR: This is a test error in init method'; end; method run(); put 'ERROR: This is a test error in run method'; stop; end; enddata; run; quit; data _null_; put "ERROR: This is a test error within a data step that works"; run; Thanks for taking the time to look at this. ... View more