BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
nrk1787db1
Obsidian | Level 7

Hi,

 

When I use PROC COPY with INDEX=YES, MEMTYPE=ALL & CONSTRAINTS=YES options I'm getting below INFO message in SAS Log

 

INFO: Engine's block-read  method cannot be used because:

INFO:   -  The file is compressed

 

I read somewhere that using block-read increases the performance, as I need to use copy on many libraries/datasets I have a question.

 

Is there any way where we can force SAS to use block-read even when file is compressed? 

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20
The message is so clear so I can't see why to question it.
What you can do is explore the effectivity of your compression. That would be dependent of your i/o througput, CPU and data profile. Even looking at your data model could reduce the need for compression.
Is this PROC COPY an important bottleneck in your system?
A dirty work around would be to use OS copy of the SAS files. Works for Base engine and non Metadata bound libraries.
Data never sleeps

View solution in original post

1 REPLY 1
LinusH
Tourmaline | Level 20
The message is so clear so I can't see why to question it.
What you can do is explore the effectivity of your compression. That would be dependent of your i/o througput, CPU and data profile. Even looking at your data model could reduce the need for compression.
Is this PROC COPY an important bottleneck in your system?
A dirty work around would be to use OS copy of the SAS files. Works for Base engine and non Metadata bound libraries.
Data never sleeps

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2902 views
  • 1 like
  • 2 in conversation