I'm reading a text file with INFILE in a DATA step
I get the right text, the right content, with the right length (checked with LENGHT)
The TRIMmed string length is equal to the length of the not trimmed string
When I pass the string to PRXCHANGE -- the regex fails, no match
When I pass the TRIMmed string to PRXCHANGE, it works -- the regex find the match correctly
I'm doing this ina a SAS Studio Virtual Lab
I created the file with the VL first as a SAS file, and then I renamed it with extension TXT
The same happens when I use DATALINES instead of a physical file
I'll appreciate your help, thanks
---
data tmp (keep=xx); infile fp delimiter=' '; retain parsed; length xx 6.; input; row= _infile_; if _N_=1 then do; parsed= prxparse(" ...the regex expression..."); end; row= _infile_; xx= prxchange(parsed,1,trim(row)); /* it works */
xx= prxchange(parsed,1,trim(row)); /* it doesn't work */
run;
... View more