Conditional Concatenation

[dane7722]

I am trying to figure out a way to concatenate a set of columns, while skipping some when the value = "no". Unfortunately because of how the entire program is structured I am unable to change the no values to null.  Please let me know.. Thanks

image.png

[novinosrin]

Can you post as plain text for me to copy paste and test

[Reeza · Accepted solution]

Changing no to null is the easiest way, because you can then use CATX.

You could duplicate the array and then set it to missing and use that. Otherwise you need to loop and conditionally apply catx each variable.

data want;
set have;

array _col(5) _col1-_col5;
array col(5) col1-col5;
do i=1 to 5;
if col(i) ne 'no' then _col(i)=col(i);
end;
want = catx("_", of _col(*));
run;

[dane7722]

Thank you!!

[mohdfaisal89]

Please Help !

I want to concatenate all the columns ending with _A in a table. I have more then 60 columns ending with _A in a table 90 columns