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;
... View more