BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Gil_
Quartz | Level 8
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
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

4 REPLIES 4
Reeza
Super User

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;
Gil_
Quartz | Level 8
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
Reeza
Super User

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

Gil_
Quartz | Level 8
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

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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