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

Time on Y axis in proper format

Reply
Occasional Contributor
Posts: 9

Time on Y axis in proper format

[ Edited ]

Hi, 

 

I would like to bulid a timeseries plot in VA.

On x axis should be variable in date format which is absolutely fine and is visible on plot presented below. However, I have faced the problem with Y axis, where I would like present time which correspond to particular date. I can only show that as numeric (number of seconds from midnight). I fully understand that it should be in numeric to put value on plot, but is there any way to present those data as time format on vizualization?

 

va_timeseries.png

 

Thank you very much for your help.

 

Best Regards,

Hubert

Super User
Posts: 13,941

Re: Time on Y axis in proper format

[ Edited ]

Does that y value of 371646 actually correspond to 103:14:06 (hours:minutes:seconds) ?

 

If so, can you assign a time10. format to the y variable?

 

Note that this blog

https://blogs.sas.com/content/sgf/2016/03/22/making-best-use-of-date-formats-in-visual-analytics-des...

 

shows using and "elapsed time" role and a time8. format. I suspect you may need more of a time10. OR a custom format. But if the value is actually seconds no transform or applied function should be needed.

Ask a Question
Discussion stats
  • 1 reply
  • 49 views
  • 0 likes
  • 2 in conversation