Date: Fri, 25 May 2001 09:08:23 +1200
Reply-To: Geoff Grimwood <geoff@DATAMINE.CO.NZ>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Geoff Grimwood <geoff@DATAMINE.CO.NZ>
Organization: Datamine Limited
Subject: Re: Zip excel files from SAS
Content-Type: text/plain; charset=us-ascii
My 2 cents.
I prefer using the pipe device/engine thing because the irritating DOS
box doesn't make an appearance. The PKZIPC exectuable needs to be in the
PATH. I can't remember where I got the executable from but it is more or
less the same as PKZIP.
%zip(d:\temp,fred,txt) will create d:\temp\fred.zip containing
d:\temp\fred.txt. I'm too lazy to have one parameter and then take it
apart to get the necessary components.
Beware the quotes!
%macro zip(dir, filename, ext);
%let cmd2=%str(pkzipc -silent -add %"&dir\%trim(&filename).zip%"
filename foo pipe "&cmd2";
Richard DeVenezia wrote:
> You will also have to use double quotes around the filenames since they
> appear to contain embedded spaces.
> Such as
> x wzzip -a "c:\temp\b b\abcd" "c:\temp\a a";
> if you insist on quoting the command (not necessary but allowed) you need
> more quotes (two consecutive quotation marks (single or double) collapses to
> a single quotation mark of the same type, when within a quoted string that
> starts with the same type of quotation mark)
> x "wzzip -a ""c:\temp\b b\abcd"" ""c:\temp\a a""";
> Richard DeVenezia - SAS Macros and AF Tools
> "David Simmons" <DavidSi@KINKOS.COM> wrote in message
> > I'm trying to use winzip to zip some excel files from SAS using the X
> statement as discussed below.
> > One thing you can try is to have SAS shell out
> to DOS using an X
> > statement. You can then use command lines
> statement supported by
> > WINZIP 7 to create the zip file. For example,
> the SAS statement
> > X "WZZIP -a c:\test\myzip
> > will zip up the Excel file into a file named
> myzip.zip. A couple of
> > key issues. To use Winzip commands, the
> WinZip Command Line Support
> > Add-on (which the last time I checked was Beta
> software) must be
> > installed onto WinZip 7.0. I don't think
> version WinZip 6 supports
> > command lines. Both can be downloaded from
> the WinZip website. Also,
> > for the command to work as shown above, the
> winzip folder location
> > must be in your path statement (i.e. in your
> autoexec.bat file). All
> > this info is well documented in the Command
> Line Support
> > documentation.
> > Mike Mumma
> > Westat
> > When I issue the command below, a black dos box blinks on the screen
> > and that is all. I have added d:\program files\winzip to my autoexec
> file. any ideas would be appreciated.
> > X "winzip32 -a e:\loss prevention\April2001\ops10b e:\loss
> > David H. Simmons