Problem Note 58242: The sort order of rows for DBMS tables is incorrect in the SAS® Studio table viewer
 |  |  |  |  |
The sort order is incorrect in the SAS Studio table viewer when a filter is applied to a sorted character column in a DBMS table.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After this hot fix is applied to SAS® Studio 3.5, sorting is restricted to 500,000 rows or less. If a sort is attempted with more rows, the following message is displayed:
"The table cannot be sorted because it exceeds 500000 rows.
Use a filter to reduce the number of rows in the table."
Use a filter to reduce the number of rows in the table."
If Hot Fix W6002 was applied to upgrade SAS® Studio 3.4 to SAS Studio 3.5, the sort order for character columns will be correct. However, you will encounter the 500,000 row restriction.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Studio | Linux for x64 | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M4 |
| HP-UX IPF | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Solaris for x64 | 3.5 | 3.6 | 9.4 TS1M3 | 9.4 TS1M4 | ||
A fix for this issue for SAS Studio 3.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y75.html#58242A fix for this issue for SAS Studio 3.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W62.html#58242| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-07-10 15:29:12 |
| Date Created: | 2016-05-19 11:20:49 |