Hi, I am using sas 9.4 base I want to measure the frequency of a each variable within a column (similar to proc freq) and then create a second column which states the frequency nxt to ac instance of the variable. The data is from Facebook and has an individual row per action (like, comment, share) with an actor Id column (so if the actor has liked a post more than once it is on a separate row). So I want to rank each actor by the number of actions that he/she has taken. This can be done with a proc freq report but I'm not sure how to create a column stating how many actions each actor has taken on every row. Further it would be awesome if the time between action (each row is an action) can be measured on the actor level.... pls see the attached screenshot Any help would be greatly appreciated! -Harrison
... View more