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;
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.