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 ...

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 ...

select employee_title as title, avg(employee_years), freq(employee_id) from sql.employee group by title order by title; where SQL is the libref for a remote SAS ...