Date:         Thu, 5 Feb 2004 21:45:10 -0500
Reply-To:     Lou <lpogodajr292185@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lou <lpogodajr292185@COMCAST.NET>
Subject:      Re: List of datasets

"Nancy Brucken" <brucken@PROVIDE.NET> wrote in message
news:200402040544.i145iOB29144@listserv.cc.uga.edu...
> Hi,
>   Venky gave you one way to do this;  here's another approach:
>
> proc sql noprint;
>   create table datasets as
>     select memname from dictionary.tables
>       where libname="P1_&dept";
> quit;
>
> Make sure P1_&dept resolves to exactly the same name found in the
> dictionary table- the comparison is case-sensitive.
>
> Hope this helps,
>    Nancy

You can make it not case sensitive by changing the last line to something
like

where lowcase(libname) = lowcase("P1_&dept");