Date:         Wed, 26 Oct 2011 11:13:37 -0700
Reply-To:     Mary Rosenbloom <mary.rosenbloom.sas@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary Rosenbloom <mary.rosenbloom.sas@GMAIL.COM>
Subject:      Re: Data Dictionary and Metadata for Oracle
Comments: To: Chris Bat <darth.pathos@gmail.com>
In-Reply-To:  <201110261811.p9QAlMR3008765@willow.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

Have a look at this:

http://www.wuss.org/proceedings10/databases/2908_4_DDI-Lafler.pdf


On Wed, Oct 26, 2011 at 11:11 AM, Chris Bat <darth.pathos@gmail.com> wrote:
> Hi all,
>
> Well, I've really given this one my all and I'm completely and utterly
> stumped.  I'm trying to create a data dictionary / metadata report for a
> number of tables in my Oracle Database but the best I can do is create the
> single table report using PROC CONTENTS.  I've tried a number of different
> macros and code segments from Articles I have found online, but none of them
> seem to work.
>
> Some of the articles I've tried include:
> http://www.scsug.org/SCSUGProceedings/2011/poling2/FINDING%20ORACLE%20TABLE%
> 20METADATA%20WITH%20SAS.pdf - Finding Oracle Table Metadata by Poling;
>
> http://www2.sas.com/proceedings/sugi27/p099-27.pdf - A quick and easy data
> dictionary by Lund;
>
> http://www.nesug.org/proceedings/nesug03/hw/hw006.pdf - PROC DATASETS -
> Managing Data Efficiently by Ewing;
>
> and the one I was most excited about,
> http://www.lexjansen.com/wuss/2007/DataPresentationsBusIntell/DPBI_Williamso
> n_ProducingAuotData.pdf - Producing an Automated Data Dictionary as an RTF
> File by Williamson.
>
> I don't know SAS Macro programming at all, so it's possible when I'm making
> a change in the code I'm not doing it all the way through.  Williamson's RTF
> code does work on a single table, but I'm looking at well over 240 tables
> and really don't want to type out each name individually.
>
> Not knowing what I should do, I'm not sure what other information I can
> provide.  I'm on SAS 9.3, WinXP SP3, and would appreciate any other help.
>
> Thanks so much....
> Chris
>