i am trying to identify if a customer id has different risk grades per facility. i am completely stumped as to how to do it.as an example:
The following (customer 1) is what I am trying to identify from a dataset:
Customer Facility Grade
customer 1 1 A
customer 1 2 B
customer 2 1 A
customer 2 2 A
customer 2 3 A
Any idea how i can segment them?
data have;
input customer :$15. Facility Grade $;
cards;
customer1 1 A
customer1 2 B
customer2 1 A
customer2 2 A
customer2 3 A
;
proc sql;
create table want as
select *
from have
group by customer
having count(distinct grade)>1;
quit;
data have;
input customer :$15. Facility Grade $;
cards;
customer1 1 A
customer1 2 B
customer2 1 A
customer2 2 A
customer2 3 A
;
proc sql;
create table want as
select *
from have
group by customer
having count(distinct grade)>1;
quit;
Or perhaps you just wanna have flag variable as indicator in the form of 1's and 0s
proc sql;
create table want as
select *,count(distinct grade)>1 as flag
from have
group by customer;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.