Good day.
I have a log's code that i am trimming to not show unnecessary data .
I want to split a step that was found example is attached
That whole step is shown in 1 column after the proc print.
How can i split it so it makes 2 columns under each other that looks like this
NOTE: The data set WORK.STUFF
has 62 observations and 40 variables.
this is the start point of my code ATM
data want;
length input_ds $32767.;
infile "/home/jdebeer/stuff.log.txt" lrecl=32767 truncover;
input @1 input_ds $32767.;
if input_ds =: "NOTE: The data set" then do;
ds=scan(input_ds,5," ");
no_obs=scan(input_ds,7," ");
end;
if input_ds =: "NOTE: SAS initialization used:" then do;
siu=substr(input_ds,index(input_ds,":")+1,24);
end;
if input_ds =: "NOTE: PROCEDURE SQL" then do;
ps=substr(input_ds,index(input_ds,":")+1,14);
end;
if input_ds =: "NOTE: DATA statement used" then do;
dsm=substr(input_ds,index(input_ds,":")+1,15);
end;
if input_ds =: "NOTE: PROCEDURE FORMAT used" then do;
end;