topic Re: enter sysdate in proc sql in SAS Programming

enter sysdate in proc sql

dash — Thu, 30 Aug 2012 13:46:27 GMT

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

Re: enter sysdate in proc sql

Linlin — Thu, 30 Aug 2012 14:03:10 GMT

You could use today():

proc sql;

select sales_date format=mmddyy10.

from sales

where sales_date>today();

quit;

Re: enter sysdate in proc sql

DanielSantos — Thu, 30 Aug 2012 14:17:18 GMT

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.

Re: enter sysdate in proc sql

Haikuo — Thu, 30 Aug 2012 14:21:40 GMT

Or date().

Haikuo

Re: enter sysdate in proc sql

Astounding — Thu, 30 Aug 2012 14:26:37 GMT

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.

Re: enter sysdate in proc sql

dash — Thu, 30 Aug 2012 14:32:45 GMT

Thanks linin for your great help