Thank you for the responses. In my actual data I have 100s of customers that made multiple transactions at only store 3 or only store 4. I am only interested in those customers that purchased at both. I tried the code above, but it leaves me with not only customers that purchased at both stores, but also those customers that only purhcased at only 1 of the stores in the pair. The code below gives me the results I need, but I thought there may be an easier (less manual) way to get the same results. Thanks! data store_3; set trans; where store=3; run; data store_4; set trans; where store=4; run; proc sql; create table both as select a.customer from store_3 a inner join store_4 b on a.customer=b.customer; quit; proc sort nodupkey; by customer; run; proc sql; create table Final as select * from trans a inner join both b on a.customer=b.customer where store in (3,4); quit; Results of Final: Obs Store Customer Transaction 1 3 40 5118 2 3 40 8971 3 4 40 9008
... View more