There is no SQL function named TRUNC(). There is one that Oracle has created that you can use in SQL code to run in an Oracle database. Try using INTNX() function instead.
intnx('dtqtr',t_eff.term_begin_dt,0)
Example:
1677 data test;
1678 now=datetime();
1679 want=intnx('dtqtr',now,0) ;
1680 format _all_ datetime19.;
1681 put (_all_) (=);
1682 run;
now=21FEB2019:12:40:35 want=01JAN2019:00:00:00
Or just use PUT() with appropriate format.
put(a.item_effective_dt,dtyyqc6.) = put(t_eff.term_begin_dt, dtyyqc6.)
... View more