topic Re: Formats & Informats in SAS Programming

Formats & Informats

aman23 — Fri, 22 Feb 2019 18:14:57 GMT

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 — Fri, 22 Feb 2019 18:22:28 GMT

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

Jagadishkatam — Fri, 22 Feb 2019 18:24:14 GMT

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

aman23 — Fri, 22 Feb 2019 18:36:25 GMT

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

novinosrin — Fri, 22 Feb 2019 18:39:12 GMT

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

aman23 — Fri, 22 Feb 2019 18:42:14 GMT

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 — Fri, 22 Feb 2019 18:46:55 GMT

aman23 — Fri, 22 Feb 2019 18:51:20 GMT

Yeah thanks a lot (Y)

thats solves my problem 🙂