## Count total columns

Solved
Frequent Contributor
Posts: 126

# Count total columns

Hi I have a table and need to know total count of columns with word Atmbar

Atm1. Atm2. . Atm3. Atm4. Total
Bagbar1. Atmbar1 bagbar2. Atmbar2. 2

Bagbar1. Atmbar1 1

Accepted Solutions
Solution
‎02-15-2017 06:42 PM
Super User
Posts: 24,010

## Re: Count total columns

[ Edited ]

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;``````

All Replies
Solution
‎02-15-2017 06:42 PM
Super User
Posts: 24,010

## Re: Count total columns

[ Edited ]

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;``````
Frequent Contributor
Posts: 126

## Re: Count total columns

Thanks Reeza for responding

I'm getting an error on array subscript out of range at line 107

If find (vars (i), 'ATMBAR' 'i')> then count+1;

My data looks like this not sure if it affects output

Atm1. Atm2.
Bagbarcode:"RS505972" Atmbarcode:"ny1925220204"
ATM. ATM4
Bagbarcode: "RS807978" Atmbarcode:"ca12352205"
Total = 2

Thanks again
Super User
Posts: 24,010

## Re: Count total columns

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.

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

Frequent Contributor
Posts: 126

## Re: Count total columns

It's counting now I had 0 in the do i=1

Here is the output
List_of_vars. To. Search. Count. I
0. 5
0. 5
0. 5