Hi All, I need to do some segmentation on variables based on correlation matrix. The  correlation matrix is shown as below. If correlation coefficients of some variables in correlation matrix are larger than 0.75 or smaller than -0.75, they will be classified into one subgroup and be stored in one dataset, e.g. dataset_1. Then the variables in dataset_1 will be removed from correlation matrix. Then, if correlation coefficients of some variables in remaining correlation matrix are larger than 0.75 or smaller than -0.75,  they will be classified into another subgroup and be stored in another dataset, e.g. dataset_2. Then the variables in dataset_2 will be removed from correlation matrix....................And repeat until no variables have correlation coefficients of above 0.75 or below -0.75. The remaining variables will be stored in one datsets, dataset_n. _NAME_ V1 V2 V3 V4 V5 V6 V7 V8 V9 V10 V11 V1 1 0.795283 0.648228 0.702434 0.814356 0.898034 0.72141 0.545573 0.410562 0.67573 0.79505 V2 0.795282885 1 0.785185 0.852621 0.830391 0.75202 0.817556 0.682524 0.517509 0.8671 0.995331 V3 0.648227521 0.785185 1 0.711466 0.690316 0.60089 0.716786 0.552231 0.50897 0.695645 0.824341 V4 0.702433756 0.852621 0.711466 1 0.846026 0.662565 0.748602 0.701647 0.457522 0.757802 0.853448 V5 0.81435639 0.830391 0.690316 0.846026 1 0.817881 0.772293 0.523626 0.398964 0.778101 0.829205 V6 0.898034025 0.75202 0.60089 0.662565 0.817881 1 0.707077 0.457641 0.329565 0.679927 0.750266 V7 0.721409554 0.817556 0.716786 0.748602 0.772293 0.707077 1 0.604067 0.517373 0.788003 0.819051 V8 0.545573147 0.682524 0.552231 0.701647 0.523626 0.457641 0.604067 1 0.585093 0.584004 0.681971 V9 0.410562159 0.517509 0.50897 0.457522 0.398964 0.329565 0.517373 0.585093 1 0.485006 0.522883 V10 0.675730408 0.8671 0.695645 0.757802 0.778101 0.679927 0.788003 0.584004 0.485006 1 0.860323 V11 0.795050139 0.995331 0.824341 0.853448 0.829205 0.750266 0.819051 0.681971 0.522883 0.860323 1 Is there one solution to do this? Thanks in advance MT. ... View more

Hello,everyone!  I need to do logistic regression on my data,but the client offered me more than 20 variables. I'm pretty sure that some of them are not necessary. But how to remove them? Is there one stepwise method, just like proc reg, for proc logistic? Anyone could help me out? Thanks! ... View more

If I create one variable list like this, %let varlist=c1-c9; How to get the number of variables in &varlist? If I %let  n=%sysfunc(countw(&varlist)), &n will be 2. Any way to get the exact number of variables in &varlist? Thanks! ... View more

I have a few dummy variables as follow, and I need to do factor analysis on them. Anyone can help me out with this? x1 x2 x3 x4 1    1   0   1 1    0   1   1 0    0   1   0 ... View more

I wrote one macro as below. This macro includes two parameters. If either of them is blank, the values of the two maco variable will be specified in the macro...........But when i run %test, error will appear.....How to fix it? Thanks. %macro test(alpha,beta); %if &alpha eq and &beta eq %then %do; %let &alpha=0.005; %let &beta=0.005; %end; %if &alpha ne and &beta eq  %then %do; %let &beta=α %end; %put &alpha β %mend; %test() ... View more