, must have the same format with all input data sets the BY statement applies to when using DATA step in Cloud Analytic Services."" />
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:
ERROR: The first BY variable, variable-name, must have the same format with all input data sets the BY statement applies to when using DATA step in Cloud Analytic Services.
ERROR: The action stopped due to errors.
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
SAS System | SAS Viya | Linux for x64 | 3.5 | 3.5 | Viya | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Merging SAS® Cloud Analytic Services (CAS) data produces a variable format error:
"ERROR: The first BY variable,
, must have the same format with all input data sets the BY statement applies to when using DATA step in Cloud Analytic Services."
Type: | Problem Note |
Priority: | high |
Date Modified: | 2020-06-12 09:56:21 |
Date Created: | 2020-06-11 13:50:32 |