topic Re: I want to know whether any customer did transaction over 400 and same customer transaction over in SAS Programming

I want to know whether any customer did transaction over 400 and same customer transaction over 5000

sandy95 — Mon, 04 Nov 2019 03:03:10 GMT

Hi,

I need help on finding out if a customer made a transaction over 40000 and that customer is eligible for perks (FT) for 14days and for same customer after 14 days they will not get perks and i want to know if they did any transaction over 5000.

Please let me know how to calculate and see historical transaction data of a customer when he was enjoying perks for over 40000 and after losing perks transaction of amount 5000.

Thanks

Re: I want to know whether any customer did transaction over 400 and same customer transaction over

Astounding — Mon, 04 Nov 2019 03:31:28 GMT

It sounds possible.

But first, you would need a SAS data set holding the information.

Then you would need to know the names of the variables.

Then you would need to know whether the transaction date information is a SAS date, a SAS datetime, or a character string.

And then you would need to post all that information.

Re: I want to know whether any customer did transaction over 400 and same customer transaction over

sandy95 — Mon, 04 Nov 2019 04:35:59 GMT

I have columns with Created_TS, FT_FLAG (1,0) AMT TRAN_KEY FT_DT CUSTOMER_NAME

Created_TS FT_FLAG AMT TRAN_KEY FT_DT CUSTOMER_NAME

1JAN1960:00:00:00 1 40000 1234 10JAN2019 Oracle

1JAN1960:00:00:00 1 40000 12345 10JAN2019 Oracle

1JAN1960:00:00:00 0 500000 123456 10JAN2019 Java

1JAN1960:00:00:00 0 40000 12334567 10JAN2019 Java

1JAN1960:00:00:00 1 20000 123455678 10JAN2019 SUN

1JAN1960:00:00:00 0 30000 123456789 10JAN2019 JAVA

The above data set is an example of mine, i need to create a flag stating if FT=1 and Amount = 40000 then Y, FT = 0 and Amount = 500000 then N end as Sent_flag

for Same Customer with transactions

Re: I want to know whether any customer did transaction over 400 and same customer transaction over

Astounding — Mon, 04 Nov 2019 15:28:00 GMT

You're getting closer. Now change the sample data so that it refers to just one customer. Include some variation in the dates, so we can see the "14-day rule" in action. And show the new column that you would like calculated.