https://communities.sas.com/t5/SAS-Programming/1-how-to-capture-the-last-character-of-a-string-using-functions/m-p/423523#M104164 <P>1. how to capture the last character of a string using functions&nbsp;</P><P>2. how to capture the middle word of the string&nbsp;</P> Mon, 25 Dec 2017 20:31:22 GMT mujahid1303 2017-12-25T20:31:22Z https://communities.sas.com/t5/SAS-Programming/1-how-to-capture-the-last-character-of-a-string-using-functions/m-p/423523#M104164 <P>1. how to capture the last character of a string using functions&nbsp;</P><P>2. how to capture the middle word of the string&nbsp;</P> Mon, 25 Dec 2017 20:31:22 GMT https://communities.sas.com/t5/SAS-Programming/1-how-to-capture-the-last-character-of-a-string-using-functions/m-p/423523#M104164 mujahid1303 2017-12-25T20:31:22Z https://communities.sas.com/t5/SAS-Programming/1-how-to-capture-the-last-character-of-a-string-using-functions/m-p/423524#M104165 <P>Provide a couple of examples and the results you'd want from those examples. Make sure to include at least one example that has an even number of words.</P> <P>&nbsp;</P> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Mon, 25 Dec 2017 21:30:39 GMT https://communities.sas.com/t5/SAS-Programming/1-how-to-capture-the-last-character-of-a-string-using-functions/m-p/423524#M104165 art297 2017-12-25T21:30:39Z https://communities.sas.com/t5/SAS-Programming/1-how-to-capture-the-last-character-of-a-string-using-functions/m-p/423526#M104166 1) SUBSTR() using -1 for position.<BR />2) Middle is not always clear, whatbif there's a even no of words? Besides that, you could use a combination of COUNTW and SCAN functions. Mon, 25 Dec 2017 21:50:05 GMT https://communities.sas.com/t5/SAS-Programming/1-how-to-capture-the-last-character-of-a-string-using-functions/m-p/423526#M104166 LinusH 2017-12-25T21:50:05Z