Help in Proc SQL

[Kalai2008]

I am trying to get the output like below in Proc SQL instead of using first. and last.variable

If any ID consists Y or N,  I only need Y all the time. 

ID     Product

1         Y

1         N

2         N

3         N

4        Y

4         N

Output:

ID      Product

1         Y

2         N

3          N

4         Y

Thanks for looking

[Kurt_Bremser · Accepted solution]

If you only need the largest of any number of values, use the max() summary function in SQL:

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

Edit: gave the sum() variable the correct name

[Kalai2008]

Thank you...It worked.