Question about PROC CORR

[Relax]

Hello All,

I have some JMP codes like below:

dt_a = dt_b << Multivariate(
Y( :Name( "A" ), :name( "B" ), :name( "C" ) ),
estimation method( "Row-wise" ),
invisible
);

I would like to replicate the results of these JMP codes in SAS.  I know PROC CORR may give the correlation, but I don't know how to use "Row-wise" method in this procedure.  Can someone help me?

PS: I am sorry if I posted this question in the wrong location.

[PaigeMiller]

Please explain what JMP is doing when you say "row-wise"

[Relax]

Thanks for replying.  Row-wise estimation is used for data tables with no missing values and calculates the correlation of the variables in the same row.

[PaigeMiller]

---

@Relax wrote:

Thanks for replying.  Row-wise estimation is used for data tables with no missing values and calculates the correlation of the variables in the same row.

---

No missing values ...

proc corr data=mydatasetname;
    var a b c;
run;

[mkeintz]

By "rowwise" do you mean your want correlations using values in the same row?

Second question: what do you want to do about missing values?  If you want correlations of A, B, and C, when a row occurs with missing B, but valid A and C, do you want that row to still contribute to generating the correlation of A and C?

[Relax]

Thanks for replying.

Yes, I want correlations using values of A, B and C in the same row.

Row-wise estimation is used for data tables with no missing values, so if a row occurs with missing B, but valid A and C, I will delete this row.

[PaigeMiller · Accepted solution]

---

@Relax wrote:

Thanks for replying.

Yes, I want correlations using values of A, B and C in the same row.

Row-wise estimation is used for data tables with no missing values, so if a row occurs with missing B, but valid A and C, I will delete this row.

---

This is different than your previous explanation.

Try this

proc corr data=mydatasetname nomiss;
    var a b c;
run;

[Relax]

Thank you, Paige.  I appreciate your help.