https://communities.sas.com/t5/SAS-Procedures/sql/m-p/21250#M4482 How about:<BR /> [pre]<BR /> data x;<BR /> length provno$ 15.;<BR /> input provno$;<BR /> cards;<BR /> 25MA07943500ANQ<BR /> 25MA07943500BNQ<BR /> 9096675<BR /> 800004954-007<BR /> A002677-A85<BR /> A119966-A85<BR /> AT208713-A20<BR /> AE209314-C18<BR /> A209314-D18<BR /> A209314-E18<BR /> A209314-F18<BR /> ;<BR /> run;<BR /> <BR /> data y;<BR /> set x;<BR /> length provno$ 15.;<BR /> provno=substr(provno,anydigit(provno));<BR /> run; <BR /> [/pre]<BR /> <BR /> <BR /> Ksharp Thu, 03 Mar 2011 05:39:49 GMT Ksharp 2011-03-03T05:39:49Z https://communities.sas.com/t5/SAS-Procedures/sql/m-p/21249#M4481 Hi ,<BR /> <BR /> I am having an data set, in that i need to remove all the alpha characters on the output files.Some records have values starts with 25MA07943500ANQ,<B>A</B>119966A85, <BR /> ,<B>AE</B>209314-C18<BR /> <BR /> I tried this code:<BR /> data x;<BR /> length provno$ 15.;<BR /> input provno$;<BR /> cards;<BR /> 25MA07943500ANQ<BR /> 25MA07943500BNQ<BR /> 9096675<BR /> 800004954-007<BR /> A002677-A85<BR /> A119966-A85<BR /> AT208713-A20<BR /> AE209314-C18<BR /> A209314-D18<BR /> A209314-E18<BR /> A209314-F18<BR /> ;<BR /> run;<BR /> <BR /> data y;<BR /> set x;<BR /> length provno$ 15.;<BR /> if anyalpha(provno)=1 then provno=substr(provno,2);<BR /> run; <BR /> <BR /> But am not getting an exact output.Please help me on this code.<BR /> <BR /> Thanks in Advance !!!<BR /> <BR /> Raj Thu, 03 Mar 2011 03:11:10 GMT https://communities.sas.com/t5/SAS-Procedures/sql/m-p/21249#M4481 deleted_user 2011-03-03T03:11:10Z https://communities.sas.com/t5/SAS-Procedures/sql/m-p/21250#M4482 How about:<BR /> [pre]<BR /> data x;<BR /> length provno$ 15.;<BR /> input provno$;<BR /> cards;<BR /> 25MA07943500ANQ<BR /> 25MA07943500BNQ<BR /> 9096675<BR /> 800004954-007<BR /> A002677-A85<BR /> A119966-A85<BR /> AT208713-A20<BR /> AE209314-C18<BR /> A209314-D18<BR /> A209314-E18<BR /> A209314-F18<BR /> ;<BR /> run;<BR /> <BR /> data y;<BR /> set x;<BR /> length provno$ 15.;<BR /> provno=substr(provno,anydigit(provno));<BR /> run; <BR /> [/pre]<BR /> <BR /> <BR /> Ksharp Thu, 03 Mar 2011 05:39:49 GMT https://communities.sas.com/t5/SAS-Procedures/sql/m-p/21250#M4482 Ksharp 2011-03-03T05:39:49Z https://communities.sas.com/t5/SAS-Procedures/sql/m-p/21251#M4483 Thanks Sharp..am getting exact output !!! Thu, 03 Mar 2011 15:00:27 GMT https://communities.sas.com/t5/SAS-Procedures/sql/m-p/21251#M4483 deleted_user 2011-03-03T15:00:27Z