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 |
I posted this so others would find it in search results. The solution in in the original post.
I posted this so others would find it in search results. The solution in in the original post.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: