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.
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: