topic Re: HOW to replace the text of a variable with unfixed value in SAS Programming

HOW to replace the text of a variable with unfixed value

HannaZhang — Wed, 31 Jul 2019 03:25:51 GMT

hi，all.

I have a variable "InstanceName" ,I want to replace the text “n” of the "InstanceName" with the text “n=06”.

For example ,before: "第n周期第21±2天(队列一) (n=06)" ,

after: "第06周期第21±2天(队列一) ".

The variable "InstanceName" as follows;

THANKS a lot .

Re: HOW to replace the text of a variable with unfixed value

hashman — Wed, 31 Jul 2019 04:45:57 GMT

@HannaZhang:

You can try the expression below, though there're many other (likely neater) ways to do it:

 InstanceName = tranwrd (substr (InstanceName, 1,  find (InstanceName, " (n="))   
                        ,"n"                                                      
                        ,substr (InstanceName, 4 + find (InstanceName, " (n="), 2)
                         ) ;

Kind regards

Paul D.

Re: HOW to replace the text of a variable with unfixed value

ChrisNZ — Wed, 31 Jul 2019 04:59:40 GMT

I can only test in SBCS, but this should be close:

data t; 
  INSTANCENAME ='AAnBBCC (n=06)  ';
  NUMBER       =kscan(INSTANCENAME,-1,' )=');
  INSTANCENAME =kupdate(INSTANCENAME,kindexc(INSTANCENAME,'n'),1,ktrim(NUMBER));
  INSTANCENAME =kscan(INSTANCENAME,1,' ');
  put INSTANCENAME=;
run;

INSTANCENAME=AA06BBCC

Re: HOW to replace the text of a variable with unfixed value

ChrisNZ — Wed, 31 Jul 2019 06:43:44 GMT

@hashman How come single-byte functions work here?

Re: HOW to replace the text of a variable with unfixed value

hashman — Wed, 31 Jul 2019 07:16:59 GMT

@ChrisNZ: Dunno. Perhaps the OP, though having given us a sample not in SBCS, has to deal with SBCS only or has somehow adapted the idea to D/MBCS.