Formats & Informats

[aman23]

How to print below date in SAS and then extract date & time part in different variables from the same date??

22Feb2019 11:44:00 PM

[novinosrin]

is your datetime variable numeric i.e number of seconds from Jan 1,1960  that is formatted in that fashion or character?

[aman23]

It is numeric, say you are fetching it using datetime() function for the current date & time.

[novinosrin]

Well I think @Jagadishkatam  's demo does just that. Let us know if you need more

[Jagadishkatam]

data want;
dt='22Feb2019 11:44:00 PM'dt;
date=datepart(dt);
time=timepart(dt);
format dt datetime20. date date9. time time5.;
run;

[aman23]

is there any format to print the both datetime & time in below format??

datetime:- 22Feb2019 11:44:00 PM

time:- 11:44:00 PM

[novinosrin]

@aman23 

This format http://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#p01glghg80jh...

?

[aman23]

Yeah thanks a lot (Y) 

thats solves my problem 🙂