topic Re: How to parse string with single quote in SAS Programming

How to parse string with single quote

dtchoi86 — Thu, 26 Feb 2015 21:25:04 GMT

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!

Re: How to parse string with single quote

art297 — Thu, 26 Feb 2015 21:41:51 GMT

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.

Re: How to parse string with single quote

dtchoi86 — Thu, 26 Feb 2015 21:49:43 GMT

That did it.

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