Extraction of timepart from datetime

Revathi — Wed, 14 Sep 2016 10:21:16 GMT

Hi,

I want to extarct timestamp (Time_var) from sas Date_time. The format of datetime is 11-07-2015 11:46:02

So, I used the following code which is not working. I doubt that the space between the date and time is causing the error.

Time_var=timepart(Date_time);

Re: Extraction of timepart from datetime

Kurt_Bremser — Wed, 14 Sep 2016 10:45:49 GMT

The timepart() function extracts the time from a SAS datetime value, which must be a number containing the seconds starting at 01jan1960:00:00:00.

If your date_time is of type character, this won't work.

You must convert first:

data _null_;
x1 = '11-07-2015 11:46:02';
x2 = input(x1,anydtdtm19.);
x3 = timepart(x2);
format x2 datetime19. x3 time8.;
put _all_;
run;

Log:

16         data _null_;
17         x1 = '11-07-2015 11:46:02';
18         x2 = input(x1,anydtdtm19.);
19         x3 = timepart(x2);
20         format x2 datetime19. x3 time8.;
21         put _all_;
22         run;

x1=11-07-2015 11:46:02 x2=11JUL2015:11:46:02 x3=11:46:02 _ERROR_=0 _N_=1

topic Extraction of timepart from datetime in SAS Programming

Extraction of timepart from datetime

Re: Extraction of timepart from datetime