data have;
infile cards dlm='|' ;
input Id (Var1-Var4) ($);
cards;
1 | text_1 | text_2 | text_3 | text_4 |
2 | text_2 | text_2 | text_2 | text_2 |
3 | text_1 | text_3 | | |
4 | text_3 | text_3 | | |
5 | text_4 | text_5 | text_4 | text_5 |
;
data want;
set have;
array v var1--var4;
length final_var $200;
do over v;
if index(final_var,strip(v)) then continue;
final_var=catx('-',final_var,v);
end;
drop var1-var4;
run;
... View more
