Date: Wed, 26 Oct 2011 14:11:15 -0400
Reply-To: Chris Bat <darth.pathos@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Chris Bat <darth.pathos@GMAIL.COM>
Subject: Data Dictionary and Metadata for Oracle
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....