topic Re: tranwrd and substr text transformation question in SAS Programming

tranwrd and substr text transformation question

tianerhu — Wed, 02 Jun 2021 23:58:23 GMT

libname cert 'C:\practice everyday\input';
libname results 'C:\practice everyday';
data results.output09;
set cert.input09;
a = substr(custID,3,4);
b = a*1000;
custID = tranwrd(custID,a,'9999');
run;
proc print data = results.output09;
run;

when I use variable a instead of 'substr(custID,3,4) as the second argument of the function tranwrd, it doesn't work. why?

The following is the data :

libname cert 'c:\cert\input';
Data cert.input09;
Input custID $;
Datalines;
ID1573
ID2369
ID5361
ID8902
;
Run;

Re: tranwrd and substr text transformation question

ChrisHemedinger — Thu, 03 Jun 2021 00:08:33 GMT

Try defining the A variable first with the proper type and length. You are replacing a character string, length of 4.

data results.output09; length a $ 4; set cert.input09; a = substr(custID,3,4); b = a*1000; custID = tranwrd(custID,a,'9999'); run;

Re: tranwrd and substr text transformation question

tianerhu — Thu, 03 Jun 2021 00:22:39 GMT

Thank you for your help.