topic Re: Proc sql Question in SAS Programming

Proc sql Question

Kalai2008 — Sun, 06 May 2018 17:31:33 GMT

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.

Thanks for looking!

novinosrin — Sun, 06 May 2018 17:50:41 GMT

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

Kurt_Bremser — Sun, 06 May 2018 18:11:02 GMT

A slight variation:

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

kiranv_ — Sun, 06 May 2018 18:12:41 GMT

something like this.

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

Kalai2008 — Sun, 06 May 2018 18:16:04 GMT

Thank you..It worked