topic Re: Conditional Concatenation in SAS Programming

Conditional Concatenation

dane7722 — Tue, 30 Oct 2018 18:21:36 GMT

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

Re: Conditional Concatenation

novinosrin — Tue, 30 Oct 2018 18:23:09 GMT

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

Re: Conditional Concatenation

Reeza — Tue, 30 Oct 2018 18:24:45 GMT

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;

Re: Conditional Concatenation

dane7722 — Tue, 30 Oct 2018 18:35:58 GMT

Thank you!!

Re: Conditional Concatenation

mohdfaisal89 — Thu, 21 Mar 2019 07:51:52 GMT

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