SAS VA Plot inputs and outputs chart

[Cat_No_Sova]

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?

[itchyeyeballs]

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

[Cat_No_Sova]

I need a graph like this. I've tried to group but it doesn't plot in one chart.

[itchyeyeballs]

Can you post some sample data?

[Cat_No_Sova]

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.

[itchyeyeballs]

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

[Cat_No_Sova]

Number of clients on Y-axis and years on X-axis.

[itchyeyeballs]

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)