topic Re: Same salary in emp table using Datastep in SAS Programming

Same salary in emp table using Datastep

BrahmanandaRao — Sat, 03 Apr 2021 05:51:23 GMT

data emp;
input Name$ Station Salary;
datalines;
Bob    1      2000  
Steve  2      1750  
Mark   3      2050  
Lisa   4      2200  
Hans   5      2000  
;
run;



proc sql;
select * from emp e1, emp e2
where e1.Salary =e2.Salary and e1.name ne e2.name	;
quit;

/*OR*/
proc sql;
select * from emp 
where salary in (select salary from emp group by salary 
                 having count(*)>1);
quit;

Get same salary using Datastep

Re: Same salary in emp table using Datastep

Patrick — Sat, 03 Apr 2021 06:18:07 GMT

The great thing is that you've got both SQL and the SAS data step which gives you a choice.

For the data step to work the data needs to be sorted by salary.

proc sort data=emp;
  by salary;
run;

data want;
  set emp;
  by salary;
  if not (first.salary and last.salary);
run;