https://communities.sas.com/t5/SAS-Procedures/Write-a-simple-code-to-delete-one-zero-from-the-below-value/m-p/58929#M16570 i have variable with value, example: N01221-0123-0101. i just need the value as<BR /> N01221-123-0101. by deleting a zero from the right in the middle one (i.e 0123 to 123). can you write it Message was edited by: sreeram Thu, 28 Apr 2011 04:14:26 GMT sreeram 2011-04-28T04:14:26Z https://communities.sas.com/t5/SAS-Procedures/Write-a-simple-code-to-delete-one-zero-from-the-below-value/m-p/58929#M16570 i have variable with value, example: N01221-0123-0101. i just need the value as<BR /> N01221-123-0101. by deleting a zero from the right in the middle one (i.e 0123 to 123). can you write it Message was edited by: sreeram Thu, 28 Apr 2011 04:14:26 GMT https://communities.sas.com/t5/SAS-Procedures/Write-a-simple-code-to-delete-one-zero-from-the-below-value/m-p/58929#M16570 sreeram 2011-04-28T04:14:26Z https://communities.sas.com/t5/SAS-Procedures/Write-a-simple-code-to-delete-one-zero-from-the-below-value/m-p/58930#M16571 This below code is working thanks for your help GOD. <BR /> <BR /> if substr(usubjid,6,1) = '0' then substr(usubjid,6,4)=substr(usubjid,7,3);<BR /> breaks=substr(usubjid,10,5);<BR /> usubjid=substr(usubjid,1,8)||strip(breaks); Thu, 28 Apr 2011 05:05:58 GMT https://communities.sas.com/t5/SAS-Procedures/Write-a-simple-code-to-delete-one-zero-from-the-below-value/m-p/58930#M16571 sreeram 2011-04-28T05:05:58Z https://communities.sas.com/t5/SAS-Procedures/Write-a-simple-code-to-delete-one-zero-from-the-below-value/m-p/58931#M16572 Hello Sreeram,<BR /> <BR /> How about this:<BR /> [pre]<BR /> data i;<BR /> s='N01221-0123-0101';<BR /> i=INDEX(s,'-');<BR /> r=SUBSTR(s,1,i)||SUBSTR(s,i+2);<BR /> run;<BR /> [/pre]<BR /> Sincerely,<BR /> SPR Thu, 28 Apr 2011 13:23:47 GMT https://communities.sas.com/t5/SAS-Procedures/Write-a-simple-code-to-delete-one-zero-from-the-below-value/m-p/58931#M16572 SPR 2011-04-28T13:23:47Z