Separate data from one column to multiple columns

[Yashponde]

I want to separate the above column into different columns as given below

Nettype     Mesh    Dimension

Manta        333        1*0.17

Manta        333        1*0.17

[anushreebiotech · Accepted solution]

Hi,

data have;
input path $50.;
datalines;
Manta/333/1*0.17
Manta/333/1*0.17
Manta/333/1*0.17
Manta/333/1*0.17
;
run;

data want;
set have;
Nettype= scan(path,1,'/');
Mesh= scan(path,2,'/');
Dimension= scan(path,3,'/');
run;

Regards,

Anushree

[Kurt_Bremser]

Nice solution. Simple and works.

Just take care of Maxim 47 and set explicit lengths for the results, either to avoid waste of space or truncation.

[andreas_lds]

Using the scan-function multiple-times, as suggested by @anushreebiotech, is the easiest way solve the issue. You should use the length-statement to ensure that the variable Nettype, Mesh and Dimension are long enough to store the parts extracted by scan.

[mansour_ib_sas]

Hello,

I propose this solution:

data test;
var='Manta/333/1*0.17'; output;
var='Manta/ /1*0.17'; output;
var='Manta/333'; output;
var=' /Manta/333'; output;
; run;

data test1(drop=var i);
set test;
array vr(3) $ Nettype Mesh Dimension;
do i=1 to (countw(var,'/') );
vr(i)=scan(var,i,'/');
end;
run;