topic Re: How can I replace a specific character with 0 in whole dataset? in SAS Programming

How can I replace a specific character with 0 in whole dataset?

Farshid22 — Fri, 26 Mar 2021 19:52:47 GMT

Dear friends,

I have succeeded to replace all Inf (infinite) in my dataset with the letter "I" in SAS EG using the function DIVIDE().

Now I wonder how I can replace the letter "I" with the number 0?

Best regards

Farshid22

Re: How can I replace a specific character with 0 in whole dataset?

Tom — Fri, 26 Mar 2021 20:08:39 GMT

If your values were created using the DIVIDE() function then they are numbers not character strings so they do not contain the letter I. Instead they are equal to the special missing value of .I.

Why do you want to replace a missing value with zero?

Why did you bother to generate the special missing values of .I if you where just going to replace them with zero?