topic Re: Modifying existing code to go through several columns in SAS Programming

Modifying existing code to go through several columns

Kaeslock223_ — Tue, 25 Oct 2022 14:19:54 GMT

The code actually doesn't work so I will need to go back and edit.

Re: Modifying existing code to go through several columns

PaigeMiller — Tue, 25 Oct 2022 14:13:37 GMT

Do loops do not exist in PROC SQL.

you could create a macro with a %DO loop and that should work in PROC SQL if you do it properly. However, since I really don't understand what you want to do (there are no columns A-E), I would need to understand the problem better in order to help.

Re: Modifying existing code to go through several columns

Tom — Tue, 25 Oct 2022 14:16:30 GMT

Not sure what you mean by multiple columns. Show some simple example data and the expected results.

It is not clear what you are counting.

Don't you just want to use the MAX() aggregate function to test if the term ever matched?

...
,max(find(t1.col_name,t2.search_terms,'it') > 0) as any_match
group by ...