I seem to be having trouble using the group by with Proc SQL e.g
in SQL if i wanted to take a datetime and group by day rather then the full datetime I would do:
CONVERT(varchar(10), DateTime, 101)
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.
... View more