How to find the first transaction done by customers?
<p>In a consumer spend data, how can I find the first transaction done by customers. For example, if you have 50 transactions, and you have 10 different customers who have done these 50 transactions, then how can I find the first transaction done by each of these 10 customers?
Suggestions to do this in SAS or SQL would really help. </p>