https://communities.sas.com/t5/SAS-Procedures/character-matching/m-p/61204#M17367 Hi,<BR /> In SAS is there a function equivalent to the MID function in excel. I have a column with a 3 character data, in the form of <BR /> <BR /> 0x0<BR /> 0y0<BR /> 0z0<BR /> 0x1<BR /> 0x2<BR /> <BR /> I want to create a new column from this data which contains the middle character<BR /> In essence the new field should have the following data<BR /> <BR /> x<BR /> y<BR /> z<BR /> <BR /> Is there a way I can do this.<BR /> <BR /> Thanks<BR /> Shri Tue, 23 Feb 2010 14:13:53 GMT deleted_user 2010-02-23T14:13:53Z https://communities.sas.com/t5/SAS-Procedures/character-matching/m-p/61204#M17367 Hi,<BR /> In SAS is there a function equivalent to the MID function in excel. I have a column with a 3 character data, in the form of <BR /> <BR /> 0x0<BR /> 0y0<BR /> 0z0<BR /> 0x1<BR /> 0x2<BR /> <BR /> I want to create a new column from this data which contains the middle character<BR /> In essence the new field should have the following data<BR /> <BR /> x<BR /> y<BR /> z<BR /> <BR /> Is there a way I can do this.<BR /> <BR /> Thanks<BR /> Shri Tue, 23 Feb 2010 14:13:53 GMT https://communities.sas.com/t5/SAS-Procedures/character-matching/m-p/61204#M17367 deleted_user 2010-02-23T14:13:53Z https://communities.sas.com/t5/SAS-Procedures/character-matching/m-p/61205#M17368 SUBSTR(string, position&lt;,length&gt;) Tue, 23 Feb 2010 14:23:52 GMT https://communities.sas.com/t5/SAS-Procedures/character-matching/m-p/61205#M17368 Flip 2010-02-23T14:23:52Z https://communities.sas.com/t5/SAS-Procedures/character-matching/m-p/61206#M17369 Thanks that was very helpful Wed, 24 Feb 2010 13:54:31 GMT https://communities.sas.com/t5/SAS-Procedures/character-matching/m-p/61206#M17369 deleted_user 2010-02-24T13:54:31Z