I'm not sure if there is somehting wrong with the code, but I need to omit if date is missing. I am using this code, and getting an error.
((LN2.close_reason in 'AB','AM','AO','AC','AR') and ln_close_dt ne .)
ERROR: Teradata prepare: Syntax error: expected something between 'ne' and '.'.
Try: LN2.close_reason in ('AB','AM','AO','AC','AR') and ln_close_dt is not NULL
Teradata is a RDBMS conforming SQL approaches. The missing approach doesn't exist instead there is a 3 value logic Three-valued logic - Wikipedia, the free encyclopedia
The NULL is logically not the same as the SAS missing although they are technically mapped. The NULL value is an indicator the field is technically missing caused by eg joins.
Dates within Teradata are stored in a different format. They are stored in binary format but are not as a continues flow (day after day) instead they are using the readable decimal numbers after a conversion for that.
That is making working with dates using Teradata/SAS intergration very surprising. It is not the same as you were working in a only SAS environment.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.