Date:         Thu, 17 May 2001 08:52:03 -0700
Reply-To:     "Terjeson, Mark" <TerjeMW@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <TerjeMW@DSHS.WA.GOV>
Subject:      Re: proc CONTENTS on an SQL database
Comments: To: "Fehd, Ronald J." <rjf2@CDC.GOV>
Content-Type: text/plain; charset=iso-8859-1

Hi Ron,

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;
run;


proc CONTENTS data = SQL.A_Table_In_myMDB;
run;


Hope this is helpful,
Mark Terjeson
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
terjemw@dshs.wa.gov




-----Original Message-----
From: Fehd, Ronald J. [mailto:rjf2@CDC.GOV]
Sent: Thursday, May 17, 2001 8:13 AM
To: SAS-L@LISTSERV.UGA.EDU
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;
17   run;

NOTE: PROCEDURE CONTENTS used:
18   proc CONTENTS data = SQL._all_ nods;
19   run;

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
complicated.
-- Ashleigh Brilliant
By using their intelligence they have made my problems twice as complicated.