Your code is just doing the "remerging" explicitely. Not sure why you care about the message if that is the result that you want. Are you asking how to recode your SQL statement to get the same results without the message? Here is one method using a corralated sub-query. data have ; input state $ region $ codes items $ ; cards; a x 123 Abc a x 345 Abc b y 567 Zab run; proc sql noprint ; create table method1 as select distinct a.*,count(codes) as codecount from have a group by a.state,a.region ; create table method2 as select distinct a.* ,(select distinct count(b.codes) from have b where a.state=b.state and a.region=b.region ) as codecount from have a order by a.state,a.region ; quit; proc compare data=method1 compare=method2; run;
... View more