Problem Note 31456: Incorrect order of character category values on an HBOX or VBOX statement
When using character category values on the HBOX or VBOX statement in PROC SGPANEL, the values might not be displayed in the correct alphabetical order. The problem will occur even when using the DISCRETEORDER option on the ROWAXIS or COLAXIS statement that is associated with the category axis.
To circumvent the problem when using a BY statement in PROC SGPANEL, pre-sort the data in the following order:
<BY variable(s)> <PANELBY variable(s)> <CATEGORY variable>
To circumvent the problem when not using a BY statement, create a numeric variable that orders the category values and define a format to match the number with the correct category value. Use the numeric variable as the CATEGORY variable on the HBOX or VBOX statement and use a FORMAT statement to associate the format with the numeric variable in the procedure.
Operating System and Release Information
| SAS System | SAS/GRAPH | z/OS | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows 2000 Server | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows 2000 Professional | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M0 |
| Windows Vista | 9.2 TS1M0 | 9.2 TS2M0 |
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M0 |
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M0 |
| 64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M0 |
| HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M0 |
| Linux | 9.2 TS1M0 | 9.2 TS2M0 |
| Linux for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
| OpenVMS on HP Integrity | 9.2 TS1M0 | 9.2 TS2M0 |
| Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M0 |
*
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.
When using character category values on the HBOX for VBOX statement in PROC SGPANEL, the values might not be displayed in the correct alphabetical order.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-03-20 09:30:23 |
| Date Created: | 2008-03-13 09:41:09 |
