topic Re: help in extracting string in SAS Programming

help in extracting string

RajeshPU — Wed, 04 Jul 2012 08:54:46 GMT

Hi,

Please help to me get "modified name" from "NAme". String length is varies

Name	ModifiedName
ABCD	ABCD
GHIJ0000	GHIJ
RRJJZL0244	RRJJZL
cdds_3	cdds
ABSD0122	ABSD
NNN0111	NNN
ABCD0000	ABCD

Re: help in extracting string

Alpay — Wed, 04 Jul 2012 09:14:10 GMT

Can you specify the rules (chars to keep/exclude)? e.g.: Are you trying to keep characters A to Z and a to z only?

Re: help in extracting string

RajeshPU — Wed, 04 Jul 2012 09:19:32 GMT

Hi Alpay,

Yes. thats correct. i'm trying to keep only the characters

Thanks for simplifyng the question

Re: help in extracting string

shivas — Wed, 04 Jul 2012 09:22:24 GMT

Hi Rajesh,

Try this..Hope it helps..

data have;

input name $ 20.;

modified = compress(name,'0123456789_');

cards;

ABCD

GHIJ0000

RRJJZL0244

cdds_3

ABSD0122

NNN0111

ABCD0000

;

run;

Thanks,

Shiva

Re: help in extracting string

Alpay — Wed, 04 Jul 2012 09:31:56 GMT

You may utilize regular expressions as well.

It will substitute null string for characters not in the range 'a' to 'z' (a-z) and 'A' to 'Z' (A-Z).

data x;

input Name $20.;

NewName = PRXCHANGE('s/[^a-zA-Z]//o',-1,Name);

datalines;

ABCD

GHIJ0000

RRJJZL0244

cdds_3

ABSD0122

NNN0111

ABCD0000

;

run;

Re: help in extracting string

RajeshPU — Wed, 04 Jul 2012 09:38:54 GMT

Thank you Shiva, that works

Re: help in extracting string

Keith — Wed, 04 Jul 2012 10:23:17 GMT

You could simplify the compress function to keep just the letters A-Z,a-z, rather than remove non-letters.

modified = compress(name,,'ka');