Problem Note 65920: The PRINT procedure fails to work, and you see an error regarding the sorted data set from the SAS® Federation Server (FEDSVR) engine
 |  |  |  |  |
PROC PRINT fails with an error similar to the following in the SAS log:
ERROR: Data set WORK.Y is not sorted in ascending sequence. The current BY group has V = a and the next BY group has V = A.
This error appears after you run the SORT procedure with the SORTSEQ=LINGUISTIC option. An example is shown here:
proc sort data=lib1.x out=work.y sortseq=linguistic;
by v;
run;
proc print data=work.y;
by v;
run;
by v;
run;
proc print data=work.y;
by v;
run;
This problem occurs after installing the hot fix in SAS Note 63320, "SAS® Federation Server does not translate the DATE format as documented for a view (DSN=BASE) created from database tables." That hot fix implemented enhanced format processing. However, a regression occurs only for data that contains DBCS (double-byte character set) encoding.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Linux for x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 |
| HP-UX IPF | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2019 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Datacenter | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise 32-bit | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Solaris for x64 | 4.2 | 4.2 | 9.4 TS1M6 | 9.4 TS1M6 | ||
A fix for this issue for Base SAS 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D9T.html#65920A fix for this issue for Base SAS 9.4_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B6Q.html#65920| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-05-11 09:24:17 |
| Date Created: | 2020-05-04 08:06:30 |