topic How do I delete zero's or missing value in a matrix in proc iml in SAS/IML Software and Matrix Computations https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/How-do-I-delete-zero-s-or-missing-value-in-a-matrix-in-proc-iml/m-p/95113#M631 <HTML><HEAD></HEAD><BODY><P>How do I delete the zeros in the matrix; THis matrix is in proc iml</P><P>The matrix name in InverseC.</P><P></P><P></P><TABLE cellpadding="5" cellspacing="0" class="table" frame="box" rules="all" summary="Procedure Iml: InverseC"><TBODY><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">1.1447811</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">4.3174603</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR></TBODY></TABLE></BODY></HTML> Sat, 02 Feb 2013 02:05:50 GMT desireatem 2013-02-02T02:05:50Z How do I delete zero's or missing value in a matrix in proc iml https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/How-do-I-delete-zero-s-or-missing-value-in-a-matrix-in-proc-iml/m-p/95113#M631 <HTML><HEAD></HEAD><BODY><P>How do I delete the zeros in the matrix; THis matrix is in proc iml</P><P>The matrix name in InverseC.</P><P></P><P></P><TABLE cellpadding="5" cellspacing="0" class="table" frame="box" rules="all" summary="Procedure Iml: InverseC"><TBODY><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">1.1447811</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">4.3174603</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR><TR><TD class="r data">0</TD></TR></TBODY></TABLE></BODY></HTML> Sat, 02 Feb 2013 02:05:50 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/How-do-I-delete-zero-s-or-missing-value-in-a-matrix-in-proc-iml/m-p/95113#M631 desireatem 2013-02-02T02:05:50Z Re: How do I delete zero's or missing value in a matrix in proc iml https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/How-do-I-delete-zero-s-or-missing-value-in-a-matrix-in-proc-iml/m-p/95114#M632 <HTML><HEAD></HEAD><BODY><P>You can use the REMOVE function or use LOC and indexing. See <A href="http://blogs.sas.com/content/iml/2012/12/05/remove-or-keep-which-is-faster/" title="http://blogs.sas.com/content/iml/2012/12/05/remove-or-keep-which-is-faster/"> Remove or keep: Which is faster? - The DO Loop</A> for examples and comparison.</P></BODY></HTML> Sat, 02 Feb 2013 22:13:25 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/How-do-I-delete-zero-s-or-missing-value-in-a-matrix-in-proc-iml/m-p/95114#M632 Rick_SAS 2013-02-02T22:13:25Z