SAS Code for Proc Corr with WITH-Variable, Output Vertical

Data defines the model by dint of genetic programming, producing the best decile table.

SAS Code for Proc Corr with WITH-Variable, Output Vertical
Bruce Ratner, PhD.

Live chat by Bold chat

title2' Proc Corr with WITH-Variable, Output Vertical ';
data dat1;
input X1 - X4: 3.0 TARGET 1.0 ;
cards;
123 234 345 456 1
654 756 534 654 1
234 543 654 867 0
;
run;

proc print;
run;

data dat1;
set dat1;
wt=1;
run;

proc corr data=dat1 rank outp=out noprint;
var _numeric_ ;
with TARGET ;
freq wt;
run;

data out1;
set out;
if _TYPE_='MEAN' then delete;
if _TYPE_='STD' then delete;
drop _NAME_;
run;

proc transpose data=out1
out=out2 (rename=(_1=n _2=Corr_TARGET ) ) prefix=_;
run;

data out2;
set out2;
abs_corr=abs(Corr_TARGET);
Predictor=_NAME_;

data out3;
set out2;
if n ge 0 and abs_corr ge .0;

proc sort data=out3;by descending abs_corr;
run;

proc print data=out3;var Predictor n Corr_TARGET;
run;

For more information about this article, call Bruce Ratner at 516.791.3544 or 1 800 DM STAT-1; or e-mail at br@dmstat1.com.

Sign-up for a free GenIQ webcast: Click here.