Customer Sequence Product 1 1 Beer 1 2 Peanuts 1 3 Toilet Paper 2 1 Beer 2 2 Chips 2 3 Peanuts 3 1 Bread 3 2 Butter 3 3 Jam 4 1 Bread 4 2 Cheese 4 3 Jam 5 1 Bread 5 2 Ham 5 3 Sausage 6 1 Beer 6 2 Toilet Paper 7 1 Bread 7 2 Susage 7 3 Ham 8 1 Sausage 8 2 Ham 9 1 Beer 10 1 Peanuts 10 2 Chips 11 1 Peanuts 11 2 Toilet Paper 12 1 Bread 12 2 Jam 13 1 Beer 13 2 Peanuts 13 3 Toilet Paper 14 1 Beer 14 2 Chips 14 3 Peanuts 15 1 Bread 15 2 Butter 15 3 Jam 16 1 Bread 16 2 Cheese 16 3 Jam 17 1 Bread 17 2 Ham 17 3 Sausage 18 1 Beer 18 2 Toilet Paper 19 1 Bread 19 2 Cheese 19 3 Ham 20 1 Sausage 20 2 Ham 21 1 Beer 22 1 Peanuts 22 2 Chips 23 1 Peanuts 23 2 Toilet Paper 24 1 Bread 24 2 Jam 25 1 Beer 25 2 Peanuts 25 3 Toilet Paper 26 1 Beer 26 2 Chips 26 3 Peanuts 27 1 Bread 27 2 Butter 27 3 Jam 28 1 Bread 28 2 Cheese 28 3 Jam 29 1 Bread 29 2 Ham 29 3 Sausage 30 1 Beer 30 2 Toilet Paper 31 1 Bread 31 2 Egg 31 3 Ham 32 1 Sausage 32 2 Ham 33 1 Beer 34 1 Peanuts 34 2 Chips 35 1 Peanuts 35 2 Toilet Paper 36 1 Bread 36 2 Jam 37 1 Beer 37 2 Peanuts 37 3 Toilet Paper 38 1 Beer 38 2 Chips 38 3 Peanuts 39 1 Bread 39 2 Butter 39 3 Jam 40 1 Bread 40 2 Cheese 40 3 Jam 41 1 Bread 41 2 Ham 41 3 Sausage 42 1 Beer 42 2 Toilet Paper 43 1 Bread 43 2 Egg 43 3 Ham 44 1 Sausage 44 2 Ham 45 1 Beer 46 1 Peanuts 46 2 Chips 47 1 Peanuts 47 2 Toilet Paper 48 1 Bread 48 2 Jam 49 1 Beer 49 2 Peanuts 49 3 Toilet Paper 50 1 Beer 50 2 Chips 50 3 Peanuts 51 1 Bread 51 2 Butter 51 3 Jam 52 1 Bread 52 2 Cheese 52 3 Jam 53 1 Bread 53 2 Ham 53 3 Sausage 54 1 Beer 54 2 Toilet Paper 55 1 Bread 55 2 Egg 55 3 Ham 56 1 Sausage 56 2 Ham 57 1 Beer 58 1 Peanuts 58 2 Chips 59 1 Peanuts 59 2 Toilet Paper 60 1 Bread 60 2 Jam 61 1 Beer 61 2 Peanuts 61 3 Toilet Paper 62 1 Beer 62 2 Chips 62 3 Peanuts 63 1 Bread 63 2 Butter 63 3 Jam 64 1 Bread 64 2 Cheese 64 3 Jam 65 1 Bread 65 2 Ham 65 3 Sausage 66 1 Beer 66 2 Toilet Paper 67 1 Bread 67 2 Egg 67 3 Ham 68 1 Sausage 68 2 Ham 69 1 Beer 70 1 Peanuts 70 2 Chips 71 1 Peanuts 71 2 Toilet Paper 72 1 Bread 72 2 Jam 73 1 Beer 73 2 Peanuts 73 3 Toilet Paper 74 1 Beer 74 2 Chips 74 3 Peanuts 75 1 Bread 75 2 Butter 75 3 Jam 76 1 Bread 76 2 Cheese 76 3 Jam 77 1 Bread 77 2 Ham 77 3 Sausage 78 1 Beer 78 2 Toilet Paper 79 1 Bread 79 2 Egg 79 3 Ham 80 1 Sausage 80 2 Ham 81 1 Beer 82 1 Peanuts 82 2 Chips 83 1 Peanuts 83 2 Toilet Paper 84 1 Bread 84 2 Jam 85 1 Beer 85 2 Peanuts 85 3 Toilet Paper 86 1 Beer 86 2 Chips 86 3 Peanuts 87 1 Bread 87 2 Butter 87 3 Jam 88 1 Bread 88 2 Cheese 88 3 Jam 89 1 Bread 89 2 Ham 89 3 Sausage 90 1 Beer 90 2 Toilet Paper 91 1 Bread 91 2 Egg 91 3 Ham 92 1 Sausage 92 2 Ham 93 1 Beer 94 1 Peanuts 94 2 Chips 95 1 Peanuts 95 2 Toilet Paper 96 1 Bread 96 2 Jam 97 1 Beer 97 2 Peanuts 97 3 Toilet Paper 98 1 Beer 98 2 Chips 98 3 Peanuts 99 1 Bread 99 2 Butter 99 3 Jam 100 1 Bread 100 2 Cheese 100 3 Jam 101 1 Bread 101 2 Ham 101 3 Sausage 102 1 Beer 102 2 Toilet Paper 103 1 Bread 103 2 Egg 103 3 Ham 104 1 Sausage 104 2 Ham 105 1 Beer 106 1 Peanuts 106 2 Chips 107 1 Peanuts 107 2 Toilet Paper 108 1 Bread 108 2 Jam 109 1 Beer 109 2 Peanuts 109 3 Toilet Paper 110 1 Beer 110 2 Chips 110 3 Peanuts 111 1 Bread 111 2 Butter 111 3 Jam 112 1 Bread 112 2 Cheese 112 3 Jam 113 1 Bread 113 2 Ham 113 3 Sausage 114 1 Beer 114 2 Toilet Paper 115 1 Bread 115 2 Egg 115 3 Ham 116 1 Sausage 116 2 Ham 117 1 Beer 118 1 Peanuts 118 2 Chips 119 1 Peanuts 119 2 Toilet Paper 120 1 Bread 120 2 Jam 121 1 Beer 121 2 Peanuts 121 3 Toilet Paper 122 1 Beer 122 2 Chips 122 3 Peanuts 123 1 Bread 123 2 Butter 123 3 Jam 124 1 Bread 124 2 Cheese 124 3 Jam 125 1 Bread 125 2 Ham 125 3 Sausage 126 1 Beer 126 2 Toilet Paper 127 1 Bread 127 2 Egg 127 3 Ham 128 1 Sausage 128 2 Ham 129 1 Beer 130 1 Peanuts 130 2 Chips 131 1 Peanuts 131 2 Toilet Paper 132 1 Bread 132 2 Jam 133 1 Beer 133 2 Peanuts 133 3 Toilet Paper 134 1 Beer 134 2 Chips 134 3 Peanuts 135 1 Bread 135 2 Butter 135 3 Jam 136 1 Bread 136 2 Cheese 136 3 Jam 137 1 Bread 137 2 Ham 137 3 Sausage 138 1 Beer 138 2 Toilet Paper 139 1 Bread 139 2 Egg 139 3 Ham 140 1 Sausage 140 2 Ham 141 1 Beer 142 1 Peanuts 142 2 Chips 143 1 Peanuts 143 2 Toilet Paper 144 1 Bread 144 2 Jam 145 1 Egg 145 2 Sausage 145 3 Peanuts 146 1 Egg 146 2 Sausage 146 3 Peanuts 147 1 Egg 147 2 Ham 147 3 Peanuts 148 1 Egg 148 2 Bread 148 3 Cheese by using the data please help me finish the following questions

Week 8 Tutorial Answer Sheet: Association Detection You now run a supermarket and wonder what products customers are likely to purchase together. Download a file called retail.csv from Canvas. Use SAS Enterprise Miner to perform association detection and find the answers. Create suitable path diagram and run the analysis. (Hint: Please make sure that set the role of Score to transaction and edit variables to make sure that you input correct role to the transaction data. You need to have three roles, namely, Target, ID and Time ID for the analysis.) Please address the following questions in red and italic fonts. (a) Please describe the steps to generate the association rules in SAS Enterprise Miner in bullet point formats to describe each step (after you have created a new diagram). For example, what components should you include in the diagram? Is there any property that you should change? (b) Please write down the top 3 rules with the highest lift values. (c) If a customer purchases ham and bread, what else is he/she likely to purchase? (d) If a customer buys bread and jam, what else is he/she likely to buy? (e) What managerial implications do you derive from the analysis results? Why?