How to parse string with single quote

[dtchoi86]

data final;

set raw;

   dm = ':,;';

   mod = 'oq';

   nwords = countw(raw, dm, mod);

   do count = 1 to nwords;

      clean = strip(scan(raw, count, dm, mod));

      output;

   end;

run;

The code above works until it hits a portion of the string that has an apostrophe/single quote.  From thereon, it stops parsing.  Would I have to code this in a macro environment using %qscan to get around this issue?

Any examples?

Thank you!

[art297 · Accepted solution]

Do you need to parse strings where delimiters are to be ignored when within quotes?

If not, drop the q modifier:

q: ignores delimiters that are inside of substrings that are enclosed in quotation marks. If the value of the string argument contains unmatched quotation marks, then scanning from left to right will produce different words than scanning from right to left.

[dtchoi86]

That did it.

Thank you so much.  Still have a lot to learn.