Thanks for suggesting a solution. I actually started with something similar to yours, which is as follows: proc sql; create table TripDetails_Table AS select CustID#, Home City, Trip City, MIN(DateTime) AS FirstDateTime, // DateTime is YYYYMMDDHHMMSS MAX(DateTime) AS LastDateTime, SUM(Amt) AS TotalAmt from Transaction Table where Trip City ne Home City group by CustID#, Trip City; quit; Given that CustID# and Home City is a 1-1 mapping, I suppose grouping by CustID#, Home City, Trip City is the same as grouping by Card#, Trip City, right? Based on the above query, I think SAS will first eliminate the records whereby Home City = Trip City, then it will group the CustID# followed by Trip City together like this: CustID# Home City Trip City Amt DateTime 1 NY LA 200 20161203103032 1 NY LA 300 20161204092330 1 NY LA 200 20170108072330 1 NY BOS 100 20170105113032 Then, the result would be: CustID# Home City Trip City FirstDateTime LastDateTime TotalAmt 1 NY LA 20161203103032 20170108072330 700 1 NY BOS 20170105113032 20170105113032 100 which is not what I want. I want the following: Cust# Home City Trip City FirstDateTime LastDateTime TotalAmt 1 NY LA 20161203103032 20161204092330 500 1 NY BOS 20170105113032 20170105113032 100 1 NY LA 20170108072330 20170108072330 200
... View more