https://communities.sas.com/t5/SAS-Enterprise-Guide/grouping/m-p/298382#M20332 <P>There are a few interpretations as to what "group them" might mean:</P> <P>&nbsp;</P> <UL> <LI>Add a variable representing the year</LI> <LI>Produce a report that lists each year separately</LI> <LI>Sort the observations in order by the year</LI> </UL> <P>Can you be a little more specific about what you are trying to accomplish?</P> Wed, 14 Sep 2016 17:14:42 GMT Astounding 2016-09-14T17:14:42Z https://communities.sas.com/t5/SAS-Enterprise-Guide/grouping/m-p/298366#M20330 <P>Hi all,</P><P>I have a coloumn&nbsp;start_date and&nbsp;end_date 2 coloumns on dateformat9.</P><P>I need to group them according to the year for 2016,2015,2014&nbsp;on &nbsp;end_date</P><P>startdate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end_date</P><P>01nov2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30nov2015</P><P>01apr2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31dec2014</P><P>01jan2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31oct2015</P><P>01jan2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31dec2016</P><P>01dec2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20feb2015</P><P>&nbsp;</P><P>Any help will be appriciated.</P><P>Thanks.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 14 Sep 2016 16:29:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/grouping/m-p/298366#M20330 vem 2016-09-14T16:29:21Z https://communities.sas.com/t5/SAS-Enterprise-Guide/grouping/m-p/298382#M20332 <P>There are a few interpretations as to what "group them" might mean:</P> <P>&nbsp;</P> <UL> <LI>Add a variable representing the year</LI> <LI>Produce a report that lists each year separately</LI> <LI>Sort the observations in order by the year</LI> </UL> <P>Can you be a little more specific about what you are trying to accomplish?</P> Wed, 14 Sep 2016 17:14:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/grouping/m-p/298382#M20332 Astounding 2016-09-14T17:14:42Z