Hi, My Sas package is Foundation My sas version is : NOTE: SAS (r) Proprietary Software 9.3 (TS1M1) My Sas platform is : NOTE: This session is executing on the W32_ES08R2 platform. Since my code next is similar to my first post, the error mesages appear (see color text) There is another warning produced which is due to the source and output dataset being the same (i can easily avoid this one) data devtmp.help_class; attrib count_gender length = 3; set sashelp.class; count_gender = 0; run; proc sql UNDO_POLICY=OPTIONAL; update devtmp.help_class AS a set count_gender = (select b.count_gender from (select name, count(sex) AS count_gender from devtmp.help_class group by sex) AS b where a.name = b.name); quit; 190 proc sql UNDO_POLICY=OPTIONAL; 191 update devtmp.help_class AS a 192 set count_gender = (select b.count_gender 193 from (select name, count(sex) AS count_gender 194 from devtmp.help_class 195 group by sex) AS b 196 where a.name = b.name); WARNING: A value expression of the SET clause references the data set being updated. NOTE: The query requires remerging summary statistics back with the original data. WARNING: The SQL option UNDO_POLICY=REQUIRED is not in effect. If an error is detected when processing this UPDATE statement, that error will not cause the entire statement to fail. NOTE: 19 rows were updated in DEVTMP.HELP_CLASS. 197 quit;
... View more