topic >= current in SAS Procedures

>= current

tmm — Tue, 06 Mar 2012 17:27:30 GMT

I have to create my query so that my date is >= today and I have

market_row_eff_dt >= not sure what to put in???

>= current

ballardw — Tue, 06 Mar 2012 17:43:26 GMT

you may be looking for: Date() which returns the current date. BUT your variable name ending in DT makes me think you are actually comparing a DATETIME value, not a date. if that is the case you may be looking for DATEPART(market_row_eff_dt) ge Date().

>= current

tmm — Tue, 06 Mar 2012 17:46:41 GMT

So in my proc sql code I have

proc_cd in (&ortho)

and

datepart(market_row_eff_dt) >= date()

???

I cannot use get in the SQL statement

>= current

tmm — Tue, 06 Mar 2012 19:07:18 GMT

I cannot get this to work within my proc sql code. I put a bit below of what I have.

>= current

sassharp — Tue, 06 Mar 2012 19:12:04 GMT

makesure both datepart(market_row_eff_dt),

date() should be in same format. otherwise you get error.

>= current

Tom — Tue, 06 Mar 2012 19:20:37 GMT

You can use DATE() to get today's date and DATETIME() to get the current time as a datetime value.

You can also use &SYSDATE9 to get the date that the program session started. and &SYSTIME to get the time it started.

You can specify a date literal in SAS by using quoted string followed by the letter d. Use the date. format. For example today is
"06MAR2012"d

For datetime use dt as the suffix. "01MAR2012:14:18"dt

You can use %SYSFUNC to let you call DATE() and generate the string.

"%sysfunc(date(),date9.)"d

Are you referencing an external database? or just referencing SAS datasets? Different databases will have different ways of storing dates (datetime versus date only for example) and specifying a specific date (does it use ddMMMyyyy format like SAS or does it want YYYYMMDD or some other format.)

>= current

tmm — Wed, 07 Mar 2012 14:31:43 GMT

well this is my fix

market_row_eff_dt >= current date

no () no ' just current date typed as u see and a space between. how odd. guess that is how DB2 handles it

>= current

art297 — Wed, 07 Mar 2012 14:44:25 GMT

Not odd. That is how DB2 specifies it. Take a look at: http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html

>= current

ballardw — Wed, 07 Mar 2012 16:13:36 GMT

And you never bothered to let us know you were reading DB2 files. All of the above solutions work on SAS datasets.