topic Re: Detecting same amounts of transactions in SAS Programming

Detecting same amounts of transactions

dincooo — Thu, 10 Jan 2019 14:51:34 GMT

Hi experts,

I have a banking transaction table and I want to track that for today() - x days time period if Y times same amount transactions occured.

Fore example for the last 5 days a customer receives swift 10 times.And 3 of them are the same amount. How can write this sas code?

Many thanks,

Best Regards

Re: Detecting same amounts of transactions

r_behata — Thu, 10 Jan 2019 14:59:43 GMT

Please post sample data and expected output.

Re: Detecting same amounts of transactions

ballardw — Thu, 10 Jan 2019 15:32:48 GMT

Without variable names or example data it is bit difficult to write code. Here is some pseudocode that would create data set with counts.

proc freq data=have;
   where (today() - transactiondate) le 5;
   tables customer*transactiontype*amount/list out=transactioncount;
run;

This assumes that you have a variable for the transaction date that is a SAS date valued variable (NOT date time, if your variable includes time then use DATEPART(transactiondate) above), a customer id variable, a single variable that indicates transaction type and the amount.

After you have the summary then you can filter or summarize.

If your data does not meet the above assumptions then it becomes critical to know exactly how your data is structured, i.e. Example data.