topic Re: Tranwrd function in SAS Procedures

Tranwrd function

mjaitly — Mon, 01 Sep 2014 06:47:27 GMT

I need to remove [" from the word say ["Mumbai"]. I am able to remove the [ and ] using functions like Tranwrd however I want to know how to remove the " as the function syntax itself has an opening " and a closing " and I am unable to remove the " (which is itself a part of the input). SAS does not seem to be accepting the " within the opening " and closing ". I will appreciate any help.

Thanks

Manish

Re: Tranwrd function

jakarman — Mon, 01 Sep 2014 07:09:20 GMT

When you need to remove characters, I would use the character functions not the word ones. eg SAS(R) 9.4 Functions and CALL Routines: Reference, Third Edition PRX (perl regular strings) are also an option. Within SAS the definition of a string is a basic concept but lost a clear reference. Single quotes (no macro expansion) double quotes (with macro expansion can be used to mark a string begin/end . Repeating a quote is masking the meaning. See: SAS(R) 9.4 Language Reference: Concepts, Third Edition example on Tom's

Re: Tranwrd function

Loko — Mon, 01 Sep 2014 07:47:37 GMT

Hello,

One solution:

data have;

a='["Mumbai"]';

b=compress(a,'"[]');

run;

Re: Tranwrd function

stat_sas — Mon, 01 Sep 2014 11:17:55 GMT

data have;

a='["Mumbai"]';

b=Tranwrd(a,'["','');

c=Tranwrd(b,'"]','');

run;

Re: Tranwrd function

anonymous_user — Mon, 01 Sep 2014 11:47:36 GMT

hi mjaitly

you can use compress with the "keep" option to select all letters from the original text,

because you have capital letters as well I recommend the following syntax :

data have;

have='["New York"]';

need=compress(have,'abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'K');

any_other_word='["or any other word"]';
any_other_word1=compress(any_other_word,'abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'K');
run;

this way you can deal with capital letters and blanks you want to keep, and get rid of all other punctuations symbols .

Re: Tranwrd function

Tom — Mon, 01 Sep 2014 12:05:46 GMT

If you want to include a quote inside of a quoted string you need to double up the quote character. Note that you can also convert from using using double quotes to single quotes.

Examples:

" ""Mumbai"" "

' "Mumbai" '

"Don't"

'Don''t'