topic Re: How to character string from a sentence in SAS Programming

How to character string from a sentence

knveraraju91 — Fri, 15 Jul 2016 17:07:58 GMT

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"

Re: How to character string from a sentence

Reeza — Fri, 15 Jul 2016 17:21:29 GMT

Look at TRANWRD function

Re: How to character string from a sentence

KachiM — Fri, 15 Jul 2016 17:49:16 GMT

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.

Re: How to character string from a sentence

Ksharp — Sat, 16 Jul 2016 06:26:40 GMT

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;

Re: How to character string from a sentence

knveraraju91 — Sat, 16 Jul 2016 15:59:23 GMT

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"

Re: How to character string from a sentence

Ksharp — Sun, 17 Jul 2016 01:17:20 GMT

Then what output do you expect ?