topic Re: How to verify the "Map node" results in SAS EG in SAS Customer Intelligence

How to verify the "Map node" results in SAS EG

UshaLatha — Thu, 19 Jul 2018 10:58:05 GMT

Hi,

I need to do some testing on a campaign which uses Map node.

I need to verify if the counts are same as DB . I am testing the code in SAS EG.

I understand that map node does many to one /one to many conversion , but I am not able to replicate in SAS code.

Please help.

Thanks

Re: How to verify the "Map node" results in SAS EG

JamesAnderson — Thu, 19 Jul 2018 23:11:42 GMT

Hi,
Do have access to (or can you request a copy of) the SASCustomerIntelligenceCore log file from your environment ?
This log file will show you the type of code that is generated by the Map Node.
Rgds
James

Re: How to verify the "Map node" results in SAS EG

pcapazzi — Fri, 20 Jul 2018 13:16:43 GMT

You don't need to go to the MA Core Log. If we are talking about CIS you can see the code using the Audit Log. In the menu bar click on Create PDF Document and then uncheck all except for Audit Log. It will show you the PROC SQL performed. You can then copy and paste the code to EG, clean it up a bit. You'll have to create a replacement for the MATable I think. Worst case you can export the subjects before the map node to a table and substitute the MATable with it.

Good luck!