Hi All. I'm looking into ways to delete left part of the text before a blank line, i'm giving example of a similar code that remove everything before the '|' character, are there ways to do the same before the blank line ? ( or keep only the last line) I need only to keep the text on the last line ( where the keword another starts, but the keyword is not constant, so another solution is needed) : data have;
length textstr $100;
input textstr $;
datalines;
Text text text
Another text , text text
;;;;
run;
data want;
set have;
call scan(textstr,2,start,length,'|');
new_textstr = substr(textstr,start);
run; I have tried also the compress, where it looks for the kw, but this is something difficult to combine: new_textstr = compress(textstr,,"kw"); Thank you for response.
... View more