My dataset looks like the following:
I have calculated in VA the cumulative period of ValueYear and ValueYear-1.
I want to plot this so I can easily compare this year, with the previous year.
If you derive the year out of the dates (new calculated item), you can use this field in a bar-graph to stick the two bar together and compare them.
While changing the date format to monthday, you can create your barlabels with these in relation to the created year field.
If needed, I could prepare a sample for you.
I'm trying to create the dateformat to monthday. Can I still have it like a datevariable?
I tried to calculate it and put in a character format but then the sorting is not correct anymore.
If you want, you can show me a sample.
Here is a sample of my data:
You are right that this is not possible in one crosstable. (Date format can not be changed in the way you/I want).
I am not shure about version 7 (I get it next month) but I Know there is a development request making the YTD not only depending on dates)
Lets see if it is in a next release.
For now, only option would be to put two tables besides each other if your dates are running equal in VA. ( As far as I can see now.)
Other option is to prefix the data....
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.