BookmarkSubscribeRSS Feed
sbxvab
SAS Employee
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
2 REPLIES 2
Florent
Quartz | Level 8
Hi Valérie,

Could you please check whether the following code match your expectations ? 🙂

I hope it helps !

Kind regards,
Florent

proc sql noprint;
update decava.person a
set death_date = (select iden_mortaldate
from ident_sel_1
where iden_inss = a.social_security_nr),
smals_last_update_date = (select iden_lastupdt_datetime
from ident_sel_1
where iden_inss = a.social_security_nr)
where a.social_security_nr in (select iden_inss
from ident_sel_1)
;
quit;
Vasile01
Fluorite | Level 6
Hi Valérie,

I tested your code (excluding those supplementary where conditions) on SAS datasets and it seems to work fine. I would say you'd better and faster try to ask a question to SAS technical support about that.

Warm regards,
Vasile

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1453 views
  • 0 likes
  • 3 in conversation