topic Any easy way to look for a value in multiple columns in SAS Programming

Any easy way to look for a value in multiple columns

sachin01663 — Tue, 18 Nov 2014 08:08:05 GMT

Hi,

I have around 80 columns (Col1 to Col80). These columns have city names. I need to look through all columns and see if there in city 'London'.

I have done this by Concatinating the column values and looking for string 'London' but I am hoping there must be an easier way.

The other alternative I was thinking was arrays but I don't want to create another 80 variables or change the values of existing ones.

Thanks as always.

RW9 — Tue, 18 Nov 2014 09:49:06 GMT

Hi,

Well, you don't need to create new variables in the array:

data have;

col1="New York"; col2="London"; output;

run;

data want;

set have;

array col{2};

if find(cats(of col{*}),"London")>0 then Flag="Y";

run;

KachiM — Tue, 18 Nov 2014 09:58:13 GMT

Yet other ways ..

data _null_;

set have;

array k _character_;

if 'London' IN k then put 'Found';

run;

You can use:

whichC('London', of k

);