LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (December 2001, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 11 Dec 2001 18:40:00 -0000
Reply-To:   "Vyverman, Koen" <koen.vyverman@FID-INTL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Vyverman, Koen" <koen.vyverman@FID-INTL.COM>
Subject:   Re: access excel file
Content-Type:   text/plain; charset="iso-8859-1"

Ah, ehm ... let's say that in the context of the present dis- cussion on String Theory, I simply couldn't resist? But serious- ly, your solution works fine on NT4 here, and is more elegant to boot. I ought to read up on those pipes :-)

Thanks, Koen.

> Or is it another fine sample of UTMF (using too many functions) ;-)? > > *Tested for WIN2K only; > filename c pipe 'dir c:\temp\*.xls /B'; > data xl; > attrib xlfile length=$100; > infile c truncover; > input xlfile 1-100; > run;

> > filename dir 'c:\temp'; > > > > data xl_files_in_dir(keep=filename); > > length filename $ 200; > > did=dopen('dir'); > > do i=1 to dnum(did); > > filename=dread(did,i); > > if upcase(substr(left(reverse(filename)),1,4)) eq > 'SLX.' then output; > > end; > > rc=dclose(did); > > run; > > > > Another fine sample of using upcase(left(etc. *g* > >


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