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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.