topic Re: Removing string - in the data in SAS Procedures

Removing string - in the data

muralip2013 — Fri, 12 Apr 2013 13:22:01 GMT

hi i have the following data

CRit

-currrent or prior tre

-prior use of treat

i am trying to get rid of '-' hypen at starting of each value.

could any one please help me out to remove that.

Re: Removing string - in the data

AncaTilea — Fri, 12 Apr 2013 13:45:58 GMT

Sure

data test;

string = "-minus";

new_string = translate(string,"","-");

run;

Re: Removing string - in the data

Jagadishkatam — Fri, 12 Apr 2013 13:50:53 GMT

Hi,

Please try to use compress(variable,'-'); check the sample code

data want;

set have;

newvar=compress(variable,'-');

run;

This code will remove the '-' hyphen from the variable.

Thanks,

Jagadish

Re: Removing string - in the data

muralip2013 — Fri, 12 Apr 2013 14:31:50 GMT

Thanks Tilea. That worked perfectly.

Re: Removing string - in the data

muralip2013 — Fri, 12 Apr 2013 14:45:47 GMT

However it worked but in my values there are '-' in middle too those are removing too.

so i just need to remove only the first position of value only For '-'.

Re: Removing string - in the data

Linlin — Fri, 12 Apr 2013 14:51:41 GMT

data have;

input v$;

cards;

abc

-bc

a-b

;

data want;

set have;

v=ifc(first(v)='-',compress(v,'-'),v);

proc print;run;

Re: Removing string - in the data

AncaTilea — Fri, 12 Apr 2013 14:59:39 GMT

, very nice;

is the 'ifc" saying if the first character in string V is "-"??

That's awesome!

Or am I misunderstanding?

Yes, I am misunderstanding...I read on the IFC function.

is the first(v), the FIRST function that tells SAS that if the first character is "-' then so on...

still neat!

Re: Removing string - in the data

Linlin — Fri, 12 Apr 2013 15:04:35 GMT

You are right.

It is the same as

if first(v)='-' then v=compress(v,'-');

Re: Removing string - in the data

muralip2013 — Fri, 12 Apr 2013 15:16:09 GMT

Thanks Lin lin. but when I have "-" in the middle its getting removed too. For instance in the following example for the third value "-a-b" have "-" at the begining and the middle also.

data have;

input v$;

cards;

abc

-bc

-a-b

;

When I tried the following code,

if first(v)='-' then v=compress(v,'-');

My output is :

abc

but the required output is (i.e If there is any "_" in the middle other than first position I need to keep it as is)

abc

a-b

Please help.

Re: Removing string - in the data

Linlin — Fri, 12 Apr 2013 15:38:22 GMT

sorry!

try this one.

data have;
input v$;
cards;
abcc
-bcc
-a-b
;
data want;
set have;
v=ifc(first(v)='-',substr(v,2),v);
proc print;run;
Obs v

                                            1     abcc
                                            2     bcc
                                            3     a-b

Re: Removing string - in the data

AncaTilea — Fri, 12 Apr 2013 15:42:46 GMT

How about this:

data have;

input v$;

cards;

abc

-bc

-a-b

;

data want;

set have;

v1= prxchange("s/-//i",1,strip(v));

run;

Re: Removing string - in the data

muralip2013 — Fri, 12 Apr 2013 16:28:18 GMT

Hi Linlin and Tilea,

Thank both of you for your help. I really appreciate your input.

Could you please help me with the following one too.

Data sample:

Set sample;

Amd1_9-;

AMD1_10-;

Run;

AMD1_9-History of another malignancy within the previous 5 years other than curatively treated non-

melanomatous skin cancer

AMD1_10-Current or prior treatment with estrogens and/or drugs with anti-androgenic properties such

as spironolactone > 50mg/kg, or progestational agents for the treatment of prostate cancer less than 6

months prior to randomization .

In my variable sample I have two sets of values one is 7 char in length second set is 8 char in length

I need to just remove up to colon part and my variable should be starting from alphabets.

Can u Please help me out.

Re: Removing string - in the data

OS2Rules — Fri, 12 Apr 2013 16:29:56 GMT

How about

if string =: '-' then string = substr(string,2);

won't remove anything except a "-" from the first position.

Re: Removing string - in the data

AncaTilea — Fri, 12 Apr 2013 16:49:28 GMT

Hi.

what does the " =: " mean?

Thank you.

Anca.

Re: Removing string - in the data

muralip2013 — Fri, 12 Apr 2013 16:51:58 GMT

its working but my last char in word is truncating

ex :fever

as feve .

could u tell me any other way

Re: Removing string - in the data

AncaTilea — Fri, 12 Apr 2013 16:52:57 GMT

Which Colon part?

What do you need?

This is what you have for a variable named sample it takes values amd1_9- and amd1_10-

Sample

Amd1_9-

AMD1_10-

And you want an new variable new_sample to take what values exactly:

New_Sample

Re: Removing string - in the data

AncaTilea — Fri, 12 Apr 2013 16:54:16 GMT

You have a variable called sample like this

Sample

Amd1_9-

AMD1_10-

Could you please be more specific what do you need the new variable to look like:

Sample

And for the other problem with removing the string, why do you need more ways?

what's wrong with what either I or LinLin offered?

data have;

input string$;

cards;

abc

-bc

-a-b

;

data want;

set have;

string1= prxchange("s/-//i",1,strip(string));

run;

should work....

Re: Removing string - in the data

muralip2013 — Fri, 12 Apr 2013 16:59:28 GMT

Hi Antea,

Following is my data.

Data sample:

Set sample;

Amd1_9-;

AMD1_10-;

Run;

AMD1_9-History of another malignancy within the previous 5 years other than curatively treated non-

melanomatous skin cancer

AMD1_10-Current or prior treatment with estrogens and/or drugs with anti-androgenic properties such

as spironolactone > 50mg/kg, or progestational agents for the treatment of prostate cancer less than 6

months prior to randomization .

I need my new variable sample:

"History of another malignancy within the previous 5 years other than curatively treated non-

melanomatous skin cancer"

Re: Removing string - in the data

AncaTilea — Fri, 12 Apr 2013 17:13:40 GMT

hmmm, something like this:

Data sample;

input sample $50.;

cards;

AMD1_9-History of another malignancy within

AMD1_10-Current or prior treatment with estrogens

;

Run;

proc print;run;

data want;

set sample;

new_sample = prxchange("s/.*[-]//i",1,(sample));

run;

proc print;run;

Re: Removing string - in the data

OS2Rules — Fri, 12 Apr 2013 17:39:10 GMT

The "=:' sets the length of the right side argument to the length of the left side argument.

So - if the left argument is 1 character, the "=:' will only look at the first character of the right side argument.

Very handy.