With regular expressions, it would be something like : data test; length Note $40; if not prxID then prxID + prxparse("/.*/"); set myData; start = 1; stop = length(Order_Notes); call prxnext(prxID, start, stop, Order_Notes, position, length); do while (position > 0); Note = substr(Order_Notes, position, length); output; start + 1; call prxnext(prxID, start, stop, Order_Notes, position, length); end; keep Order_Number Note; run; proc print data=test noobs; run; Note: within a regular expression the period (.) matches everything except a newline. PG
... View more