Hello, I have a dataset with variables ID and product. I have to get following data . 1. Need to grab ID's separately that have only one color exist (like 2,5,7) in a separate dataset (Doesn't matter on color). 2. Need to create another dataset that only have the combination of both Green and any other color (Example : Id 1, 2,3,4,5,6 ) but should not pick ID 7 & 8. Id Color 1 Red 1 Blue 1 Orange 1 Green 2 Green 3 Green 3 Red 3 Orange 4 Purple 4 Green 4 Red 5 Green 6 Green 6 Red 6 Orange 7 Red 7 Red 8 Orange 8 Purple My current code not working on this. proc sql; create table a as select * from have group by id having count(distinct color) ne 1; create table b as select * from have group by id having count(distinct color) eq 1; quit; data aa; set a; by id color; if first.color; run; data want; set aa b; run; Thanks for checking!
... View more