BookmarkSubscribeRSS Feed
psmerill
Obsidian | Level 7

 

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

2 REPLIES 2
PaigeMiller
Diamond | Level 26

@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.

--
Paige Miller
psmerill
Obsidian | Level 7
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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1396 views
  • 0 likes
  • 2 in conversation