Date:         Tue, 6 Sep 2005 12:00:05 -0700
Reply-To:     Alex Pavluck <apavluck@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alex Pavluck <apavluck@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Create output dataset of format library
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hello.  I have many datasets that I use for analysis.  Reciently I used
the below code to create an output Excel spreadsheet that I imported
into ACCESS so that I can search all datasets for variables by
name,label, etc.

proc sql;
        create table content as
        select memname, name, type, label
        from dictionary.columns
        where libname in ("ORIGINAL", "DERIVED", "DIETSYS", "REPORTED",
"VERIFIED", "MASTER", "MORT", "PYEAR");
quit;


Now, I want to create another output Excel spreadsheet from all the
format libraries that are associated with these files so that I can
link it by name in my database and therefore allow me to obtain format
values for each variable when I search the database.  This code will
allow me to view the format library:

LIBNAME LIBRARY    'D:\DATASETS\MASTER\';
run;

proc format LIBRARY=LIBRARY.FORMATS FMTLIB;run;


I know I must be close to getting all this together.  What I need to
know is how to pull all format libraries without listing them by name
and how to output only the name, dataset file, and values for the
formats to the Excel spreadsheet.

Thanks in advance!

Alex