LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2002, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 1 Aug 2002 18:35:44 +0100
Reply-To:   Peter Crawford <peter.crawford@DB.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Peter Crawford <peter.crawford@DB.COM>
Subject:   Re: retrieve libname options
Comments:   To: Randy Herbison <RandyHerbison@WESTAT.COM>
Content-type:   text/plain; charset=iso-8859-1

Thanks Randy

That (write) privilege is not one on which I can depend. Additionally, I'm trying to avoid step & statement boundaries.

Right now, the quick solution is as offered by SI, capturing proc contents ods output. == through the boundaries..

The only way I can see to avoid the boundaries, involves multiple %sysfunc calls to dread() member names of the path given by pathname(libname) So that appears to be my ultimate solution

many thanks Peter Thanks also for the assistance offered by others on and off SAS-L Ed Heaton, Andre Wielki, Michael Sadol and Kilo and of course SAS Customer Support

Datum: 01/08/2002 17:22 An: SAS-L@LISTSERV.UGA.EDU

Antwort an: Randy Herbison <RandyHerbison@WESTAT.COM>

Betreff: FW: retrieve libname options Nachrichtentext:

Peter,

Following up on my previous e-mail, if you have write access for the library, you could create a new library member using a name that doesn't already exist and then use FILEEXIST to determine the extension.

RandyHerbison@westat.com

-----Original Message----- From: Randy Herbison Sent: Thursday, August 01, 2002 11:43 AM To: SAS-L@LISTSERV.UGA.EDU Subject: RE: retrieve libname options

Peter,

You can use the SCL function ATTRC to get the engine, but I haven't found a way to determine whether a LIBRARY uses short or long extensions. You could check by using FILEEXIST, but the folder could contain the same one-part member name using both short and long extensions.

RandyHerbison@westat.com

-----Original Message----- From: Ed Heaton Sent: Thursday, August 01, 2002 11:15 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: retrieve libname options

Peter,

I can get you part of the way there:

Proc sql noPrint ; Select path into :path from sasHelp.vMember where ( ( upCase(libName) eq "SASUSER" ) & ( upCase(memName) eq "PILOTS" ) ) ; Quit ; %put &path ;

I don't know how to get the file name.

Ed

Edward Heaton, Senior Systems Analyst, Westat (An Employee-Owned Research Corporation), 1550 Research Boulevard, Room 2018, Rockville, MD 20850-3195 Voice: (301) 610-4818 Fax: (301) 294-3992 mailto:EdHeaton@westat.com http://www.westat.com

-----Original Message----- From: Peter Crawford [mailto:peter.crawford@DB.COM] Sent: Thursday, August 01, 2002 12:00 PM To: SAS-L@LISTSERV.UGA.EDU Subject: retrieve libname options

Hi

Do you know how I might discover the actual physical name of a sas data set on winXX and/or unix ?

I have libname.memname, and would like to know the actual path and filename. I think I need only discover the engine of the libname and whether it is using "long names" or 8.3 format names.

The pathname() function reveals the path, but nothing I can find identifies whether the libname has been prepared with the "ShortFileExt" option.

WIth ods destination output, I can collect the physical name from proc contents, but for this macro. I would like to avoid going through a statement boundary, let alone a step boundary.

with advance, thanks and appreciation of your interest

Peter Crawford

--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.


Back to: Top of message | Previous page | Main SAS-L page