I already have the data imported, so I skipped the first part. I tried with the following code: proc sql; create table want as select id, catx(' ',var_a,var_b,var_c) from have; run; But the answer in the cells is either blank or na (some cells have it). The data is really huge with text content in var_a, var_b, var_c, var_d. Huge in the sense (in excel each cell limit is 32767 words and it has that much amount, so I created extra columns for additional data). I know I am almost there from my previous methos and this method but couldn't figure out to display the whole text. Thank You
... View more