Date:         Wed, 19 Mar 2008 15:04:15 -0400
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Re: Proc SQL problem...
Comments: To: u42132@UWE.UGA.EDU

Has to be capitalized:

where libname='MYLIB'

On Wed, 19 Mar 2008 19:00:22 GMT, flyfishing via MathKB.com
<u42132@UWE.UGA.EDU> wrote:

>Could somebody tell me what's wrong with this code. I want to put all
>filenames in a single file but didn't get the result... Thank you!
>
>
>libname mylib "f:\my documents\sas library";
>
>Proc SQL;
>Create Filelist as
> select  libname, Memname , nobs
>  from dictionary.tables
>  where libname='mylib';
>quit;
>
>--
>Message posted via http://www.mathkb.com