DATA Step, Macro, Functions and more

Count total columns

Accepted Solution Solved
Reply
Contributor
Posts: 65
Accepted Solution

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: 17,826

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;

View solution in original post


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

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;
Contributor
Posts: 65

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: 17,826

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

Contributor
Posts: 65

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

I'm duplicating your data step
Thanks
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 136 views
  • 1 like
  • 2 in conversation