Prev: Inside the SAS procs.
Next: can proc tabulate do the ratio of sums?
From: jaheuk on 6 Apr 2010 10:10
dear all,
output of my PROC COPY
OPTIONS
COMPRESS=YES ;
PROC COPY INLIB=INLIB
OUTLIB=OUTLIB ;

RUN;

Copying INLIB.ODS_001 to OUTLIB.ODS_001
(memtype=DATA).
There were 4025662 observations read from the data set
INLIB.ODS_001.
The data set OUTLIB.ODS_001 has 4025662 observations and 29
variables.
Copying INLIB.ODS_005 to OUTLIB.ODS_005
(memtype=DATA).
There were 1679764 observations read from the data set
INLIB.ODS_005.
The data set OUTLIB.ODS_005 has 1679764 observations and 232
variables.
Compressing data set OUTLIB.ODS_005 decreased size by 53.32
percent.
Compressed is 25296 pages; un-compressed would require 54187
pages.
The PROCEDURE COPY used the following
resources:
CPU time -
00:00:53.87

WHY IS ODS_001 NOT COMPRESSED ???

Regards,
Herman
From: Tom Abernathy on 6 Apr 2010 10:50
On Apr 6, 10:10 am, jaheuk <hejac...(a)gmail.com> wrote:
> dear all,
> output of my PROC COPY
>      OPTIONS
> COMPRESS=YES ;
>      PROC COPY INLIB=INLIB
> OUTLIB=OUTLIB ;
>
> RUN;
>
> Copying INLIB.ODS_001 to OUTLIB.ODS_001
> (memtype=DATA).
> There were 4025662 observations read from the data set
> INLIB.ODS_001.
> The data set OUTLIB.ODS_001 has 4025662 observations and 29
> variables.
> Copying INLIB.ODS_005 to OUTLIB.ODS_005
> (memtype=DATA).
> There were 1679764 observations read from the data set
> INLIB.ODS_005.
> The data set OUTLIB.ODS_005 has 1679764 observations and 232
> variables.
> Compressing data set OUTLIB.ODS_005 decreased size by 53.32
> percent.
> Compressed is 25296 pages; un-compressed would require 54187
> pages.
> The PROCEDURE COPY used the following
> resources:
> CPU     time -
> 00:00:53.87
>
> WHY IS ODS_001 NOT COMPRESSED ???
>
> Regards,
> Herman

I suspect that PROC COPY is ignoring the COMPRESS option. You could
confirm by doing PROC CONTENTS on the INLIB library and see whether
ODS_001 and ODS_005 are compressed in the source library.
From: Carl Kaufmann on 6 Apr 2010 12:25
On 2010-04-06 10:10, jaheuk wrote:
> dear all,
> output of my PROC COPY
> OPTIONS
> COMPRESS=YES ;
> PROC COPY INLIB=INLIB
> OUTLIB=OUTLIB ;
>
> RUN;
>
> Copying INLIB.ODS_001 to OUTLIB.ODS_001
> (memtype=DATA).
> There were 4025662 observations read from the data set
> INLIB.ODS_001.
> The data set OUTLIB.ODS_001 has 4025662 observations and 29
> variables.
> Copying INLIB.ODS_005 to OUTLIB.ODS_005
> (memtype=DATA).
> There were 1679764 observations read from the data set
> INLIB.ODS_005.
> The data set OUTLIB.ODS_005 has 1679764 observations and 232
> variables.
> Compressing data set OUTLIB.ODS_005 decreased size by 53.32
> percent.
> Compressed is 25296 pages; un-compressed would require 54187
> pages.
> The PROCEDURE COPY used the following
> resources:
> CPU time -
> 00:00:53.87
>
> WHY IS ODS_001 NOT COMPRESSED ???
>
> Regards,
> Herman

PROC COPY will not change the dataset compression unless you use the
NOCLONE option.

Carl
 | 
Pages: 1
Prev: Inside the SAS procs.
Next: can proc tabulate do the ratio of sums?