topic Re: Using DS2 in RTDM SAS Process in SAS Customer Intelligence

Using DS2 in RTDM SAS Process

cleprevost — Fri, 06 May 2016 15:57:27 GMT

Greetings,

I'm a new user to RTDM and am interested in learning more about using DS2 SAS Processes in the tool. I've scoured the internet for examples, but have not had much luck.I'm interested in leveraging the SAS Process to analyze a data grid generated through a Data Process and output variables that can be leveraged in a campaign diagram. Has anyone created a DS2 SAS Process for a similar use case? The version of RTDM is 6.4.

Re: Using DS2 in RTDM SAS Process

shill — Tue, 10 May 2016 02:42:54 GMT

If you need to work with data grids in DS2 as part of an RTDM decision campaign, you'll need to have an input parameter of type "package tap_table" in your execute() method. The tap_table method has a number of methods to allow you to get row count, add/remove rows, get values from the specified row/column, etc. These are all documented on page 102 of the RTDM Admin Guide.

Keep in mind that there are also lots of calcualted functions you can use in your campaign itself to do things like:

Sort the data grid
Select rows with values that match your criteria
Select the top or bottom N rows from a data grid
Join the data grid with another data grid
Get the max, min, average, etc. for the specific column

These are documented on page 265 of the RTDM User Guide.

If you've retrieved the data grid via a data process, you can also directly reference any of the columns, or you can add a data grid identifier to define column names to reference as well.

Re: Using DS2 in RTDM SAS Process

cleprevost — Tue, 10 May 2016 14:41:39 GMT

Thank you for the response! We are currently leveraging the calculated data item feature, but are interested in explored the DS2 option hoping the validation process may be more streamlined.

Regarding your statement: "If you've retrieved the data grid via a data process, you can also directly reference any of the columns, or you can add a data grid identifier to define column names to reference as well."

Can these columns be referenced directly in a node (e.g. branch) or does it require the use of a calculated data item? Can the column be directly referenced in a decision treatment campaign when the read data process is being performed in the decision campaign?

Re: Using DS2 in RTDM SAS Process

shill — Tue, 10 May 2016 22:24:51 GMT

You can't use data grids or arrays directly in branches or filters, since you can't compare a discrete value to a list or table. You can, however, use a calculated item against either a data grid variable or against a single column (which is represented as a list-type variable) in those nodes.

For example, you can branch based on whether a column contains a specific value by creating a boolean calculated item called "Contains XYZ?" that does "ARRAYINDEX(<<dataGridIdentifier.myColumnName>>,'XYZ')" which will return a Yes/No that you can branch on.