Hi SAS Experts, I have a data with name and strings, I want to add all the strings(col1,col2,etc..) into one column. The number of strings are not fixed they may be more or less sometimes. I can do this with catx but do not know how to achieve this with array. Below is my data set. Please Guide. data a; input name$ col1$ col2$ col3$ col4$; DATALINES; Harry abc dcd vgd bvd peter cvc fgf ghg ghh John fgg ftg uty gfdg sheyala fgf jty fhf fgr ; run; here is my code: data test; length result $50; set a; result=Compress(catx(';',of col1-col4),'0D0A'x); run; But the number of strings are not fixed. Thanks & Regards, Sanjay
... View more