Hi SAS community, Hoping to get some help on a problem I am having. DATA: CX_KEY DATE ACTIVITY CASHIER 1 JAN-1 INSTORE_PURCHASE JANET 1 JAN-2 ONLINE_PURCHASE .COM 1 JAN-10 REFUND JANET 2 JAN-5 ONLINE_PURCHASE .COM 3 JAN-7 ONLINE_BROWSE .COM 3 JAN-9 INSTORE_PURCHASE BOB 3 FEB-3 REFUND JANET GOAL: CX_KEY DATE ORIG_ACT ACTIVITY_STR 1 JAN-1 INSTORE_PURCHASE 1 JAN-2 ONLINE_PURCHASE INSTORE_PURCHASE 1 JAN-10 REFUND ONLINE_PURCHASE, INSTORE_PURCHASE 2 JAN-5 ONLINE_PURCHASE 3 JAN-7 ONLINE_BROWSE 3 JAN-9 INSTORE_PURCHASE ONLINE_BROWSE 3 FEB-3 REFUND INSTORE_PURCHASE,ONLINE_BROWSE So essentially what I want to do is to be able to create a string that will have in a csv format of the corresponding activities that occurred for the customer before the date of the activity. So as an example, for CX_KEY = 1 , on Jan 10th customer came in for a refund, and the activities that led up the refund were an online_purchase and an instore_purchase. If anyone could help me with this problem, that would be great! I am using SAS enterprise guide 7.12
... View more