Dear all,
I know how to split text column (DIAGNOSIS) into separate columns (i.e., col1--col4), shown below in SAS output:
(code in DATA step)
DIAGNOSIS= TRIM(DIAGNOSIS); col1=scan(DIAGNOSIS, 1, '/' || ','); col2=scan(DIAGNOSIS, 2, '/' || ','); col3=scan(DIAGNOSIS, 3, '/' || ','); col4=scan(DIAGNOSIS, 4, '/' || ','); col5=scan(DIAGNOSIS, 5, '/' || ','); run;
but this is not preferrable. I want the output being like the below, each column having same-type value.
(The following is preferred SAS output)
So how can I do it in SAS? Thanks a lot.
-b
... View more