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
Content-Type: text/plain; charset=ISO-8859-1
Have a look at this:
On Wed, Oct 26, 2011 at 11:11 AM, Chris Bat <firstname.lastname@example.org> 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:
> 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,
> 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....