DATA Step, Macro, Functions and more

Proc sql finding Max value

Reply
Contributor
Posts: 34

Proc sql finding Max value


data have;
input id Salary;
cards;
101 1000
102 2000
103 1000
104 3000
105 3000
106 4000
;

proc sql;
create table want as
select id, max( salary ) as wantvar
from have
where salary < ( select max( salary ) from have where salary < ( select max ( salary ) from have));
quit;

 

above code is giving 3 records... it should get only one that is 102 2000.

 

Please help.

Super User
Posts: 6,936

Re: Proc sql finding Max value

You already posted this in general SAS Programming. Please refrain from double posting.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 9,676

Re: Proc sql finding Max value

[ Edited ]

You want select the second large Salary OBS ?

 

 

 

data have;
input id Salary;
cards;
101 1000
102 2000
103 1000
104 3000
105 3000
106 4000
;
proc sql;
select id, salary ,(select count(distinct salary) from have where salary lt a.salary) as n
from have as a
where calculated n=1;
quit;

 

Ask a Question
Discussion stats
  • 2 replies
  • 204 views
  • 0 likes
  • 3 in conversation