Hi there, I am performing a market basket analysis using PROC ASSOC and PROC SEQUENCE. My data contains information on user sessions (session_id): pages visited (page_type), time spent on each page (time) and money spent on each page (sum). data sample; infile datalines dsd truncover; input session_id :13. page_type:$4. sum:8. time:6. n:2.; datalines4; 30001,6001,10,0.1,1 30001,6001,1,0.4,2 30001,6005,7,3,3 30002,6002,34,0.2,1 30003,6002,2,12,1 30003,6003,5,0.7,2 30003,6002,0.55,3,3 30003,6005,0.9,3,4 ;;;;;;;; The resulting dataset after PROC SEQUENCE has only generated rules (all possible existing in the data sequences of visited pages) and unnecessary at the moment statistics such as count, support, etc. However, I need to calculate statistics for each sequence such as a sum of time spent (time) and sum of money spent (sum). That is the problem. Is there a way to do so? Thank you in advance.
... View more