One approach woud be to re-write the regular expression to capture just the text you want, but that can be complex if you are not familiar with REGEX writing. Another approach would be to process the result using SAS functions. So, in your program, the result of the expression:
myinfo = prxposn(prxidata,1,scaline);
Yields:
MULTI VIEWSDT.FILE1.VIEW
To get rid of all the text before that first space, you could add SCAN:
myinfo = scan(prxposn(prxidata,1,scaline),-1,' ');
Which now yields:
VIEWSDT.FILE1.VIEW
If you want to also remove that last "word" after the period, you re-process the result using SUBSTR and FIND like this:
myinfo = SUBSTR(myinfo,1,FIND(myinfo,'.',-9999)-1);
Which now yields:
VIEWSDT.FILE1
Just be aware that, when the value extracted is something like "SEQ LIST.DATA", the end result will be just "LIST". Is that what you were envisioning?
... View more
