PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...

so I need to group data rows together by year and then order that by semester. I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else ...