SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 39904: Bar-line charts sort on formatted values in SAS® Web Report Studio

DetailsAboutRate It

In SAS Web Report Studio, bar-line charts sort the category that is assigned to the horizontal axis by formatted values, regardless of the data type (numeric or character). Other graphs sort on formatted values for character data and unformatted values for numeric data, including dates, as explained in SAS Note 20093.

This sort behavior means that dates on the horizontal axis are initially sorted in alphabetical order.

image label

To re-sort the values based on the underlying numeric values, right-click on the category data item (in this example, Date) and select Sort Ascending.

image label

In the following display, the re-sorted dates are now in chronological order.

image label



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report StudioMicrosoft Windows 2000 Advanced Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Professional3.19.1 TS1M3 SP4
Microsoft Windows NT Workstation3.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition3.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition3.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition3.19.1 TS1M3 SP4
Microsoft Windows XP Professional3.19.1 TS1M3 SP4
Windows Vista3.19.1 TS1M3 SP4
Windows Vista for x643.19.1 TS1M3 SP4
64-bit Enabled AIX3.19.1 TS1M3 SP4
64-bit Enabled Solaris3.19.1 TS1M3 SP4
HP-UX IPF3.19.1 TS1M3 SP4
* 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.