topic Re: How to compress all data set in a library in SAS Programming

How to compress all data set in a library

caveman529 — Tue, 08 Oct 2013 16:27:57 GMT

Ladies and Gentlemen:

I forgot to put the option (compress=yes) in my original code when creating dataset. Is there a way to compress those SAS datasets in a batch mode? There are too many of them to do it manually?

I found this:

*----------------------------------------------------------------------;

* Copying datasets adding compression ;

*----------------------------------------------------------------------;

%let path=.;

options compress=yes ;

libname in "&path";

libname out "&path";

proc copy inlib=in outlib=out noclone datecopy memtype=data ;

run;

But I'm not sure this works or not, or it is the correct way for doing so. Thanks -

Re: How to compress all data set in a library

LinusH — Tue, 08 Oct 2013 18:01:59 GMT

In 9.4 at least, SAS will stop you from doing that - you haven't tested yourself?

The simplest seems to have the tables compressed in alternate location.

Re: How to compress all data set in a library

Patrick — Wed, 09 Oct 2013 02:27:07 GMT

Some code like below should do the job:

options compress=yes;

libname temp "c:\tests";
libname source (work);

proc datasets lib=temp kill nowarn nolist;
copy inlib=work outlib=temp noclone datecopy memtype=data index=yes constraint=yes;
run;
copy inlib=temp outlib=work noclone datecopy memtype=data index=yes constraint=yes move;
run;
quit;

libname temp clear;

Re: How to compress all data set in a library

caveman529 — Wed, 09 Oct 2013 04:02:43 GMT

Many thanks for your help. I found compress data reduce I/O quite a bit...