Yes, Hooked from the test script, thanks for the remark. But this does not solve the mistake. And it doesn't work for me with and without datepart() ... View more

I understand it is necessary to convert CONTRACT_BEGINDATE (2021-01-14 00:00: 00.000) to format SAS, I think it would help ... View more

Full log: The SAS System memory 265.37k OS Memory 29476.00k Timestamp 18.05.2021 09:54:45 Page Faults 0 Page Reclaims 136 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 MLOGIC(MEQUIBEHSCOREUPRE): %PUT mvNow= &mvNow SYMBOLGEN: Macro variable MVNOW resolves to 1936950885.51 mvNow= 1936950885.51 MPRINT(MEQUIBEHSCOREUPRE): proc sql; SYMBOLGEN: Macro variable T_CLIENT_ID resolves to 00000031-B081-4E97-9437-F20CF874F857 SYMBOLGEN: Macro variable MVNOW resolves to 1936950885.51 MPRINT(MEQUIBEHSCOREUPRE): select COALESCE(sum(abc.step_sum),0) into :SumLoans_12m from RTDM_ABT.ABT_CONTRACT abc where abc.CLIENT_ID = "00000031-B081-4E97-9437-F20CF874F857" and 1936950885.51 - abc.CONTRACT_BEGINDATE <= (365*24*60*60) and abc.DML_FLAG NE 1 group by abc.CLIENT_ID; 163677 1621320885 no_name 0 SQL (469 SQLSRV_37146: Prepared: on connection 0 163678 1621320885 no_name 0 SQL (469 SELECT * FROM rtdm_abt . ABT_CONTRACT 163679 1621320885 no_name 0 SQL (469 163680 1621320885 no_name 0 SQL (469 SAS_SQL: Failed to get a DBMS-specific datetime value. 163681 1621320885 no_name 0 SQL (469 SAS_SQL: Unable to convert the query to a DBMS specific SQL statement due to an error. 163682 1621320885 no_name 0 SQL (469 ACCESS ENGINE: SQL statement was not passed to the DBMS, SAS will do the processing. 163683 1621320885 no_name 0 SQL (469 163684 1621320885 no_name 0 SQL (469 SQLSRV_37147: Prepared: on connection 0 163685 1621320885 no_name 0 SQL (469 SELECT STEP_SUM , CLIENT_ID , CONTRACT_BEGINDATE , DML_FLAG FROM rtdm_abt . ABT_CONTRACT WHERE ( ( CLIENT_ID = '00000031-B081-4E97-9437-F20CF874F857' ) AND ( DML_FLAG <> 1 ) ) 163686 1621320885 no_name 0 SQL (469 163687 1621320885 no_name 0 SQL (469 163688 1621320885 no_name 0 SQL (469 SQLSRV_37148: Executed: on connection 0 163689 1621320885 no_name 0 SQL (469 Prepared statement SQLSRV_37147 163690 1621320885 no_name 0 SQL (469 163691 1621320885 no_name 0 SQL (469 NOTE: No rows were selected. MPRINT(MEQUIBEHSCOREUPRE): quit; ... View more

CONTRACT_BEGINDATE  ( 2021-01-14 00:00:00.000 ) ... View more

Errors: SAS_SQL: Failed to get a DBMS-specific datetime value. 163681 1621320885 no_name 0 SQL (469 SAS_SQL: Unable to convert the query to a DBMS specific SQL statement due to an error. 163682 ... View more

I also had such an assumption and it was confirmed, after deleting this line, the code works, but how to make this script work with this line is not yet clear to me. 🤔 ... View more