topic Re: handle missing date in proc sql in SAS Procedures

handle missing date in proc sql

podarum — Mon, 11 May 2015 01:23:30 GMT

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 '.'.

Re: handle missing date in proc sql

SASKiwi — Mon, 11 May 2015 02:03:30 GMT

Try: LN2.close_reason in ('AB','AM','AO','AC','AR') and ln_close_dt is not NULL

Re: handle missing date in proc sql

jakarman — Mon, 11 May 2015 04:54:27 GMT

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.