Hi, When I run this query in the SQL environment, it worked ... but when I embed this into proc sql, I keep getting the error message "Function TRUNC requires a numeric expression as argument 2." Is there a workaround for this? Thanks in advance for your help! proc sql; create table tst as SELECT common_id, item_type, item_amt, CASE WHEN a.item_term < '2' AND a.item_term <> ' ' THEN a.item_term WHEN bill.cu_bill_term IS NOT NULL THEN t_bill.strm WHEN t_due.strm IS NOT NULL THEN t_due.strm ELSE t_eff.strm END AS item_term FROM hcs.ps_item_sf a left join hcs.ps_cu_bill_line bill ON bill.emplid = a.common_id AND bill.cu_bill_term = a.item_term left join hcs.ps_term_tbl t_bill ON t_bill.acad_career = 'GRAD' AND Trunc(bill.start_dt, 'Q') = Trunc(t_bill.term_begin_dt, 'Q') left join hcs.ps_term_tbl t_due ON t_due.acad_career = 'GRAD' AND Trunc(a.due_dt, 'Q') = Trunc(t_due.term_begin_dt, 'Q') left join hcs.ps_term_tbl t_eff ON t_eff.acad_career = 'GRAD' AND Trunc(a.item_effective_dt, 'Q') = Trunc(t_eff.term_begin_dt, 'Q') ; quit;
... View more