Reg:Time Part

[My_SAS]

23june2012 11:12:34:45

I am ahving a char variable i want the date time with nano secs in one variable and date in another variable

output

date                                  time
23june2012                11:12:34:45

[My_SAS]

sorry the data is like this with nano seconds also

2012-07-11 09:43:20:45

output

date                       time

2012-07-11              09:43:20:45

[shivas]

Hi,

Try this...

data have;

input date ymddttm24.;

dt=datepart(date);

tm=timepart(date);

format dt date9.;

format tm time12.2;

cards;

2012-07-11 09:43:20.45

;

run;

Thanks,

Shiva

[My_SAS]

Antoher Req

2012-07-11 09:43:20.52

in this i want the time till sec but it was rounding off

output shd be 09:43:20

but converting to 09:43:21

[shivas]

Hi,

See the output I am getting it is not rounding off...after running the same code(sas 9.2 version)

Thanks,

Shiva

[My_SAS]

SORY I AM SAYING ABOUT SECONDS NOT MILL SECONDS ACTUALLY I WANT UP TO SECONDS NOT MILLI SECONDS AS IT WAS ROUNDING MY LAST MILLI SECOND TO SEC

09:43:20.52

I WANT THE OUTPUT BE   09:43:20

BUT IT WAS CONVERTING TO  09:43:21

PL HELP ME IN THIS

[shivas]

Hi,

Try this..

data have;

input date ymddttm.;

dt=datepart(date);

tm=timepart(date);

format dt date9.;

format tm time8.2;

cards;

2012-07-11 09:43:20.45

2012-07-11 09:53:20.52

;

run;

[Ksharp]

Or truncate it firstly.

data have;
input char_date & $40.;
date=input(substrn(char_date,1,findc(char_date,'.')-1), ymddttm.);
dt=datepart(date);
tm=timepart(date);
format  dt date9. date datetime.;
format tm time.;
cards;
2012-07-11 09:43:20.45
2012-07-11 09:53:20.52
;

run;

Ksharp