topic SAS VA : Creating graph in SAS Visual Analytics

SAS VA : Creating graph

AbhiD — Tue, 24 Nov 2015 03:54:36 GMT

Hi,

I want to create a graph which will be represent average landing times for files, i have a dataset which contains data for each file as below

Module FileName LandingTime

A A_F1.csv 22:00:05

A A_F2.csv 01:15:37

B B_F1.csv 11:13:05

B B_F2.csv 11:40:34

i wish to have a line graph which will represent the Modules on X-axis whereas the Average Landing times for each module on Y-Axis

I tried to do the same but VA graph does not allow to add the LandingTime as a measure.

Please advice.

Rgds,
AbhiD

PeterWijers — Tue, 24 Nov 2015 06:22:11 GMT

Hi Abhi,

I would advice you to start using Industry hours definition. (Almost a standard in industry time registration)

This means that you recalculate the time into a number that can be summed.

Example 1:15:37 would be 1.00 hour + 15/60 minutes fraction --> 1.2500000 (Leaving seconds out.)

11:13:05 --> 11.216666

Now you have a number that can be summed, averaged etc.

This should also fit into a graph showing the average using a aggregated measure.

Maybe this works out.

greetings Peter

AbhiD — Tue, 24 Nov 2015 06:48:55 GMT

Thanks Peter,

will check if that works for me

Rgds,

AbhiD