O'Reilly logo

  • Bob Peplinski thinks this is interesting:

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.

From

Cover of SAS Certification Prep Guide, 4th Edition

Note

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 highlight

http://learning.oreilly.com/a/sas-certification-prep/13433597/