topic Re: Reg:Removing < > in SAS Procedures

Reg:Removing < >

sas_Forum — Thu, 15 Sep 2011 13:32:00 GMT

Hi i am having data like this

"good work done <123.http> by <lpo;"340> nani <//,89:789> kumar

now i wnat to remove the data in between these symbols < >

output :

"good work done by nani kumar

FriedEgg — Thu, 15 Sep 2011 14:48:02 GMT

Take a look at this similar post, it should provide your answer.

art297 — Thu, 15 Sep 2011 14:56:44 GMT

And, if you're not used to using regular expressions, the following is an example using your data with the code suggested in that post:

data have;

informat string $80.;

input string &;

cards4;

good work done <123.http> by <lpo;"340> nani <//,89:789> kumar

now <dfkljdfj> is the <jkfiuoiewurk> time for it

;;;;

data want (drop=rx);

set have;

if _n_ eq 1 then rx = prxparse('s/<[^>]*>//');

retain rx;

string = prxchange(rx,100,string);

run;

sas_Forum — Fri, 16 Sep 2011 10:24:14 GMT

Hi art can u tell me what

prxparse('s/<[^>]*>//'); is this means like 's/<[^>]*>//' and what prxchange will do ,can you expalin me

DLing — Fri, 16 Sep 2011 14:58:54 GMT

SAS has excellent documentation:

and there are lots of SGF papers on regular expressions and SAS. Suggest you go there first as it is available 24/7.

FriedEgg — Fri, 16 Sep 2011 17:23:33 GMT

DLing is correct about reference the documentation that is available. I will explain that regular expression briefly.

s/<[^>]*>//

substitute, look for < that is not immediately followed by > but has any other string inbetween another >, replace with nil

Also by using the prxdebug function you will get nice information in your log about what it is doing, can help you understand, maybe.