topic Re: SAS Marketing Auomation - How to select data based on dynamic date internval in SAS Customer Intelligence

SAS Marketing Auomation - How to select data based on dynamic date internval

keiwo — Fri, 27 Jan 2017 14:31:36 GMT

Hi,

Patform: SAS Customer Intelligence Studio

Question: How do I go about creating a node that selects data based on Dynamic Date Range.

Example: the JOB executes today. The select node will choose date based on TODAY() and TODAY() -7 in order to get the last 7 days worth.

thanks,

Re: SAS Marketing Auomation - How to select data based on dynamic date internval

Dmitry_Alergant — Mon, 30 Jan 2017 15:45:59 GMT

Hi,

That's actually very simple and convenient. In the Select node, you chose the data item that you want to apply criteria to (the date you're interested in).

If the information map was set up correctly, your Value selection window will look like that:

Chose "Today" option, and then enter "-7" as Minimum and "0" as Maximum. These will be required offset from today's date.

If your Value selection window looks different, this means your information map was not configured properly, and needs to be fixed there. The data item needs to be of Date type and Interval level for it to function properly.

Hope it helps!

Best regards, Dmitriy.

Re: SAS Marketing Auomation - How to select data based on dynamic date internval

keiwo — Mon, 30 Jan 2017 16:33:29 GMT

Hi Dimitriy,

Thanks for the reply...much appreciated 🙂

Keiwo