Hi, I'm trying to replace a character with the carriage return line feed. I’m trying to do it with the prxchange function: data t1;
infile datalines delimiter='#';
input colA &$32. colB &$32.;
datalines;
mon,wed 8:30 - 16:15 # tue 8:30 - 16:30
thu 9:30 - 17:30 # fri 8:30 - 13:00
;
run;
data t2;
set t1;
colC=catx('|',colA,colB);
colD=prxchange('s/\|/\r\n/',-1,colC);/*this doesn't work*/
colE=catx('0D0A'x,colA,colB);/*this works*/
run; I want that colD be the same of colE (which is calculated with an other function). The problem is that it finds correctly the pipe character, but it fails to replace it with the CRLF (\r\n). It seems like it's not able to perform a regEx replace, just the search... In the example above, the first observation of colD becomes like this: mon,wed 8:30 - 16:15\r\ntue 8:30 - 16:30 Instead of becoming like this: mon,wed 8:30 - 16:15
tue 8:30 - 16:30 What am I doing wrong? Thanks for the help! T
... View more