topic Re: Count total columns in SAS Programming

Count total columns

Gil_ — Tue, 07 Feb 2017 21:59:23 GMT

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

Re: Count total columns

Reeza — Tue, 07 Feb 2017 22:05:16 GMT

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;

Re: Count total columns

Gil_ — Wed, 08 Feb 2017 00:03:51 GMT

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

Re: Count total columns

Reeza — Wed, 08 Feb 2017 00:09:18 GMT

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-data-AKA-generate/ta-p/258712

Re: Count total columns

Gil_ — Wed, 08 Feb 2017 00:51:10 GMT

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

I'm duplicating your data step
Thanks