topic Writing current date and time with PROCSQL; in SAS Procedures

Writing current date and time with PROCSQL;

tom12122 — Wed, 21 Mar 2012 16:21:24 GMT

Hi,

I need to write current sysdate and systime with PROC SQL. How should I format dates to fit DATETIME19.2 format in table?

Linlin — Thu, 22 Mar 2012 00:31:24 GMT

Is this what you want?

data have;

input id age;

cards;

1 20

2 30

;

run;

proc sql;

select *,datetime() format=datetime19.2 as time

from have;

quit;