Hello Experts,
I would like to replace the . value using the case statement, but it doesn't work, I have the 01/01/1960 in the place of . value.
My code is :
proc sql;
create table Donnees as
select c.cd_rga
, b.is_support
, c.lb_court
, b.d_fin
, a.mt_ea,
, sum(a.mt_ea) as total
from SUPPORT as a
left join (select is_support,
case d_fin when . then d_fin="31DEC2023"d else d_fin
end as d_fin format ddmmyy10.
from RGA
group by is_support
having
or max(b.d_fin) = b.d_fin) as b
on a.is_support = b.is_support
left join RGPC as c
on b.is_rga=c.is_rga
where a.s_type_support="OK"
group by c.cd_rga
;
quit;
Thank you for your help !
... View more