Hello! I would sincerely appreciate any insight on the following question below. Basically I need a distinct count of the cust_ids to identify item codes that were ordered on the same day by the same person. I have to complete this analysis by tomorrow. I am grateful for your time and help! Example Dataset: Date Item_Code item_desc cust_id 08/18/2016 1245 Pizza 5555 09/17/2014 1245 Pizza 4357 08/18/2016 3344 Chicken 5555 09/17/2014 6742 Bread 4357 10/10/2015 3217 Salad 3218 I am open to any format for the code and final data output as I will complete the analysis in excel. I just need to be able to answer the following quesion: What item_codes were ordered on the same day? How many distinct members per combination? Final analysis I am looking to answer: Pizza (1245) and Chicken (3344) 1 person Pizza (1245) and bread (3344) 1 person I am using SAS EG version 4.2
... View more