Will each variable only have one value or word?
Either way, this is a simple array loop with a counter:
data want;
set have;
array vars(*) list_of_vars to search here;
count=0;
do i=1 to dim(vars);
if find(vars(i), 'ATMBAR', 'i')>0 then
count+1;
end;
run;
Will each variable only have one value or word?
Either way, this is a simple array loop with a counter:
data want;
set have;
array vars(*) list_of_vars to search here;
count=0;
do i=1 to dim(vars);
if find(vars(i), 'ATMBAR', 'i')>0 then
count+1;
end;
run;
Post the full code you used and your log.
Make sure that you've listed all variables properly.
I don't understand your data structure at all. Please include a data step code to reproduce your data if you want further assistance, otherwise you'll get generic responses.
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.