Is there a way to keep only the corr result?
proc corr data=Table1 outp = Table2 noprint;
var Item1;
with Item2;
by Item3;
run;
This gives an output of the mean, std, N, and Corr. Is there a way to eliminate all but the Corr result inside the proc corr step itself?
I've been having to do a proc sql step to select only the corr result.
NoPrint suppress the displayed output so I'm assuming you're referring to the OUTP table? You can add a filter to the output data set directly in the proc.
proc corr data=Table1 outp = Table2 (WHERE = (INSERT FILTER CONDITION)) noprint;
var Item1;
with Item2;
by Item3;
@mcook wrote:
Is there a way to keep only the corr result?
proc corr data=Table1 outp = Table2 noprint;
var Item1;
with Item2;
by Item3;
run;
This gives an output of the mean, std, N, and Corr. Is there a way to eliminate all but the Corr result inside the proc corr step itself?
I've been having to do a proc sql step to select only the corr result.
NoPrint suppress the displayed output so I'm assuming you're referring to the OUTP table? You can add a filter to the output data set directly in the proc.
proc corr data=Table1 outp = Table2 (WHERE = (INSERT FILTER CONDITION)) noprint;
var Item1;
with Item2;
by Item3;
@mcook wrote:
Is there a way to keep only the corr result?
proc corr data=Table1 outp = Table2 noprint;
var Item1;
with Item2;
by Item3;
run;
This gives an output of the mean, std, N, and Corr. Is there a way to eliminate all but the Corr result inside the proc corr step itself?
I've been having to do a proc sql step to select only the corr result.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.