In the ORDER BY clause, you can alternatively reference a column by the column's position in the SELECT clause list rather than by name. Use an integer to indicate the column's position.
Why did no one tell me this about SQL: You can order using the column position integer. Shortens your code by a lot for long field names. Select company_code, employee_code from have order by 1,2;
Share this highlighthttp://learning.oreilly.com/a/sas-certification-prep/13433597/