I keep getting warning messages from SAS when I execute the following query:
* update the start and end dates from _dates, if available;
update work.HospitalDischargeNew as new
set startDate = (
from work.HospitalizationNew_dates as dates
where dates.id = new.id )
where id in (
select id from work.HospitalizationNew_dates );
The message I keep getting is:
WARNING: A value expression of the SET clause references the data set being updated.
NOTE: 207 rows were updated in WORK.HOSPITALDISCHARGENEW.
So, the update clearly works. But how to write it differently to avoid the warning?
Thanks in advance,