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

[UshaLatha]

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

[JamesAnderson]

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

[pcapazzi]

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!