topic Re: Help with mining data in SAS Data Science

Help with mining data

BhararaTej — Tue, 30 Jan 2018 15:59:04 GMT

Hi,

Good Morning!! Looking to get some help from the community.

I have a dataset with transaction information for each customers and below is what the data looks like today.

Customer id Trans_date Transaction Amount Account Balance

12345 12-Nov-17 50 50

12345 14-Nov-17 40 90

12345 17-Nov-17 -25 65

23564 10-Nov-17 15 15

23564 18-Nov-17 15 30

Basically, every time a single transaction results in increase in account balance, is what I want to capture by customer id (highlighted in red).

Looking for some expert advice and help.

Thanks

--TJ

Re: Help with mining data

Reeza — Tue, 30 Jan 2018 16:04:12 GMT

Use the DIF or LAG function to retreive the previous value or difference from previous value.

data want;
set have;

by customerID;

change=dif(account_balance);

if not first.customerId and change>0 then output;

run;

@BhararaTej wrote:

Hi,

Good Morning!! Looking to get some help from the community.

I have a dataset with transaction information for each customers and below is what the data looks like today.

Customer id Trans_date Transaction Amount Account Balance

12345 12-Nov-17 50 50

12345 14-Nov-17 40 90

12345 17-Nov-17 -25 65

23564 10-Nov-17 15 15

23564 18-Nov-17 15 30

Basically, every time a single transaction results in increase in account balance, is what I want to capture by customer id (highlighted in red).

Looking for some expert advice and help.

Thanks

--TJ

Re: Help with mining data

BhararaTej — Wed, 31 Jan 2018 19:00:49 GMT

Thanks.. I ended up using the lag function and this worked.

--TJ