topic Re: Sort month abbreviation in a line graph in SAS Web Report Studio

Sort month abbreviation in a line graph

deleted_user — Thu, 18 Nov 2010 11:55:45 GMT

Hi,

I have a WRS line graph with a measure on the y axis and months on the x-axis. However, the month category contains short names for months: JAN, FEB, MAR, etc. As a result, my x-axis values are sorted alphabetically.

In my report I have also a month number available for sorting, but I'm not allowed to put more than 1 object on the x-axis.

Can anyone tell me how to sort the months based on month number?

thnx!

Re: Sort month abbreviation in a line graph

AngelaHall — Thu, 18 Nov 2010 14:00:51 GMT

It sounds like the month column is actually a text field rather than a SAS date?
If you utilize a SAS date format, the sorting will be automatic. You also have the ability to choose from a multitude of formats. Included is the direct reference to format documentation (in SAS Base Language Dictionary: http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#a001263753.htm)

~ Angela

Re: Sort month abbreviation in a line graph

twocanbazza — Thu, 18 Nov 2010 19:09:58 GMT

Seen a SAS Note about this but couldn't find it but, below is a solution for a similar situation in a cross tab. You could create a format for you month number you have and use that variable.

Problem Note 38879: Months might not sort correctly in a crosstabulation table with a filter applied in SAS® Web Report Studio

http://support.sas.com/kb/38/879.html

Barry

Re: Sort month abbreviation in a line graph

deleted_user — Fri, 19 Nov 2010 09:42:09 GMT

Thankx for your help. Still one question: where do I apply that user defined format? I cant find it in Information Map studio or in Web Report Studio.

Re: Sort month abbreviation in a line graph

AngelaHall — Fri, 19 Nov 2010 15:26:07 GMT

Included is my blog post on how to make user-defined formats available to InfoMap Studio. http://sas-bi.blogspot.com/2010/01/using-custom-formats-in-information-map.html

~ Angela

Re: Sort month abbreviation in a line graph

deleted_user — Fri, 19 Nov 2010 15:39:19 GMT

thanks all. I have it working now..!