|
Hi everyone,
I keep getting warning messages from SAS when I execute the following query:
-------
* update the start and end dates from _dates, if available;
proc sql;
update work.HospitalDischargeNew as new
set startDate = (
select startDate
from work.HospitalizationNew_dates as dates
where dates.id = new.id )
where id in (
select id from work.HospitalizationNew_dates );
quit;
-------
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,
Kent
| 
