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

SAS proc corr produces the following output for correlation

 

proc corr data=fast;
var resp ;X
run;

 

Output.

 

                 resp               X

 

resp         1.000              0.9600

                                      <.0001                    

                87                      87

 

X            0.9600            1.000

               <.0001

              87                    87

 

Is it possible pull out just the correlation and p-values and have it like this?

 

corr          p

0.9600     <0.0001

 

Thank you.

 

 

 

    

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenKuhfeld
Rhodochrosite | Level 12

Yes!

ods trace on;
proc corr data=sashelp.class(keep=height age);
   ods output pearsoncorr=p;
run;

proc print noobs data=p(obs=1); 
   var height pheight; 
run;
Height PHeight 
0.81143 <.0001 

View solution in original post

4 REPLIES 4
WarrenKuhfeld
Rhodochrosite | Level 12

Yes!

ods trace on;
proc corr data=sashelp.class(keep=height age);
   ods output pearsoncorr=p;
run;

proc print noobs data=p(obs=1); 
   var height pheight; 
run;
Height PHeight 
0.81143 <.0001 
desireatem
Pyrite | Level 9

You wrote:

 

ods trace on;
proc corr data=sashelp.class(keep=height age);
   ods output pearsoncorr=p;
run;

Is it supposed to be

ods trace on;
proc corr data=sashelp.class(keep=height age);
var height age; ods output pearsoncorr=p; run;

 

WarrenKuhfeld
Rhodochrosite | Level 12

You can use a keep= data set option as I used.  You can instead use a VAR statement as you added.  There is no reason to do both as you did.  Data set options will not cover all possible places that you can specify variables (such as MODEL statements) but they work fine for a proc such as CORR.

desireatem
Pyrite | Level 9

Thank you very much!!!

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1222 views
  • 2 likes
  • 2 in conversation