https://communities.sas.com/t5/SAS-Procedures/Replacing-a-value-with-another/m-p/8418#M372 Hi Everyone.<BR /> in my example, how can I replace the +/- with 0.0. <BR /> <BR /> data temp;<BR /> LENGTH id $20. ;<BR /> input id $;<BR /> datalines;<BR /> 3.5+2.4-2.49.8+2.3<BR /> -0.2+3.4+-6.54.5-<BR /> ;<BR /> run;<BR /> <BR /> thank you. Thu, 19 Mar 2009 18:32:35 GMT glodino 2009-03-19T18:32:35Z https://communities.sas.com/t5/SAS-Procedures/Replacing-a-value-with-another/m-p/8418#M372 Hi Everyone.<BR /> in my example, how can I replace the +/- with 0.0. <BR /> <BR /> data temp;<BR /> LENGTH id $20. ;<BR /> input id $;<BR /> datalines;<BR /> 3.5+2.4-2.49.8+2.3<BR /> -0.2+3.4+-6.54.5-<BR /> ;<BR /> run;<BR /> <BR /> thank you. Thu, 19 Mar 2009 18:32:35 GMT https://communities.sas.com/t5/SAS-Procedures/Replacing-a-value-with-another/m-p/8418#M372 glodino 2009-03-19T18:32:35Z https://communities.sas.com/t5/SAS-Procedures/Replacing-a-value-with-another/m-p/8419#M373 It may be easier to post what data you would like to see represented as output.<BR /> <BR /> But, if I understand your question, you want to change occurences of "+" or "-" characters with a multi-character string "0.0" - yes or no?<BR /> <BR /> If YES, the TRANWRD function in a SAS DATA step can accomplish the task. If NO, then please post a reply to the forum group with INPUT and OUTPUT data representations, along with an explanation to what you want accomplish.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Thu, 19 Mar 2009 21:16:01 GMT https://communities.sas.com/t5/SAS-Procedures/Replacing-a-value-with-another/m-p/8419#M373 sbb 2009-03-19T21:16:01Z