Hi Amir,
I have data like this with missing values. variables are character.
Col1 col2 col3 col4….col28
3 . 7 8….25
2 6 . 11….28
;
I want
Col1 col2 col3 col4….col28 result
3 4 7 8….25 3,4,7,8,…,25
2 6 9 11….28 2,6,9,11,….28
I have written:
data d3;
length result $ 50;
SP=',';
result =catx(SP, of col1-col28);
run;
LOG is:
NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
19:16 19:21
NOTE: Invalid numeric data, COL5=' 1* 6' , at line 19 column 21.
Hope this clear.
... View more