topic Date not sorting correctly on report in SAS Web Report Studio

Date not sorting correctly on report

ncsthbell — Tue, 25 Oct 2011 18:30:59 GMT

I have a report that I am trying to sort the detail by a date column in ascending order. The date is showing as a 'measure' coming from the information map. I created the SAS datasets in EG 4.2 and passed into the Information map that feeds this report. The date shows as a data type of 'date' in the table. I am doing a right click on the column name header on the report for this date solumn and selecting to sort ascending. The data seems to be ordering in a character format rather than date format. I am pretty new to SAS, so I am sure I am just missing something!!

Example of my data:

03/31/2006

03/31/2007

06/30/2006

06/30/2007

09/30/2006

09/30/2007

Need to have sorted as follows:

03/31/2006

06/30/2006

09/30/2006

03/31/2007

06/30/2007

09/30/2007

Thanks for any assistance with this problem!!

Date not sorting correctly on report

Tom — Tue, 25 Oct 2011 22:56:15 GMT

I know nothing about Web Report Studio, but if you are using PROC REPORT then it has a "friendly" feature of sorting even numeric variables by the character string used to display then unless you tell it otherwise by using ORDER=INTERNAL option in addtion to the ORDER option.

define mydate / order order=internal;

Date not sorting correctly on report

twocanbazza — Wed, 26 Oct 2011 19:55:21 GMT

Have you searched the SAS web for say "WRS Date Sort order"? There are a couple of SAS Notes, while not exactly the same, may shed som light on your issue.

Barry

Date not sorting correctly on report

art297 — Wed, 26 Oct 2011 20:10:12 GMT

I'm not familiar with WRS but, from what you show and the documentation, it appears that you might have identified month as a break variable and it is sorting on dates within months.

Date not sorting correctly on report

sks — Mon, 07 Nov 2011 14:53:25 GMT

In the information map, you can set the format for the date field. I wonder if the issue is because the date field is showing up as a measure, can you change it to a category and see if data is sorted correctly.

Shri