SUPPORT / SAMPLES & SAS NOTES
Problem Note 66124: Appending to a CAS table can produce incorrect results without producing any indication in the log that the results are incorrect
 |  |  |  |  |
Appending to a SAS® Cloud Analytic Services (CAS) table can produce incorrect results without producing any indication in the log that the results are incorrect.
This problem occurs only when appending to a promoted table.
The following code example illustrates the problem. The values in the DS2 table are appended to the DS1 table, based on the order of the variables in the table and not the variable name.
data casuser.ds1(promote=yes);
x=1; y=2;
run;
x=1; y=2;
run;
data casuser.ds2;
y=2; x=1;
run;
y=2; x=1;
run;
data casuser.ds1(append=yes);
set casuser.ds2;
run;
set casuser.ds2;
run;
The results appear as follows:
Obs x y
1 1 2
2 2 1
1 1 2
2 2 1
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
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.5 | 3.5 | Viya | Viya |