BookmarkSubscribeRSS Feed
BAdams
Calcite | Level 5

I used the built in SAS time dimension to define a date field.  Looking at the results in WRS you can see that the quarters are not sorted in the correct order, nor are the months within the first quarter. Has anyone seen this before and more importantly, how can I correct it?  Thanks.   Below is how the data is showing up in WRS.


date sort error.jpg

4 REPLIES 4
Tobin_Scroggins
Calcite | Level 5

I have had this issue with using quarters. Don't have an answer for you but am hoping that someone does.

GCCarno
Calcite | Level 5

I am having a similar issue. Try following this guide, if you are successful, let me know.

http://support.sas.com/kb/19/651.html

muralavenu_gmail_com
Obsidian | Level 7

Hi There,

 

This is very easy and you need to Edit the Cube.  Before editing the Cube you should close the WRS Report, if you select this Cube as a source in this report.

 

1. Right Click on the Cube - Select Edit Structuture - Click on NextClick on Next - Select the Dimension - Click on Modify -  Click on Next - Select the Level(Variable) - Click on Sort Order - Select Dataset Order - Click on NextClick on Finish - Click on Finish.

 

NOTE:  In your screen shot, 2nd and 3rd Levels\Variables are not in Sort Order.  So you need to Select Dataset Order for BOTH Variables.  Now Try to open the saved report in WRS and check.  

 

For Detailed information, find the attached .zip - VIDEO & Screen Shot for your reference.

 

Thanks & Regards,

Venu Murala  | Sr. SAS Consultant.

Venu Murala
ashu464810
Calcite | Level 5

@muralavenu_gmail_com I tried the approach you mentioned  but the date is not gettting sorted. 

Your views are welcome.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1976 views
  • 0 likes
  • 5 in conversation