Writing current date and time with PROCSQL;

[tom12122]

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]

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;