Problem Note 66120: Merging CAS tables with a BY statement produces an error regarding the BY variable format
 |  |  |  |  |
When you use a DATA step to merge SAS® Cloud Analytic Services (CAS) tables with a BY statement, the following errors might be produced:
The error occurs when two tables using a numeric BY variable are merged. One table is promoted, partitioned, and ordered, but the other table is not.
The problem occurs because the BEST. format is associated with numeric variables when the PROMOTE=, PARTITION=, and ORDERBY= options are used when creating the table. However, this format is not associated with numeric variables when these options are not used to create the table.
The differences in the formats for the numeric BY variable then produce the error when the tables are merged.
To circumvent the problem, you must define the same format for the numeric BY variable when the individual tables are created.
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 |