topic Re: proc tranwrd in SAS Programming

proc tranwrd

sasuser1000 — Tue, 16 Jul 2013 16:47:59 GMT

tI have several sequences,

I want to replace part of my sequence with a txt but for some reson the full sequence is replaced

so for example

replace this 1111 with dir4_

so for the sequence 11110 the result should be equal to dir4_0

%MACRO MANIP(STATE);

x1=cat(cat(&state,4),'_'); /*the value of this is dir4_*/

=tranwrd(test,"1111",x1); /*test =11110 and it's a char*/

%MEND

%MANIP('DIR')

instead of dir4_0 the result is dir4_

Re: proc tranwrd

ballardw — Tue, 16 Jul 2013 17:35:45 GMT

X1 is 200 characters long padded by blanks so after the replacement from X1 there are blanks and the resultant _0 is pushed outside of the limit default 200 characters.

try

=tranwrd(test,"1111",strip(x1)); /* and shouldn't there be a variable on the left of the =*/

Re: proc tranwrd

Amir — Tue, 16 Jul 2013 17:35:55 GMT

Hi,

The code that was posted would not run as is so I made a few amendments whilst trying to keep the code as close to the original.

I believe the issue is to do with the cat function returning a string of length 32,767. So using the trim function I believe helps find the required value for x2:

%MACRO MANIP(STATE);

test ='11110';

x1=cat(cat(&state,4),'_'); /*the value of this is dir4_*/

x2=tranwrd(test,"1111",trim(x1)); /*test =11110 and it's a char*/

%MEND;

data want;

%MANIP('DIR');

put _all_;

run;

Regards,

Amir.

Re: proc tranwrd

sasuser1000 — Tue, 16 Jul 2013 18:37:37 GMT

Thank you, it worked.