topic Number (with decimal) for time in SAS Programming

Number (with decimal) for time

lalaktgrau — Mon, 15 Oct 2018 19:50:47 GMT

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?

Re: Number (with decimal) for time

sidpesar — Mon, 15 Oct 2018 20:13:22 GMT

%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;

Re: Number (with decimal) for time

FreelanceReinh — Mon, 15 Oct 2018 20:35:23 GMT

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.