Detecting same amounts of transactions

[dincooo]

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

[r_behata]

Please post sample data and expected output.

[ballardw]

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.