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!
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.
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.
That did it.
Thank you so much. Still have a lot to learn.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: