Dear all,
Do you know whether it is possible to update conditionnally 2 fields in the same sql update statement ?
This kind of synthax gives an error :
proc sql &statusql noprint;
update decava.person
set death_date = (select iden_mortaldate from
ident_sel_1 where ident_sel_1.iden_inss = person.social_security_nr) where exists ( select iden_mortaldate from ident_sel_1
where ident_sel_1.iden_inss = person.social_security_nr) ,
smals_last_update_date = (select iden_lastupdt_datetime from
ident_sel_1 where ident_sel_1.iden_inss = person.social_security_nr)
where exists ( select iden_lastupdt_datetime from ident_sel_1
where ident_sel_1.iden_inss = person.social_security_nr)
;
quit;
Without the where exists statements, an ORACLE error occurs.
Any idea is welcome.
Valérie