Help using Base SAS procedures

Replacing a value with another

Reply
N/A
Posts: 1

Replacing a value with another

Hi Everyone.
in my example, how can I replace the +/- with 0.0.

data temp;
LENGTH id $20. ;
input id $;
datalines;
3.5+2.4-2.49.8+2.3
-0.2+3.4+-6.54.5-
;
run;

thank you.
Super Contributor
Super Contributor
Posts: 3,174

Re: Replacing a value with another

It may be easier to post what data you would like to see represented as output.

But, if I understand your question, you want to change occurences of "+" or "-" characters with a multi-character string "0.0" - yes or no?

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.

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation