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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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