Hi, I need to get a recursive character contains (C#) followed by 6 digit integer in the field “Description”, I have used a below code in proc sql, i will be getting the first 8 character with the below code, how can i get the "n"th character which contains "C#" followed by interger. pls refer the example below, proc sql; select number, substr(desc,index(desc,"C#"),8) from mast where substr(desc,index(desc,"C#")+2,1) in ('1','2','3','4','5','6','7','8','9','0'); //to get C# followed by interger only. run; desc - column_name Eg : 04-06-2015 20:20:39 - dummy (notes) dummy team._ Please reun the process dummy 04-07-2015 21:15:32 -._ Please reun the process (notes) ABCD are C#123456 and C#654321 Pls help me on this, thanks in advance.
... View more