Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA Plot inputs and outputs chart

Reply
New Contributor
Posts: 4

SAS VA Plot inputs and outputs chart

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?

 

Frequent Contributor
Posts: 131

Re: SAS VA Plot inputs and outputs chart

Posted in reply to Cat_No_Sova

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

New Contributor
Posts: 4

Re: SAS VA Plot inputs and outputs chart

Posted in reply to itchyeyeballs

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

Frequent Contributor
Posts: 131

Re: SAS VA Plot inputs and outputs chart

Posted in reply to Cat_No_Sova

Can you post some sample data?

New Contributor
Posts: 4

Re: SAS VA Plot inputs and outputs chart

Posted in reply to itchyeyeballs

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.

Frequent Contributor
Posts: 131

Re: SAS VA Plot inputs and outputs chart

Posted in reply to Cat_No_Sova

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

 

Capture.GIF

New Contributor
Posts: 4

Re: SAS VA Plot inputs and outputs chart

Posted in reply to itchyeyeballs

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

Frequent Contributor
Posts: 131

Re: SAS VA Plot inputs and outputs chart

Posted in reply to Cat_No_Sova

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)

 

 

Ask a Question
Discussion stats
  • 7 replies
  • 223 views
  • 0 likes
  • 2 in conversation