topic Perl to remove \X0A\ in SAS Programming

Perl to remove \X0A\

DeepakSwain — Wed, 27 Apr 2016 14:04:48 GMT

Hi there,

For your kind information, I am trying to remove \X0A\ with a space from my text "string" using perl in base sas.

Can someone modify my code to make it functional. Although I can use tranword funtion to do so but my desire is to use perl because in future by using escape character function, I will able to use it in variety of other situations in text mining.

I am using the following code: [for text substituion=s/pattern/new text/]

data test2;

set test1;

string= prxchange("s/\/X0A\/ /",-1,string);

run;

Thank you in advance for your kind reply.

Regards,

Deepak

Re: Perl to remove \X0A\

PGStats — Wed, 27 Apr 2016 16:05:00 GMT

prxchange("s/\x0a/ /o", -1, string)

Re: Perl to remove \X0A\

data_null__ — Wed, 27 Apr 2016 17:09:46 GMT

Does the string contain the actual sequence /X0A/ or does it contain the character='0A'x aka ascii character 10?

Re: Perl to remove \X0A\

DeepakSwain — Wed, 27 Apr 2016 19:36:42 GMT

It contains the actual string for example: "Nothing abnormality\X0\ is detected."

Re: Perl to remove \X0A\

DeepakSwain — Wed, 27 Apr 2016 19:37:33 GMT

It contains the actual string for example: "Nothing abnormality\X0A\ is detected."

Re: Perl to remove \X0A\

PGStats — Wed, 27 Apr 2016 19:42:42 GMT

If those \X0A\ are actual characters then

prxchange("s/\\X0A\\/ /io", -1, string)

will work. Note I assumed it is a zero between X and A. Correct if needed.

Re: Perl to remove \X0A\

DeepakSwain — Wed, 27 Apr 2016 19:43:12 GMT

It contains the actual string for example: "Nothing abnormality\X0A\ is detected." . It may be noted that there is "\" both before and after X0A. which has to be removed also.

Re: Perl to remove \X0A\

DeepakSwain — Wed, 27 Apr 2016 19:50:31 GMT

Hi there, it works fine. Thanks a lot.