https://communities.sas.com/t5/SAS-Procedures/Having-trouble-with-SAS-Proc-SQL-grouping-by-date/m-p/68700#M19679 Thank you. <BR /> I just had the datepart in Select Statement and then referenced the alias in the group by Wed, 02 Sep 2009 19:54:43 GMT Ryujin 2009-09-02T19:54:43Z https://communities.sas.com/t5/SAS-Procedures/Having-trouble-with-SAS-Proc-SQL-grouping-by-date/m-p/68698#M19677 I seem to be having trouble using the group by with Proc SQL e.g<BR /> in SQL if i wanted to take a datetime and group by day rather then the full datetime I would do:<BR /> <BR /> CONVERT(varchar(10), DateTime, 101)<BR /> <BR /> When I format to DateTime9.0 in SAS and then try to group by that same column it shows it as DateTime9.0 but won't group by the same. Tue, 01 Sep 2009 21:49:31 GMT https://communities.sas.com/t5/SAS-Procedures/Having-trouble-with-SAS-Proc-SQL-grouping-by-date/m-p/68698#M19677 Ryujin 2009-09-01T21:49:31Z https://communities.sas.com/t5/SAS-Procedures/Having-trouble-with-SAS-Proc-SQL-grouping-by-date/m-p/68699#M19678 If I understand you correctly take the date from the datetime by<BR /> datevar = datepart(datetimevar) <BR /> and group by that. Tue, 01 Sep 2009 22:14:15 GMT https://communities.sas.com/t5/SAS-Procedures/Having-trouble-with-SAS-Proc-SQL-grouping-by-date/m-p/68699#M19678 Flip 2009-09-01T22:14:15Z https://communities.sas.com/t5/SAS-Procedures/Having-trouble-with-SAS-Proc-SQL-grouping-by-date/m-p/68700#M19679 Thank you. <BR /> I just had the datepart in Select Statement and then referenced the alias in the group by Wed, 02 Sep 2009 19:54:43 GMT https://communities.sas.com/t5/SAS-Procedures/Having-trouble-with-SAS-Proc-SQL-grouping-by-date/m-p/68700#M19679 Ryujin 2009-09-02T19:54:43Z