BookmarkSubscribeRSS Feed
Kamohelo
Fluorite | Level 6

Hi 

 

I would like to get the following values into SAS VA using elapsed time formatting:

Kamohelo_0-1628678731597.png

 

However, I am getting this results within SAS VA:

 

Kamohelo_1-1628678847148.png

 

Is it possible to get the time values as shown on the 1st screenshot?

 

Regards

2 REPLIES 2
jimbarbour
Meteorite | Level 14

What is the source of the elapsed times? 

 

Are you getting it from outside SAS?  If it's from outside SAS (Excel for example), the representation can be different and a conversion is necessary.  Again using Excel as an example, Excel bases everything off of Jan 1, 1900.  SAS, on the other hand, bases everything off of Jan 1, 1960.  Excel date-times will appear to be far in the future in SAS if not converted.

 

Inside SAS, normally one just subtracts the ending date-time value from the starting date-time value.  I typically use the format TIME13.2 with elapsed times.

 

As an example:

%LET	Start_Datetime	=	%SYSFUNC(INPUTN('07sep2018:23:00:00'dt, DATETIME18.));
%LET	End_DateTime	=	%SYSFUNC(INPUTN('08sep2018:01:00:00'dt, DATETIME18.));
%PUT	%SYSFUNC(COMPRESS(%SYSFUNC(PUTN(%SYSEVALF(&End_DateTime - &Start_DateTime),	TIME13.2))));

Results in:

2:00:00.00

Indicating that 2 hours, 0 minutes, and 0 seconds have elapsed.

 

Jim

Sam_SAS
SAS Employee

Just to rule something out-- I know the column name is "Average time to completion", but can you check that the aggregation on the column is set to Average?

 

Thanks,

Sam

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 1232 views
  • 0 likes
  • 3 in conversation