Problem Note 65105: The REPLICATION= table option is ignored when you use the WHERE clause while creating a CAS table
 |  |  |  |  |
The REPLICATION= table option is ignored when you use the WHERE clause while creating a CAS table.
When the value of the REPLICATION= table option is greater than 0, the number of total blocks should exceed the number of active blocks in the table. When a WHERE clause is used while creating the table, the REPLICATION= table option is ignored and the total number of blocks is equal to the number of active blocks.
The workaround is to use a DATA step and use the COPIES= option in the DATA statement. The COPIES= option has the same functionality of the REPLICATION= table option in the CAS procedure.
Here is an example:
set sashelp.cars;
run;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.4 | |||
Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinViya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-11-13 14:09:22 |
| Date Created: | 2019-11-12 14:36:33 |