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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.