topic Re: converting datetime to date9. in SAS Procedures

converting datetime to date9.

sasthebest — Mon, 22 Jul 2013 05:09:24 GMT

I used format = date9. to convert datetime to date9. but it doesn't work in an SQL statement. Any help?

Scott_Mitchell — Mon, 22 Jul 2013 05:17:53 GMT

DATA HAVE;

ATTRIB DATETIME1 FORMAT=DATETIME12.;

DATETIME1 = DHMS(TODAY(),12,15,0);

RUN;

PROC SQL;

CREATE TABLE WANT AS

SELECT DATEPART(DATETIME1) AS DATE1 FORMAT = DATE9.

FROM HAVE;

RUN;

Peter_C — Mon, 22 Jul 2013 06:20:52 GMT

Alrernatively

DTDATE9.

presents dateime values in date9. style