This is my sas code:
25 data MYDATA.e_final;
26 set mydata.e_join;
27 array fld_nm_var (*) attr: ;
28 array fld_txt_var(*) fld:;
29 do i=1 to dim(fld_nm_var);
30 fld_txt = fld_txt_var(i);
31 put fld_txt;
32 fld_name = fld_nm_var(i);
33 put fld_name;
34 msg_txt =tranwrd(msg_txt,trim(fld_name),trim(fld_txt));
35 msg_txt = compress(msg_txt,'()');
36 drop fld_txt fld_name i;
37 PUT '****';
38 end;
39 run;
678954
Account#
****
$51,209
AggValue
****
4/2/09
EndDt
****
8
NumberOfTrans
****
Gary Johnson
PARTY NAME
****
4/2/09
StartDt
***
And this is my text message where the filed names (eg. startDt) have to be replaced with teh field txt (eg. 4/2/09).
"The activity is in the name of
. There were
cash transactions on account
between
and
that aggregated to
.
So though the StartDt has a value of 4/2/09 , when it actually gets replaced in the Message it becomes 4209.
Thanks!