topic Regarding Substring in SAS Programming https://communities.sas.com/t5/SAS-Programming/Regarding-Substring/m-p/92447#M257469 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have the below data,</P><P>cl_No lineno Servive_code<BR />1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D373<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 373<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D440<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 270<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D20<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D4567<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D567<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; F679</P><P>The service_code should include a 3 digit service_code and a 4 digit service_code.<BR />The four digit servie_code should begin with the letter "D" and is the last of the <BR />cl_no.</P><P>The output should be like this:</P><P>cl_No lineno Servive_code<BR />1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 373<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D440<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 270<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D20<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D567</P><P>Thanks in advance</P></BODY></HTML> Thu, 06 Dec 2012 17:04:54 GMT raveena 2012-12-06T17:04:54Z Regarding Substring https://communities.sas.com/t5/SAS-Programming/Regarding-Substring/m-p/92447#M257469 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have the below data,</P><P>cl_No lineno Servive_code<BR />1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D373<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 373<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D440<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 270<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D20<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D4567<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D567<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; F679</P><P>The service_code should include a 3 digit service_code and a 4 digit service_code.<BR />The four digit servie_code should begin with the letter "D" and is the last of the <BR />cl_no.</P><P>The output should be like this:</P><P>cl_No lineno Servive_code<BR />1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 373<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D440<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 270<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D20<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D567</P><P>Thanks in advance</P></BODY></HTML> Thu, 06 Dec 2012 17:04:54 GMT https://communities.sas.com/t5/SAS-Programming/Regarding-Substring/m-p/92447#M257469 raveena 2012-12-06T17:04:54Z Re: Regarding Substring https://communities.sas.com/t5/SAS-Programming/Regarding-Substring/m-p/92448#M257470 <HTML><HEAD></HEAD><BODY><P>Are you looking to keep records:</P><P>when the service code is exactly 3 characters they are all digits or any exactly 3 character code?</P><P>or</P><P>when the service code is exactly 4 characters the first first character is "D"?</P><P></P><P>I'm not sure what you mean by "and is the last of the cl_no" since your have multiple cl_No values in your output example.</P></BODY></HTML> Thu, 06 Dec 2012 18:21:09 GMT https://communities.sas.com/t5/SAS-Programming/Regarding-Substring/m-p/92448#M257470 ballardw 2012-12-06T18:21:09Z