topic Re: Help in Proc SQL in SAS Programming

Help in Proc SQL

Kalai2008 — Wed, 17 Jan 2018 14:25:09 GMT

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 — Wed, 17 Jan 2018 14:33:23 GMT

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 — Wed, 17 Jan 2018 14:41:37 GMT

Thank you...It worked.