Advanced expression says valid but not working - date

[maliksmom2000]

I am trying to bring over a date only if it fits the between parameters - it says valid but it is not working

ifn(t1.ADDNM122016 is missing AND t1.IM_REM_DT>= 01/01/2016 AND t1.IM_REM_DT<=1/12/2019, t1.IM_REM_DT, t1.ADDNM122016)

[Kurt_Bremser · Accepted solution]

01/01/2016 is not a date, but a formula that calculates 1 divided by 1 divided by 2016.

I already explained date literals in https://communities.sas.com/t5/New-SAS-User/numeric-advanced-expression-sas-enterprise-need-to-retur...

[maliksmom2000]

I'm sorry, 9 hours straight I think it getting to me   Thank you so much it worked!

[maliksmom2000]

It worked on a different formula but not this one.  What am I missing?  I AM SO SORRY!!!!

4 PROC SQL NOEXEC;
5 SELECT (ifn(t1.ADDNM122016 is missing AND t1.IM_REM_DT >= “01JAN2016”d AND t1.IM_REM_DT <= ”01JAN2019”d,
_ _
22 22
200 200
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, (, +, -, ALL, ANY, BTRIM, CALCULATED, CASE, INPUT, PUT, SELECT, SOME, SUBSTRING, TRANSLATE, USER.

[Kurt_Bremser]

Your code has "slanted" quotes, these UTF symbols are illegal in code. Use ONLY the internal SAS editors, or pure text editors suited for programming. Word Processors like MS Word are poison for code, as they tend to automatically do "intelligent" formatting.

[maliksmom2000]

Oh WOW thank you so much.  I had copied the code to WORD so I could copy it and use it again.  I will always retype them.  Thank you so much.  Has anyone ever told you how brilliant and helpful you are?  If not I AM!!!!!