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
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.
prxchange("s/\x0a/ /o", -1, string)
Does the string contain the actual sequence /X0A/ or does it contain the character='0A'x aka ascii character 10?
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.