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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.