Current Date Proc SQL

[DavidPhillips2]

When I create tables in oracle I use sysdate() to set add a time stamp column, however this errors in proc SQL.  How can I add the current date in proc sql?

[jklaverstijn · Accepted solution]

Hi @DavidPhillips2,

In general you can use the SAS datastep functions (there are exceptions!). For the current date you have today(). If you want the date and time in one use datetime().

proc sql;
   select name, datetime() format=datetime22. 
   from sashelp.class;
quit;

[DavidPhillips2]

I knew I could use today in a datastep but was unaware I could use it in proc sql.  Thanks for the advice.