Hi there,
I have a file with many text fields like the one below:
DATA A;
TEXTO="Expenditures pursuant to paragraph 21(3) of the Nuclear Safety and Control Act"; output;
run;
I am not sure however how this text is written exactly: it could be Expenditures pursuant to the Nuclear Safety and Control Act or any
other possible version.
So I am looking for a wild card inside a prxmatch command that would return this string with anything between Expend and Act.
DATA B; SET A;
if prxmatch('/Expend (INSERT WILD CARD) Act/',TEXTO) then FLAG=1;
run;
Thanks.
There are a ton of different 'wildcard' type things in perl regular expressions, but the simplest is .* (match any character = . , and then * means match zero or more of them).
DATA A;
TEXTO="Expenditures pursuant to paragraph 21(3) of the Nuclear Safety and Control Act"; output;
run;
DATA B; SET A;
if prxmatch('/Expend.*Act/',TEXTO) then FLAG=1;
run;
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.