Hi All, How can I concatenate below rows and change it to one row? I tried to transpose first and then used catx function to concatenate, but the real data will be more than 1K rows. So, it won't work for 1K columns by transposing the rows and the concatenate all. What should be the shortest way? Thanks, Onuralp data Test; input Text $; datalines; I want to have all these words in one sentence ; run; ---- Wanted new column would be like this --> Text2= 'I want to have all these words in one sentence'
... View more