I have a dataset like this:
client_ID| open_date | close_date
abc123 | yyyy-mm-dd | yyyy-mm-dd
I wonder how I can plot in SAS VA a chart of number of opened and minus number of closed clients by years?
I'd created a couple of calculated items to show open and closed calls
IF ( 'close_date'n Missing ) RETURN 0 ELSE 1
then an aggregated measure
Sum [_ByGroup_] ('closed'n)
If you want open - closed would be something like
Sum [_ByGroup_] ('open'n) - Sum [_ByGroup_] ('closed'n)
Then use the aggregated measures in your chart object
Sorry, but I can't send you data. All I can tell is just that datatable consists of 3 columns: client_ID, open_date, close_date. Everyone has open-date but only someone has close date.
I need to show how many clients has opened and closed by year. It's very simple to do in Excel. But I'm creating a dashboard in SAS VA for web-site. I've tried to use barchart and count clients grouping by date, but such approach doesn't allow to put datasets on the same plot. I'm puzzled.
Have a look at how I set up the roles in my example, should give you that (unless I've missunderstood)
If year is a measure, duplicate it (right click on it) and set the new version as a category (another right click) to allow you to select it as the category (x-axis)
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.