SUPPORT / SAMPLES & SAS NOTES
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:
data casuser.test(copies=1);
set sashelp.cars;
run;
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 | |||