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
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
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
Thank you...It worked.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.