BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dvtarasov
Obsidian | Level 7

In IML, is there any way to find every occurrence of a certain number in a matrix and replace it with another number, and what is the syntax for this?

1 ACCEPTED SOLUTION

Accepted Solutions
Rick_SAS
SAS Super FREQ

The LOC function will find the location of the elements that you are looking for. Then you can use regular assignment to replace the numbers.  For example, to replace all values -99 with a missing value, do the following:

 

 

proc iml;
x = {1 -99   3 4,
     5   6 -99 8};
idx = loc(x = -99);   /* find location of elements */
x[idx] = .;           /* replace those elements */

View solution in original post

1 REPLY 1
Rick_SAS
SAS Super FREQ

The LOC function will find the location of the elements that you are looking for. Then you can use regular assignment to replace the numbers.  For example, to replace all values -99 with a missing value, do the following:

 

 

proc iml;
x = {1 -99   3 4,
     5   6 -99 8};
idx = loc(x = -99);   /* find location of elements */
x[idx] = .;           /* replace those elements */

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

From The DO Loop
Want more? Visit our blog for more articles like these.
Discussion stats
  • 1 reply
  • 1935 views
  • 0 likes
  • 2 in conversation