Date:         Thu, 17 May 2001 12:00:44 -0400
Reply-To:     wei cheng <cheng_wei@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         wei cheng <cheng_wei@HOTMAIL.COM>
Subject:      Re: Q: proc CONTENTS on an SQL database
Comments: To: rjf2@CDC.GOV
Content-Type: text/plain; format=flowed

Ron,

I don't know which kind of database you have. But you can try:

proc sql;
select table_name from SQL.all_tables;
quit;

HTH,

Wei Cheng
=================================================================
http://www.geocities.com/prochelp
INTERNET and Web Resources for SAS Programmers and Statisticians
=================================================================

>From: "Fehd, Ronald J." <rjf2@CDC.GOV>
>Reply-To: "Fehd, Ronald J." <rjf2@CDC.GOV>
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Q: proc CONTENTS on an SQL database
>Date: Thu, 17 May 2001 11:12:54 -0400
>
>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.




_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com