topic Re: Removing 1st Two characters from a string in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399509#M8223 <P>Thank You.</P> Thu, 28 Sep 2017 14:55:17 GMT subha_4225 2017-09-28T14:55:17Z Removing 1st Two characters from a string https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399483#M8218 <P>Hi all, I want to remove 1st two Character from a string i.e "MX2312323". I want to remove 'MX'. How i will do that. Please help me out</P> Thu, 28 Sep 2017 13:36:07 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399483#M8218 subha_4225 2017-09-28T13:36:07Z Re: Removing 1st Two characters from a string https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399485#M8219 <P>Look up the SUBSTR function in SAS Help.</P> <P>&nbsp;</P> <P>Something like this will work</P> <P>&nbsp;</P> <PRE>newvalue = substr(oldvalue,3);</PRE> Thu, 28 Sep 2017 13:40:19 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399485#M8219 PaigeMiller 2017-09-28T13:40:19Z Re: Removing 1st Two characters from a string https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399486#M8220 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/166360">@subha_4225</a>,</P> <P>&nbsp;</P> <P><A href="http://go.documentation.sas.com/?docsetId=lefunctionsref&amp;docsetTarget=p0wqoixcwtx2jqn1ovqf06kart0o.htm&amp;docsetVersion=9.4&amp;locale=en" target="_self">SUBSTRN Function</A></P> Thu, 28 Sep 2017 13:41:38 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399486#M8220 alexal 2017-09-28T13:41:38Z Re: Removing 1st Two characters from a string https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399508#M8222 Thank u... Thu, 28 Sep 2017 14:55:00 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399508#M8222 subha_4225 2017-09-28T14:55:00Z Re: Removing 1st Two characters from a string https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399509#M8223 <P>Thank You.</P> Thu, 28 Sep 2017 14:55:17 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Removing-1st-Two-characters-from-a-string/m-p/399509#M8223 subha_4225 2017-09-28T14:55:17Z