Try some thing like this data trials1; input id deptcode $ salary; datalines; 1001 FRM 23000 1002 GMM 45090 1003 DFG 23480 1004 TTM 34200 1005 DEE 34000 1006 FRM 45000 1007 GMM 34700 1008 DFG 43000 1009 DFG 23000 run; proc sql; create table want as select * from trials1 group by deptcode having count(deptcode)=2 order by id; quit; run;
... View more