|
|
PROC COPY and compress option
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)
|
|
|
|
|
|
|
|
|