https://communities.sas.com/t5/SAS-Programming/How-to-get-rid-of-particular-text-which-comes-in-the-start-and/m-p/443788#M111053 <P>One way, assuming that - first occurs in the way that you show.</P> <P>&nbsp;</P> <PRE>data want; set have; var = substr(var,index(var,'-')+2); run;</PRE> <P>The +2 assume that you do not actually want the value to start with the blank that would follow the -.</P> <P>&nbsp;</P> Thu, 08 Mar 2018 15:23:24 GMT ballardw 2018-03-08T15:23:24Z https://communities.sas.com/t5/SAS-Programming/How-to-get-rid-of-particular-text-which-comes-in-the-start-and/m-p/443779#M111049 <P>I want to remove the first text in data which ends with "-" .</P> <P>sample data is</P> <P>Exclusion #13 - The patient has any other disorder for which the treatment .</P> <P>Exclusion #19 - The patient has or has had one or more of the following.</P> <P>Inclusion #5 - The patient and parent(s)/ legal representative (s) is willing and able to attend study<BR />appointments within the specified time windows.</P> <P>&nbsp;</P> <P>So i want to remove whenever there is "<SPAN>Exclusion #13 -" or&nbsp;Exclusion #19 -"</SPAN></P> <P>&nbsp;</P> <P><SPAN>ANy help</SPAN></P> <P>&nbsp;</P> Thu, 08 Mar 2018 15:01:13 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-rid-of-particular-text-which-comes-in-the-start-and/m-p/443779#M111049 vraj1 2018-03-08T15:01:13Z https://communities.sas.com/t5/SAS-Programming/How-to-get-rid-of-particular-text-which-comes-in-the-start-and/m-p/443788#M111053 <P>One way, assuming that - first occurs in the way that you show.</P> <P>&nbsp;</P> <PRE>data want; set have; var = substr(var,index(var,'-')+2); run;</PRE> <P>The +2 assume that you do not actually want the value to start with the blank that would follow the -.</P> <P>&nbsp;</P> Thu, 08 Mar 2018 15:23:24 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-rid-of-particular-text-which-comes-in-the-start-and/m-p/443788#M111053 ballardw 2018-03-08T15:23:24Z