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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: