topic Re: space and "/" in SAS Programming

space and "/"

SASPhile — Wed, 14 Mar 2018 21:57:35 GMT

I'm trying to replace space and "/" with an underscore. but the following replaces only "/" with an undrscore not a space. Any help to include space in regex?

proc sql ;
   select catx('=',_name_,prxchange('s/[,\/\\]/_/', -1, col1))
     into :rename separated by ' '
         from temp;

quit;

Re: space and "/"

ChrisNZ — Wed, 14 Mar 2018 22:26:12 GMT

Like this?

data t;
  COL2=prxchange('s/(\/| )/_/', -1, '1/2 3');
  put COL2=;
run;

COL2=1_2_3

Re: space and "/"

ChrisNZ — Wed, 14 Mar 2018 22:27:38 GMT

Or this is you want to use a character class.

COL2=prxchange('s/[\/ ]/_/', -1, '1/2 3');