topic Identify different grades for a customer in SAS Programming

Identify different grades for a customer

eemrun — Mon, 16 Jul 2018 04:49:22 GMT

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?

Re: Identify different grades for a customer

novinosrin — Mon, 16 Jul 2018 05:29:18 GMT

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;

Re: Identify different grades for a customer

novinosrin — Mon, 16 Jul 2018 05:31:46 GMT

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;