Help using Base SAS procedures

Output Proc Freq Measures to a dataset

Accepted Solution Solved
Reply
Highlighted
New Contributor
Posts: 2
Accepted Solution

Output Proc Freq Measures to a dataset

I'd like to output the Pearson and Spearman coefficients that are provided in the proc freq measures option output to a dataset.  I'm comparing the association between a number of variables.

 

The code is a simple proc freq.

 

proc freq data=set;

table var1*(var2 var3 var4 var5 var6)/measures;

run;

 

Is there a way to save the Pearson and Spearman coefficients from the measures output to a dataset?  Ultimately, I'd like to create an ordered list of var2-var6 based on their Pearson and Spearman coefficients. 


Accepted Solutions
Solution
‎01-03-2018 02:29 PM
Super User
Posts: 22,820

Re: Output Proc Freq Measures to a dataset

You can use ODS OUTPUT. 

 

proc freq data=sashelp.cars;
table type*(origin drivetrain cylinders) / out=want measures;
ods output measures=want2;
run;

proc print data=want;
proc print data=want2;
run;

https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html

 


cmtad wrote:

I'd like to output the Pearson and Spearman coefficients that are provided in the proc freq measures option output to a dataset.  I'm comparing the association between a number of variables.

 

The code is a simple proc freq.

 

proc freq data=set;

table var1*(var2 var3 var4 var5 var6)/measures;

run;

 

Is there a way to save the Pearson and Spearman coefficients from the measures output to a dataset?  Ultimately, I'd like to create an ordered list of var2-var6 based on their Pearson and Spearman coefficients. 


 

View solution in original post


All Replies
Solution
‎01-03-2018 02:29 PM
Super User
Posts: 22,820

Re: Output Proc Freq Measures to a dataset

You can use ODS OUTPUT. 

 

proc freq data=sashelp.cars;
table type*(origin drivetrain cylinders) / out=want measures;
ods output measures=want2;
run;

proc print data=want;
proc print data=want2;
run;

https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html

 


cmtad wrote:

I'd like to output the Pearson and Spearman coefficients that are provided in the proc freq measures option output to a dataset.  I'm comparing the association between a number of variables.

 

The code is a simple proc freq.

 

proc freq data=set;

table var1*(var2 var3 var4 var5 var6)/measures;

run;

 

Is there a way to save the Pearson and Spearman coefficients from the measures output to a dataset?  Ultimately, I'd like to create an ordered list of var2-var6 based on their Pearson and Spearman coefficients. 


 

Super Contributor
Posts: 320

Re: Output Proc Freq Measures to a dataset

ODS OUTPUT is the way to go.

 

ods trace on;
ods output measures=measures;
proc freq data=sashelp.class;

table sex*(height weight)/measures;

run;
ods trace off;

I leave the ODS TRACE ON statements there so you can see how to get the name.

New Contributor
Posts: 2

Re: Output Proc Freq Measures to a dataset

Posted in reply to snoopy369

Thanks so much, both of these solutions worked for me.

☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 166 views
  • 1 like
  • 3 in conversation