How to character string from a sentence

[knveraraju91]

Dear,

I have variable(value) whose values contain 'NCS' . I need to remove the string. Please help.

Thanks 

             value
"sentence of words NCS"

"sentence of words (NCS)"
"NCS , sentence of words"
"NCS sentence of words"
"NCS; sentence of words"

[Reeza]

Look at TRANWRD function 

[KachiM]

You may try COMPRESS function too.

new_Value = compress(Value, 'NCS',' ');

You have comma, semicolon, '(' and ')'.

These also can be compressed into blanks or none.

[Ksharp]

You didn't post then output yet.



data have;
input value $quote40.;
cards4;
"sentence of words NCS"
"sentence of words (NCS)"
"NCS , sentence of words"
"NCS sentence of words"
"NCS; sentence of words"
;;;;
run;
data want;
 set have;
 new_value=prxchange('s/\bNCS\b//i',-1,value);
run;

[knveraraju91]

Hi 

Thanks for the help. It worked, but removed only 'NCS' characters only.

output;

"sentence of words "
"sentence of words ()"
" , sentence of words"
" sentence of words"
"; sentence of words"

[Ksharp]

Then what output do you expect ?