|Date: ||Tue, 3 Feb 2004 15:16:34 -0800|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Patrick F. O'Neill" <Patrick.F.O'Neill@KP.ORG>|
|Subject: ||Re: connecting to oracle|
|Content-Type: ||text/plain; charset="us-ascii"|
In answer to your first question, you may be interested in looking up the
libname ... dbprompt=yes defer=no;
Defer=no makes it do the prompting when the libname statement is executed.
Defer=yes makes it wait until the libname is actually used.
Hope this helps,
Larry Kaskey <LKaskey@TRACFONE.COM>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
02/03/2004 02:14 PM
Please respond to Larry Kaskey
Subject: connecting to oracle
I am creating a library like this...
libname clfy oracle user=xxxxxx password=xxxxxxx
I have two questions....
1. Is there a way to avoid the hard coding of my username and
password...perhaps have sas prompt me for those. I believe someone asked
similar question today
2. When I create the library, I can access the data tables, but when I
drill down in the folder to see the names of the tables, the folder
blank. Why would that be?
I am using EG 2.0 for this.
Thanks for any and all help!!