Date:         Wed, 23 Jul 2003 11:23:07 -0400
Reply-To:     Ian Whitlock <WHITLOI1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ian Whitlock <WHITLOI1@WESTAT.COM>
Subject:      Re: W2K Folder Content - Solved
Comments: To: "Bosch, Jules [PRDUS Non J&J]" <JBosch1@PRDUS.JNJ.COM>
Comments: cc: "peter.crawford@BLUEYONDER.CO.UK"
          <peter.crawford@BLUEYONDER.CO.UK>,
          "charles_s_patridge@prodigy.net" <charles_s_patridge@prodigy.net>
Content-Type: text/plain

Peter,

I noticed that Jules used your macro tip which contains the code

   %local rc myref ;

   /* now obtain a free fileref */
   %let   rc  =  %sysfunc( filename( myRef, . ));
   %let myRef = _%substr( &myRef, 2 );
    /* strange delivery of # converted to _ */

The reason for the # is that SI uses this symbol for their own private name
space of filerefs.  This calls into question the value of the code above as
shown by the following.

11   filename _ln00008 "c:\junk" ;
12   %let myref = ;
13   %let   rc  =  %sysfunc( filename( myRef, . ));
14   %put &myref ;
#LN00008
15   filename _ln00008 list ;
NOTE: Fileref= _LN00008
      Physical Name= c:\junk

To guarantee that a fileref is free I think you have to check the entire
list of SASHELP.VEXTFL or check for empty return of a generated names as
shown by

24   %put >>%sysfunc(pathname(_pc00001))<< ;
>><<

Perhaps this is a service that SI might consider providing.

IanWhitlock@westat.com

-----Original Message-----
From: Bosch, Jules [PRDUS Non J&J] [mailto:JBosch1@PRDUS.JNJ.COM]
Sent: Tuesday, July 22, 2003 10:49 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: W2K Folder Content - Solved


Charles,

I just implemented TIP00312.  It worked perfectly and I thank you very much.
Long live SCONSIG!

Jules Bosch

-----Original Message-----
From: Charles Patridge [mailto:charles_s_patridge@prodigy.net]
Sent: Tuesday, July 22, 2003 9:53 AM
To: Bosch, Jules [PRDUS Non J&J]
Subject: Re: W2K Folder Content



Maybe,

See if these help you out on this question:

http://www.sconsig.com/sastips/tip00312.htm
<http://www.sconsig.com/sastips/tip00312.htm>

http://www.sconsig.com/sastips/tip00304.htm
<http://www.sconsig.com/sastips/tip00304.htm>

http://www.sconsig.com/sastips/tip00054.htm
<http://www.sconsig.com/sastips/tip00054.htm>

You might be able to use them as guides to build what you are looking to do.

HTH,
Charles Patridge

"Bosch, Jules [PRDUS Non J&J]" <JBosch1@PRDUS.JNJ.COM> wrote:

Charles,

Is there any info on the SCONSIG website regarding the following.  I want to
create a SAS data set of the member names in a W2K folder.  Now, I know I
can use SAS' Data Dictionary for the SAS data sets in the folder.  But, what
about the non-SAS members?  I'll post this to the L shortly if there is
nothing at SCONSIG.

TIA,

Jules



Charles S Patridge - PDPC, Ltd.
172 Monce Road - Burlington, CT 06013 USA
Email: Charles_S_Patridge@prodigy.net
Web: http://www.sconsig.com
Web: http://pages.prodigy.net/charles_s_patridge
Web: http://www.munic.state.ct.us/burlington