Identify different grades for a customer

[eemrun]

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?

[novinosrin · Accepted solution]

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;

[novinosrin]

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;