Date:         Tue, 26 Jul 2011 13:53:06 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: To check existence of table in library
Comments: To: Mahesh kumar P <Peesari.mahesh@gmail.com>
In-Reply-To:  <201107261849.p6QAkqoc011259@willow.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

DICTIONARY.TABLES (in PROC SQL) or SASHELP.VTABLE will give you the
information you need.  If you need to run a 'loop' to check last
modification date, I guess keep a master table and update it with the
tables/vtable information, writing to log what you're updating?

-Joe

On Tue, Jul 26, 2011 at 1:49 PM, Mahesh kumar P <Peesari.mahesh@gmail.com>wrote:

> Hi all
>
> How can I know the total no of tables in library ?if tables names are
> ending with
> Modified date ?how I can I run a loop which will check the latest
> modification table
> And write to log which tables were not updated previously?
>
> Please give your valuable inputs
>
> Thanks
> Mahesh P
>