计算SAS或R中的重复模式

I have a dataset which has all the clicks done on the website in 1 column. I want to find the pattern which gets repeated in the whole data and the data contains more than 1 Million rows and has 17000 different patterns. I also want to know the average time spend on each click for each pattern. I have written a code in SAS which groups each pattern and also finds the time difference between each click but I am not getting the output how I want. Also, if a pattern contains the consecutive keyword "one" then I want it to be merged and considered as single keyword "one". I have a dataset which has all the clicks done