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