finding first transaction : In a consumer spend data, how to find the first transaction done by customers. For e.g if you have 50 transactions. and you have 10 different customers who have done these 50 transactions. Then how to find the first transaction done by each of these 10 customers? 
suggestions to do this in SAS or SQL would really help. 