enter sysdate in proc sql

[dash]

Hi,

I want to check whether sales date is greater than current date or not. How can I do

I have written using oracle sqlra

select sales_date, sysdate from sales

where sales_date >sysdate

How to write in sas

[Linlin · Accepted solution]

You could use today():

proc sql;

  select sales_date format=mmddyy10.

    from sales

  where sales_date>today();

quit;

[dash]

Thanks linin for your great help

[DanielSantos]

Right.

Or use the system macro variable &SYSDATE9.

where sales_date > "&SYSDATE9"d;

which may return a different value from the TODAY() function, since it contains the date that the SAS job/session began executing.

TODAY function will return the actual date.

More on TODAY function here:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245961.htm

And SYSDATE9 here:

http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a000489470.htm

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

[Haikuo]

Or date().

Haikuo

[Astounding]

Just curious ... do we know for sure that SALES_DATE is actually a date rather than a datetime?  After all, this data appears to be coming from Oracle.