Problem Note 65152: The error message "BY variables are not properly sorted on data set…" appears after a DATA step is run with a BY statement against a partitioned table
 |  |  |  |  |
The following error message occurs in the SAS® Cloud Analytic Services (CAS) log after you run a DATA step against a partitioned table:
ERROR: BY variables are not properly sorted on data set table-name.
A workaround is to add the NOTSORTED option to the BY statement, as shown in this example:
data casuser.table1;
set casuser.table2;
by x notsorted;
run;
set casuser.table2;
by x notsorted;
run;
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.4 | 3.5 | Viya | |
Viya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates
The following error message occurs after you run a DATA step against a partitioned table: "ERROR: BY variables are not properly sorted on data set table-name."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-11-25 16:40:00 |
| Date Created: | 2019-11-20 16:28:59 |