BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
CurtisMackWSIPP
Lapis Lazuli | Level 10

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
1 ACCEPTED SOLUTION

Accepted Solutions
CurtisMackWSIPP
Lapis Lazuli | Level 10

I posted this so others would find it in search results.  The solution in in the original post.

View solution in original post

1 REPLY 1
CurtisMackWSIPP
Lapis Lazuli | Level 10

I posted this so others would find it in search results.  The solution in in the original post.

Ready to join fellow brilliant minds for the SAS Hackathon?

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!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 414 views
  • 0 likes
  • 1 in conversation