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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.