topic Re: Current Date Proc SQL in SAS Programming

Current Date Proc SQL

DavidPhillips2 — Thu, 02 Jun 2016 13:29:49 GMT

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?

Re: Current Date Proc SQL

jklaverstijn — Thu, 02 Jun 2016 13:45:54 GMT

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;

Re: Current Date Proc SQL

DavidPhillips2 — Thu, 02 Jun 2016 13:47:09 GMT

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