PROC COPY and compress option

  • Follow


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
0
Reply hejacobs (85) 4/6/2010 2:10:12 PM

On Apr 6, 10:10=A0am, jaheuk <hejac...@gmail.com> wrote:
> dear all,
> output of my PROC COPY
> =A0 =A0 =A0OPTIONS
> COMPRESS=3DYES ;
> =A0 =A0 =A0PROC COPY INLIB=3DINLIB
> OUTLIB=3DOUTLIB ;
>
> RUN;
>
> Copying INLIB.ODS_001 to OUTLIB.ODS_001
> (memtype=3DDATA).
> 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=3DDATA).
> 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 =A0 =A0 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.
0
Reply Tom 4/6/2010 2:50:40 PM


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
0
Reply Carl 4/6/2010 4:25:58 PM

2 Replies
385 Views

(page loaded in 0.07 seconds)

Similiar Articles:













7/21/2012 6:44:56 PM


Reply: