Data step for repeat

[PROCDATARUN]

Hello Programmers,

I have a simple ask to concatenate 5 columns with a comma separator with a condition.

Dataset = INPUTA

Columns = C1 through C5

Expected Outcome

Need a column that would concatenate all 5 columns with comma separator in sequence when there is a value and ignore if the column is blank.

State	C1	C2	C3	C4	C5	CustomColumn
CA	X	A				X,A
WI	X	R	B			X,R,B
MI	Y	T	X		I	Y,T,X,I

[novinosrin]

	CustomColum=catx(',',of c1-c5);

[PROCDATARUN]

Thanks Novin,

Could you help with the full code here ?
Proc or Data ?

[novinosrin · Accepted solution]

data want;
 set have;
 CustomColum=catx(',',of c1-c5);
run;