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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.