Well, this just keeps the puzzlement going for you.
This is the same code you provided, essentially,
and it worked fine here, using 8.01 SAS.
libname sql ODBC dsn=myMDB;
proc CONTENTS data = SQL._all_ nods;
proc CONTENTS data = SQL.A_Table_In_myMDB;
Hope this is helpful,
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
From: Fehd, Ronald J. [mailto:rjf2@CDC.GOV]
Sent: Thursday, May 17, 2001 8:13 AM
Subject: Q: proc CONTENTS on an SQL database
note: LIBNAME SQL is an ODBC connection.
I know the name of one member in an SQL database:
16 proc CONTENTS data = SQL.MPEP_P24_FORMAT_UNIQ;
NOTE: PROCEDURE CONTENTS used:
18 proc CONTENTS data = SQL._all_ nods;
WARNING: No matching members in directory.
Q: how do I get the list of all members?
Ron Fehd the macro maven CDC Atlanta GA USA RJF2@cdc.gov
OpSys: WinNT Ver: 8.1
---> cheerful provider of TESTED SAS code!*! <---
By using your intelligence you can sometimes make your problems twice as
-- Ashleigh Brilliant
By using their intelligence they have made my problems twice as complicated.