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.
x=1; y=2;
run;
y=2; x=1;
run;
set casuser.ds2;
run;
The results appear as follows:
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 |
Viya 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: | high |
| Date Modified: | 2020-06-30 08:00:45 |
| Date Created: | 2020-06-11 17:04:45 |