Number (with decimal) for time

[lalaktgrau]

Hi all,

I have a variable "DateTime" that looks like this 

04MAR14:01:04:00 

 with the DATETIME format. I want to create a variable with decimal numbers for just time. For example, for the time above, it would be 01.00067 such as (01.(04/60)). 

How do I go from SAS time to these numeric values?

[sidpesar]

%let date_time= "04MAR14:01:04:00" ;
%let time_format=0%sysevalf(%substr(&date_time,10,2)+%sysfunc(round(%sysevalf(%sysfunc(inputn(%substr(&date_time,13,2),2.))/60),.00001)));
%put &=time_format;

[FreelanceReinh · Accepted solution]

Hi @lalaktgrau,

Try this:

data want;
set have;
hours=timepart(datetime)/3600;
format hours z8.5;
run;

Note that your example ("01.00067") is incorrect.