| Date: | Sat, 14 Nov 1998 01:39:35 EST |
|---|
| Reply-To: | PW098@AOL.COM |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU> |
|---|
| From: | Bob Fitz <PW098@AOL.COM> |
|---|
| Subject: | Re: list oracle tables from SAS |
|---|
| Content-type: | text/plain; charset=US-ASCII |
|---|
Thomas,
Below is code I use to pull all of the Tables with info with each variable.
HTH,
Bob
/***************************************************************
* PRO SQLCOL.SAS - READS FROM ORACLE TABLES AND PRINTS ALL
* COLUMN INFO FROM THE REQUESTED TABLES.
* RRF 9/30/95
***************************************************************/
/*MS LINEDRAW 10 - 8.5 X 14 LANDSCAPE */
PROC SQL;
CONNECT TO ODBC AS MYCON (DSN="SASPROD" PWD=xxxxxx UID=xxxxxx);
CREATE VIEW X AS
SELECT * FROM CONNECTION TO MYCON
(ODBC::SQLColumns,"NSROWN", ,);
QUIT;
/***************************************************************
* SQLCOLUMNS MUST BE IN SMALL LETTERS OR IT BLOWS UP!!!
* REMOVE "NSROWN" TO RECEIVE ALL TABLES AND COLUMNS NOT JUST
* COLUMNS FROM NSROWN
***************************************************************/
DATA Y;
SET X;
RUN;
|
