topic Re: Data step for repeat in SAS Programming

Data step for repeat

PROCDATARUN — Wed, 04 Nov 2020 20:19:52 GMT

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.

novinosrin — Wed, 04 Nov 2020 20:23:58 GMT

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

PROCDATARUN — Wed, 04 Nov 2020 21:07:58 GMT

Thanks Novin,

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

novinosrin — Wed, 04 Nov 2020 21:25:21 GMT

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