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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.