Hi, all!
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
something like
IF ( 'close_date'n Missing ) RETURN 0 ELSE 1
then an aggregated measure
Sum [_ByGroup_] ('closed'n)
to aggregate
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
I need a graph like this. I've tried to group but it doesn't plot in one chart.
Can you post some sample data?
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.
Hi,
What goes on the Y axis? ClientID?
I have done a really quick exampe based on the formula I described above, mine looks like
Number of clients on Y-axis and years on X-axis.
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)
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.
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.