topic calculated variables: replace function in New SAS User

calculated variables: replace function

psmerill — Wed, 07 Nov 2018 14:09:50 GMT

Hi,

we have defined a treatment with a custom detail, that contain the following text: "Ciao #!1!# #!2!#, aggiorni il suo contatto di posta elettronica".

We set a variable of reply definition with this custom detail of treatment but we need to replace the tag, #!1!#, with name of customer and #!2!# with surname.
The name and surname of customer are obtained via data process into a decision campaign.

It's possible define a calculated variable that reclace this values. Is there some function like tranwrd to use into calculated variable?

We can't use a SAS process with DS2 code to replace this text for performance issue.

Best regards,
Paolo

Re: calculated variables: replace function

PaigeMiller — Wed, 07 Nov 2018 14:34:43 GMT

@psmerill wrote:

Hi,

we have defined a treatment with a custom detail, that contain the following text: "Ciao #!1!# #!2!#, aggiorni il suo contatto di posta elettronica".

We set a variable of reply definition with this custom detail of treatment but we need to replace the tag, #!1!#, with name of customer and #!2!# with surname.
The name and surname of customer are obtained via data process into a decision campaign.

It's possible define a calculated variable that reclace this values. Is there some function like tranwrd to use into calculated variable?

We can't use a SAS process with DS2 code to replace this text for performance issue.

I guess I don't understand why you are looking for "some function LIKE tranwrd" when tranwrd seems to do exactly what you want.

Re: calculated variables: replace function

psmerill — Mon, 12 Nov 2018 10:39:06 GMT

Hi,

because the function tranwrd is not present into the list of available functions of calculated variables in SAS RTDM.
Is there an alternative function/way??

Best regards,
Paolo