Scott copying from the enhanced editor to Word (2010 for me) and then copy from word to the answer screen as it is. I think it is working data two; length name age inc $40; set one; rx=prxparse("/^(.*?)(\d+)\s+(.*)$/"); if prxmatch(rx,line) then do; name=prxposn(rx,1,line); * age=input(prxposn(rx,2,line),best.); age=prxposn(rx,2,line); * inc=input(prxposn(rx,3,line),dollar18.); inc=prxposn(rx,3,line); inc2=input(inc,dollar18.); end; format inc2 dollar18.; run; HTH Andre
... View more