Hi everyone, **POST EDITED: AUG24** 1) I'm using EG at my work and I was wondering if there's a simple way for me to do path analysis? I want to understand the path (channel) customers take to get to their first channel = 3 transaction. I only want to look at transactions with Rev>=0, and exclude customers whose first transaction is channel = 3 i.e. ID 2 ie. ID 1 => 1 -> 3, PATH = '1 only'; ID 6=> 2->1->2->1->3, PATH = '1 & 2'. Data set: HAVE ID TRANS_DATE TRANS_KEY UNITS REV CHANNEL 1 11JUL2015 1068 2 1939.98 1 1 14JUL2015 1256 1 31.99 1 1 17JUL2015 9305 2 63.98 1 1 20JUL2015 1207 2 2279.98 1 1 20JUL2015 1477 -2 -1939.98 1 1 08SEP2015 5113 2 1539.99 1 1 24FEB2016 8835 1 299.99 3 2 01SEP2015 5178 1 139.99 3 2 28SEP2015 2368 1 214.99 1 3 30JUL2015 1504 1 189.95 3 4 22DEC2015 627 2 819.98 3 4 02JAN2016 1271 -2 -819.98 1 5 12AUG2015 9140 2 649.98 3 5 12AUG2015 3423 -1 -199.99 1 5 12AUG2015 3424 2 545.93 1 6 27DEC2015 0947 2 39.98 2 6 25JAN2016 2110 1 119.99 1 6 30JAN2016 3212 1 149.99 2 6 30JAN2016 3320 1 149.99 2 6 02FEB2016 3156 0 -11 2 6 04FEB2016 2395 -1 -149.99 1 6 04FEB2016 2399 -1 -137.56 1 6 04FEB2016 431 1 99.99 3 7 05MAR2016 8426 3 1502.97 3 8 11AUG2015 4689 1 469.99 3 8 11AUG2015 8172 1 14.95 1 9 18SEP2015 1243 2 477.58 1 9 26SEP2015 5399 -2 -477.58 1 9 26SEP2015 5491 2 359.99 1 9 26DEC2015 552 1 699.99 1 9 27DEC2015 5969 -1 -699.99 1 9 27DEC2015 1018 1 999.99 1 9 03JAN2016 6506 -1 -24.99 1 9 04JAN2016 8623 -1 -999.99 1 9 10JAN2016 6097 1 610 1 9 16JAN2016 212 1 829.99 3 9 27JAN2016 6767 1 39.99 2 10 13MAR2016 6892 1 149.99 2 10 08MAY2016 5901 1 109.99 3 10 08MAY2016 124 3 7.97 1 10 08MAY2016 3683 4 1849.99 1 10 09MAY2016 5963 1 160 1 11 30AUG2015 7927 1 369.99 3 11 30AUG2015 4370 0 80 1 Data set: WANT i want a variable PATH with 3 categories: 1 only, 2 only, 1 & 2 ID PATH 1 1 only 6 1 & 2 9 1 only 10 2 only 2) i also have a side question....Is there a simple way to delete all ID rows where first transaction is channel =3? Thanks for your help, much appreciated.
... View more