topic Re: If a package has multiple treatments, how to export individule treatment in its own column in SAS Customer Intelligence

If a package has multiple treatments, how to export individule treatment in its own column

janezou — Tue, 03 May 2016 22:16:32 GMT

Hi all,

When a package has many treatments, the exported file has treatment codes in comma delimited format in the column of "Treatment Code - Package". I am curious if it is possible to export each of the treatment_cd in its own column?

I am open to any ideas.

Thanks a lot!

Jane

Re: If a package has multiple treatments, how to export individule treatment in its own column

shill — Wed, 04 May 2016 03:26:43 GMT

Jane -

The behavior you're describing (comma delimited values in treatment-based output columns) is the only existing behavior for MA exports. While there isn't a way to separate those values out into their own columns using the export format, you could certainly do this with some SAS code in a post-process node connected after the communication.

Regards,

Steve

Re: If a package has multiple treatments, how to export individule treatment in its own column

janezou — Wed, 04 May 2016 13:38:16 GMT

Ok. Thanks, Steve!

Re: If a package has multiple treatments, how to export individule treatment in its own column

BeverlyBrown — Wed, 04 May 2016 13:44:31 GMT

Hi @janezou, thank you for posting in the community! Hope you'll keep coming back.