search for: groupdat

...uce this easily in SAS with retain statement and a few lines of if-then-else logic, etc.. but I am not find anything similar on the Rforum archives. Below is the logic I am trying to apply to produce the output table below. Thanks in any help! if the ID is the first ID encountered then group=1 and groupdate=date or else if not first ID and date - previous date > 10 or date - previous group date >10 then group=previous group # + 1 and groupdate = date or else if not first ID and date - previous date <= 10 or date - previous group date<=10 then group=previous group # and groupdate = previou...

I''m not sure if this fits in Rails'' core but since I spent sometime trying to solve a problem and couldn''t find any solution, I decided to share this method I''ve created to extend ActiveRecord::Relation. Here''s a Gist of it: https://gist.github.com/leods92/7164159 The problem is that when we try grouping timestamps by date, SQL returns unexpected