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
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?
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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.