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:
Need to have sorted as follows:
Thanks for any assistance with this problem!!
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;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.