Macro to flag monthly New buyer,if new that month or no purchase last 24 month, and repeated Buyer

Jila_Asgary — Thu, 31 Jan 2019 16:01:28 GMT

Hello,

Have a 5 years (2014-2018) transactional data which includes Contact_Email2, ordno, order_date, revenue and few more. Using order_date, i created fod_win & lod for each unique email address.

Q, part 1:

Need to flag monthly new buyers - if contact_email2 has an order_date in this month, and if fod_win is in this specific month (so it is truely first order) or the fod_win is not in this month, but they have not ordered in past 24 months flag them as New_buyer. Since we need 24 months prior history, we will start from 1st month of Jan 2016, and 2014-2015 will be used as past 24 months window .

Q, part 2:

Need to flag monthly repeat buyers - if contact_email2 has an order_date in this month, and if fod in NOT in this specific, but it is less than prior 24 months window, flag them as repeat.

Need to flag this by month from Jan 2016 - Dec 2018.

Hope the question is clear! Please see a sample of my data set, attached. The data set includes all orders, and you can see dups by email.

In advance thanks very much for help!!

Re: Macro to flag monthly New buyer,if new that month or no purchase last 24 month, and repeated Buy

ChrisNZ — Fri, 01 Feb 2019 02:42:04 GMT

Please present simplified set of data as a data step, as well as expected output for the logic you want implemented.

topic Re: Macro to flag monthly New buyer,if new that month or no purchase last 24 month, and repeated Buy in SAS Programming

Macro to flag monthly New buyer,if new that month or no purchase last 24 month, and repeated Buyer

Re: Macro to flag monthly New buyer,if new that month or no purchase last 24 month, and repeated Buy