Hi community members, I have a data set that has credit card transactions for accounts through time. Have Have Have Required Required Account Credit _Limit Transaction_amount Decision OTB_remaining 1 1000 500 Approve 500 1 1000 900 Decline 500 1 1000 400 Approve 100 2 2000 1000 Approve 1000 2 2000 1500 Decline 1000 2 2000 2000 Decline 1000 2 2000 1000 Approve 0 Have are the variables that are existing in the data set. Required are the variables that I need to create. Example Account#1: 1. As the first transaction for account#1 is for $500 and the credit limit is $1000, the transaction should be approved and the Open To Buy(OTB) should be Credit Limit ($1000)-Transaction Amount($500)=$500. 2. Now for next transaction as $500 is available for spend, and the customer tries a spend of $900, the transaction should be declined and $500 should be OTB available for next transaction. 3. As the 3rd transaction is for $400 and $500 is available to spend, the transaction should be approved and OTB should be updated to $100. The same should apply to Account#2. As this requires holding previous values of OTB and decision to make subsequent decisions, I am having a hard time figuring out how to code it in SAS. Any help here is much appreciated!
... View more