例如proc sql;create table lc.a asselect * from lc.b where database||subname||ShopAdd inselect distinct database||subname||ShopAdd from lc.b where subname^='无' group by database||subname||ShopAddhaving count(database)>1;quit;