The following is one correlation matrix of x1-x6. I want to sort them as follows: First, set x1 as the first variable. Second, find the variable whose correlation coefficent with x1 is the largest (except x1),and set it as the second variale,e.g...x(2); Third, find the variable whose correlation coefficent with x(2) is the largest,and set it as the third variale,e.g...x(3); ..... ..... Finally, sort all variables in such sequence. All variables is sorted by their maximal correlation coefficent with before it. I can sort x1-x6 by hand. But if I have 100 variables, how to sort them in sas? Thanks. NAME        x1      x2       x3       x4       x5       x6 x1 1 0.795283 0.648228 0.702434 0.410562 0.67573 x2 0.795283 1 0.785185 0.852621 0.517509 0.8671 x3 0.648228 0.785185 1 0.711466 0.50897 0.695645 x4 0.702434 0.852621 0.711466 1 0.457522 0.757802 x5 0.410562 0.517509 0.50897 0.457522 1 0.485006 x6 0.67573 0.8671 0.695645 0.757802 0.485006 1 ... View more

I have one dataset including two(x y) or more variables. I want to do some transformation (for examle, power transformation) on my data and get a new dataset including x, y, trans_x and trans_y. Because I probably have more than two variables in my dataset, I wrote one macro. %macro data_trans(inputdata, outputdata, varlist, trans_factor);                data &outputdata;                set &inputdata;                num=countw("&varlist");                do i=1 to num;                'tran_'||left(scan(&varlist,i))= (scan(&varlist,i))**&trans_factor;  /* create one new variable name and do data transformation*/                end;                drop num i;                run; %mend; or %macro data_trans(inputdata, outputdata, varlist, trans_factor);                   data &outputdata;                    set &inputdata;                   array arr &varlist;                   do over arr;                    'trans_'||arr=arr**&trans_factor; /* create one new variable name and do data transformation*/                   end;                    run; %mend; Either of them didn't work. Something wrong was with "||". Anyone could help me out with it? Greatly appreciated. ... View more

%let varlist=index1 index2 index3...........indexn; I want to write one macro and assign index1-indexn to var_1-var-n. I wrote one as follows. Anyone can help me correct it? Greatly appreciated. %MACRO test(varlist=); %let i=1; %do %while (xxxxxxx); %let var_%left(&i)=%scan(&varlist,i,""); %let i=%eval(&i+1); %end; %mend; ... View more

I performed logistic regression on my data. The results show that Hosmer and Lemeshow Goodness-of-Fit Test, Global Null Hypothesis test and Analysis of Parameter Estimates are all significant. But the value of R^square is only 0.176. What does that means? Is My regression model valid? Thanks. ... View more

In ordinary regressions, we can use 2*sd or students' residual to detect and remove outliers, but in logistic regression, how to find outliers? thanks ... View more

I want to transpose the following data: a b 1 x1 y1 x2 y2 c d 2 x3 y3 x4 y4; Into: a b 1 x1 y1 a b 1 x2 y2 c d 2 x3 y3 c d 2 x4 y4; How to program? Thanks! ... View more