how to extract perticular word.

[JatinBansal]

Hi

I think following is the simplest thing we can do to get the required:

data new;

input text $50.;

datalines;

1.YOUR NAME IS 'SANJEEV.'

2.YOUR NAME IS 'SRINATH.'

333.Your name is anything.

;

data this;

set new;

text2 = substr(text, find(text,'.')+1);

run;

[KarthikSrivasthav]

Which word u want in the above example

[Peter_C]

I would use verify() to locate the first character of the name like

namepart = substr( text, verify( text, '0123456789 .' ));

[yaswanthj]

Hi Sanjeev,

This code may will help you..

data have;

input number text&$30.;

cards;

1 1.YOUR NAME IS 'SANJEEV.'

2 2.YOUR NAME IS 'SRINATH.'

;

run;

proc print;

run;

data want;

set have;

/*text=compress(text,'.','d');*/

text =substr(strip(text),indexc(text ,'.')+1,length(text )-indexc(text ,'.'));

proc print;run;

Thanks,

Yaswanth J.