Prev: Proc Report Line@
Next: Please help, Do loop
From: Eversmann on 22 Apr 2010 11:06
Dear All,

My data sources are in compressed files (windows zip). is there a way
of reading datasets inside the zip file without extracting using
windows. I have seperate folder structures inside the zip file too (as
in different datasets are under different folders organised).

If unable to access zip file with folder structures, I would be
interested to know if there's atleast a way to access datasets
directly in the root of the zip file.

Many Thanks
From: Richard A. DeVenezia on 22 Apr 2010 15:04
On Apr 22, 11:06 am, Eversmann <rifazraz...(a)gmail.com> wrote:
> Dear All,
>
> My data sources are in compressed files (windows zip). is there a way
> of reading datasets inside the zip file without extracting using
> windows. I have separate folder structures inside the zip file too (as
> in different datasets are under different folders organised).
>
> If unable to access zip file with folder structures, I would be
> interested to know if there's atleast a way to access datasets
> directly in the root of the zip file.

This paper is the only one I'm aware of that directly addresses the
topic:
http://www2.sas.com/proceedings/sugi24/Coders/p099-24.pdf

From: Arthur Tabachneck on 22 Apr 2010 18:37
As long as it isn't production code you can always try to see if
SASZIPAM will work. You can find documentation at:
http://support.sas.com/kb/31/244.html

HTH,
Art
-------------
On Apr 22, 3:04 pm, "Richard A. DeVenezia" <rdevene...(a)gmail.com>
wrote:
> On Apr 22, 11:06 am, Eversmann <rifazraz...(a)gmail.com> wrote:
>
> > Dear All,
>
> > My data sources are in compressed files (windows zip). is there a way
> > of reading datasets inside the zip file without extracting using
> > windows. I have separate folder structures inside the zip file too (as
> > in different datasets are under different folders organised).
>
> > If unable to access zip file with folder structures, I would be
> > interested to know if there's atleast a way to access datasets
> > directly in the root of the zip file.
>
> This paper is the only one I'm aware of that directly addresses the
> topic:
> http://www2.sas.com/proceedings/sugi24/Coders/p099-24.pdf
From: Patrick on 24 Apr 2010 05:05
I would assume that you need some 3rd party software to unzip which
can read the structure of the zipped file.

I understand your "...without extracting using windows..." that you
want to control the whole process out of SAS and not first have to
manually start Winzip and extract the files.

To be able to do so the 3rd party zip software must allow command line
syntax.

For Winzip:
There is an add-on for command line syntax (often not part of the
default installation, but can be downloaded for free). As soon as this
add-on is installed on the machine where SAS runs you can control
everything out of SAS.

i.e: x 'wzunzip test.zip *.sas7bdat' would unzip all sas datasets in
test.zip (also from subfolders) into the current directory. You then
could use a libname for that directory - and there you are.

Lookup the switches which come with wzunzip. There are many options.

HTH
Patrick
 | 
Pages: 1
Prev: Proc Report Line@
Next: Please help, Do loop