topic Re: How to concatenate string and declare as date constant in SAS Enterprise Guide

How to concatenate string and declare as date constant

kgflynn — Wed, 16 Aug 2017 12:04:34 GMT

Is this possible to do in Enterprise Guide filter? I usually do a date compare in a filter like this that works fine:

datepart(exit_date) >= '15Aug2017'd

However I would like the to set it up so the year is dynamic, something like:

'15Aug' || PUT(YEAR(Date()-181), 4.)

This code produces the correct character format I want 15Aug2017, but I can't just put a 'd' at the end to assign it as date constant for comparison. Any suggestions would be much appreciated. Thanks, Kenny.

EG 6.1

SAS 9.4

Re: How to concatenate string and declare as date constant

Kurt_Bremser — Wed, 16 Aug 2017 12:11:02 GMT

Use the input() function to convert the string to a date:

datepart(exit_date) >= input('15Aug' || PUT(YEAR(Date()-181), 4.),date9.)

Or use the intnx() function to do date calculations:

datepart(exit_date) >= intnx('year','15Aug2017'd,-181,'s');

Re: How to concatenate string and declare as date constant

kgflynn — Wed, 16 Aug 2017 13:25:46 GMT

Thanks! That works perfectly.