Check if multiple columns differ each other

Ronein — Tue, 16 May 2023 13:24:29 GMT

Hello,

I have dynamic data set that can have different number of column .

Some of the columns in the data set have name with similar strcuture Mon1,Mon2,Mon3 and so on.

As I said before number of columns with name Mon is not fixed.

I want to create a new column called "Indicator" which will get value 1 if there are at least 2 column with different values in column Mon1,Mon2,Mon3 and so on.

For example:

If there are 3 columns then the condition is :

IF Mon2 ne Mon1 OR Mon3 ne Mon2 then Indicator=1;else Indicator=0;

My question:

What is the way to create dynamic code that calculate column "Indicator" based on any number of columns Mon1,Mon2,Mon3....

Please note that the values in columns Mon1,Mon2,Mon3 are chars with long string

Re: Check if multiple columns differ each other

PaigeMiller — Tue, 16 May 2023 15:24:15 GMT

When the number of columns can vary, but with relatively consistent naming conventions, then use ARRAY statement. This code is UNTESTED as you have not provided data.

data want;
    set have;
    array mon mon:;
    indicator=0;
    do i=2 to dim(mon);
        if mon(1)^=mon(i) then do;
            indicator=1;
            leave;
       end;
    end;
run;

topic Check if multiple columns differ each other in SAS Programming

Check if multiple columns differ each other

Re: Check if multiple columns differ each other