Help using Base SAS procedures

proc corr no number of obs

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 98
Accepted Solution

proc corr no number of obs

Hi everyone,

 

Is there a quick way to exclude number of observations in the correlation matrix created by proc corr?

 

Thanks a lot!

 

Lizi


Accepted Solutions
Solution
‎02-27-2017 08:15 AM
PROC Star
Posts: 7,492

Re: proc corr no number of obs

Then an alternative is to modify the template that drives proc corr. e.g.:

 

ods path work.template(update) sashelp.tmplmst;
proc template;
   edit base.corr.stackedmatrix;
      column (RowName RowLabel) (Matrix) * (Matrix2) /** (Matrix3)*/ * (Matrix4);
    end;
run;
proc corr data=sashelp.cars;
run;
proc template; 
   delete base.corr.stackedmatrix;
run;

In the above code I've made a temporary template replacement for proc corr that has * (Matrix3) commented out. Since Matrix3 contains the N values, they won't appear in the output.

 

HTH,

Art, CEO, AnalystFinder.com

 

View solution in original post


All Replies
Super User
Posts: 19,869

Re: proc corr no number of obs

Can you be more specific? I can't see which N you may be referring to.

Frequent Contributor
Posts: 98

Re: proc corr no number of obs

Thank you, Reeza. I'd like to have N values not shown along with correlations and pvalues. For pvalues, we can simple add NOPROB not to show pvalues. Can we do that for N?
PROC Star
Posts: 7,492

Re: proc corr no number of obs

If you're asking about the N values shown (along with correlations and pvalues) in each cell of the matrix, you can easily eliminate their appearance if you choose to exclude all cases that have any missing values. That way, the N will only show up once, above the correlation matrix.

 

That can be done by selecting the NOMISS option. e.g.:

 

proc corr data = sashelp.cars nomiss;
run;

HTH,

Art, CEO, AnalystFinder.com

 

Frequent Contributor
Posts: 98

Re: proc corr no number of obs

Thanks, Art!

The only problem is that NOMISS excludes all cases with missing values. I need to keep all non-missing data for their correlations, but don't want to display the sample size in the output.
Solution
‎02-27-2017 08:15 AM
PROC Star
Posts: 7,492

Re: proc corr no number of obs

Then an alternative is to modify the template that drives proc corr. e.g.:

 

ods path work.template(update) sashelp.tmplmst;
proc template;
   edit base.corr.stackedmatrix;
      column (RowName RowLabel) (Matrix) * (Matrix2) /** (Matrix3)*/ * (Matrix4);
    end;
run;
proc corr data=sashelp.cars;
run;
proc template; 
   delete base.corr.stackedmatrix;
run;

In the above code I've made a temporary template replacement for proc corr that has * (Matrix3) commented out. Since Matrix3 contains the N values, they won't appear in the output.

 

HTH,

Art, CEO, AnalystFinder.com

 

Frequent Contributor
Posts: 98

Re: proc corr no number of obs

Thanks a lot, Art!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 529 views
  • 3 likes
  • 3 in conversation