Proc sql Question

[Kalai2008]

I am trying to get the below output in  Proc SQL, instead of first. and last.variable. But not getting the desired output using min/max function.

Given Data				Output
Name	Id	Value			Name	Id	Value
John	101	10			John	101	10
John	201	20			John	201	20
John	301	30			John	301	30
Kate	201	10			Kate	201	30
Kate	201	20			Bob	101	20
Kate	201	30			Bob	201	30
Bob	101	10
Bob	101	20
Bob	201	30

Thanks for looking!

[novinosrin]

proc sql;
create table want as
select *
from have
group by name,id
having value=max(value);
quit;

[Kurt_Bremser · Accepted solution]

A slight variation:

proc sql;
create table want as
select
  name,
  id,
  max(value) as value
from have
group by name, id;
quit;

8

[kiranv_]

something like this. 

proc sql;
create table want  as
select name , id , max(value) as value
from have
group by 1, 2;

[Kalai2008]

Thank you..It worked