topic Re: correcting a string with quotes in it in New SAS User

correcting a string with quotes in it

hein68 — Wed, 04 Dec 2019 15:10:28 GMT

How do I get this code to work?

if callfreqothc=""sick Person"" then callfreqothc="Sick Person";
                            __
                            49
                              ____
                              388
                              76

This is the message I'm getting in the log:

NOTE 49-169: The meaning of an identifier after a quoted string might change in
a future SAS release. Inserting white space between a quoted

Thanks!
string and the succeeding identifier is recommended.

Re: correcting a string with quotes in it

Kurt_Bremser — Wed, 04 Dec 2019 15:16:02 GMT

Use the dequote() function:

data test;
input string $20.;
n_string = dequote(string);
datalines;
"sick Person"
;

Re: correcting a string with quotes in it

Lucy1 — Wed, 04 Dec 2019 15:17:27 GMT

If you are familiar with the macro language you could use quoting functions to mask the inner quotes ... the following should work:

data want;  
  callfreqothc='"sick Person"';
  if callfreqothc="%str(%"sick Person%")" then callfreqothc="Sick Person";
run;

The %str() function masks characters that you don't want their meaning interpreted. This needs to be supplemented with individual % signs just before each quote you want to mask

Re: correcting a string with quotes in it

tomrvincent — Wed, 04 Dec 2019 15:28:12 GMT

use the unquote function. Example:

%qsysfunc(compress(&Grouplist,%str(%")))

Re: correcting a string with quotes in it

Tom — Wed, 04 Dec 2019 15:35:35 GMT

You can use different type of quotes on the outside.

if callfreqothc='"sick Person"' then callfreqothc="Sick Person";

Or double any internal quote characters that match the outside quote characters.

if callfreqothc="""sick Person""" then callfreqothc="Sick Person";

Re: correcting a string with quotes in it

novinosrin — Wed, 04 Dec 2019 15:47:50 GMT

Or a bquote instead

if callfreqothc="%bquote("sick Person")" then callfreqothc="Sick Person";

Or something fancy with informat and function

  callfreqothc=propcase(input(callfreqothc, $quote15.));

Re: correcting a string with quotes in it

Tom — Wed, 04 Dec 2019 15:53:20 GMT

There is no need to get the macro processor involved. The SAS language already has methods to represent strings with quotes in them.