10-09-2015 05:01 PM
Use both! You will twice as efficient!
10-10-2015 09:59 AM
10-10-2015 10:10 AM - edited 10-10-2015 10:12 AM
I believe @PGStats comment nailed it.
Having said that: Some database SQL extensions provide "first" and "last" as analytics functions http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions056.htm ... but then: They don't have the SAS data step and implementing the same with PLSQL can be painful.