topic Re: intck and date format in SAS Programming

intck and date format

Geo- — Thu, 23 Aug 2018 03:03:37 GMT

The format of column "log_date" is DATE9.

proc sql;

select * from tableA

where intck('dtday',log_date,'01apr2018'd) >=30;

run;

the code return no rows,why and how to fix?

thanks!

novinosrin — Thu, 23 Aug 2018 03:16:54 GMT

Is your log_date var character by any chance formatted with date9.?

And can you post your log message plz?

SASKiwi — Thu, 23 Aug 2018 03:20:06 GMT

You are using DTDAY which is a datetime interval not a DATE one. Use DAY instead.