Level 1 8. Using an Array for Table Lookup The manager of the Sales Department wants to identify preferred customers for an upcoming promotion. Use the orion.orders_midyear data set and a lookup table to create a new data set, preferred_cust. Partial orion.orders_midyear Customer_ID Month1 Month2 Month3 Month4 Month5 Month6 5 213. 10 478.0 525 . 80 394 . 35 191.79 10 188 . 10 414.09 2876.9 3164.59 2373.44 169. 29 11 78.20 70. 38 12 135. 60 117.6 129.36 97 . 02 122.04 18 29.4 32. 34 24.26 a. Open the file p207e08 and make the following changes: . Create a temporary lookup table, Target, to hold the target sales amount for each month: 200, 400, 300, 100, 100, 200 . Create new variables, Over1, Over2, ...,Over6, to hold the amount that a customer spent above the corresponding month's target. Copyright @ 2015, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED