topic Re: Advanced expression says valid but not working - date in New SAS User

Advanced expression says valid but not working - date

maliksmom2000 — Mon, 14 Jan 2019 12:31:54 GMT

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)

Re: Advanced expression says valid but not working - date

Kurt_Bremser — Mon, 14 Jan 2019 12:36:55 GMT

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-return-date/m-p/526875#M5168

Re: Advanced expression says valid but not working - date

maliksmom2000 — Mon, 14 Jan 2019 12:50:19 GMT

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

Re: Advanced expression says valid but not working - date

maliksmom2000 — Mon, 14 Jan 2019 13:29:55 GMT

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.

Re: Advanced expression says valid but not working - date

Kurt_Bremser — Mon, 14 Jan 2019 13:44:11 GMT

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.

Re: Advanced expression says valid but not working - date

maliksmom2000 — Mon, 14 Jan 2019 13:50:34 GMT

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!!!!!