John -

The path name is in the view sashelp.vslib.

However, if you are accessing Oracle using SAS?Access for Oracle, your path is whatever was defined locally in Net8 as the name to use to reference the Oracle connection, and that could potentially be different from user to user.

Carol Bristow DPRA Inc. 1300 N 17th St Suite 950 Rosslyn, VA 22209 Work: 703-841-8025 Fax: 703-524-9415 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Schafluetzel, John Sent: Friday, April 22, 2005 11:10 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Oracle Path Information

Is there a way to obtain the oracle path information within a SAS application?

My platform is Windows, and I have specified dbprompt=yes in the libname statement. I would like to obtain the path that was entered and place in in the heading of the report via a macro variable.

Thanks

jrs ________________________________

Information Technology Greeley, CO 80639 John R. Schafluetzel Assistant Director - Operating Systems, Database, Operations (970) 351-2341 IT Office IT Fax: (970) 351-1650 (970) 351-1457 Office <mailto:john.schafluetzel@UNCo.edu> (970) 330-2507 Home John.Schafluetzel@UNCo.edu <mailto:jrs@UnivNorthCo.edu>