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

To do this in MS SQL Server, add the following to the beginning of your column selection: ROW_NUMBER() OVER( ORDER BY b.Id) as NID which alters the example view to: SELECT ROW_NUMBER() OVER( ORDER ...

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

The conversion of PROC SQL Pass-Through views is automatic and does not require you to use the PROC CV2ODBC procedure, as described in CV2ODBC Procedure. The ODBC interface and DBMS client must be ...