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
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
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
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
Hi,
See the output I am getting it is not rounding off...after running the same code(sas 9.2 version)
Thanks,
Shiva
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
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;
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.