Perform Wilcoxon Rank Sum/Mann-Whitney rank test

Occasional Contributor
Posts: 18

Perform Wilcoxon Rank Sum/Mann-Whitney rank test

i have to perform following calculations to determine 8th and 29th ordered pair values:

data are as follows:

Post change (T) 1.3390 1.3496 1.4946 1.4668 1.1911 1.2210

Prechange (R) 1.1331 1.1842 1.0824 1.3049 1.0410 1.2419

The first step in the computation of the confidence interval is to form the 36 (= 6 x 6) individual T/R ratios. This is illustrated in the following table, where the prechange lot slopes (R) are listed across the top of the table, the postchange lot slopes (T) are listed down the left margin of the table, and the individual T/R ratios are the entries in the body of the table:

The second step in the computation of the confidence interval is to order these 36 individual T/R ratios from lowest to highest: 0.9128 0.9357 0.9591 0.9832 1.0058 1.0261 1.0311 1.0343 . . . 1.2863 1.2945 24 1.2964 1.3190 1.3551 1.3808 1.4090 1.4357.

In the third step, the eighth and twenty-ninth ordered individual ratios are the lower and upper limits, respectively, of the 90% confidence interval for the ratio of the median in vitro release rate (slope) for T over the median in vitro release rate for R. In the example, this confidence interval is 1.0343 to 1.2863

I want to achieve this calculation and a report in SAS 9.4 TS level 1M2

Super User
Posts: 23,776

Re: Perform Wilcoxon Rank Sum/Mann-Whitney rank test

Have you looked at PROC NPAR1WAY?

Posts: 5,541

Re: Perform Wilcoxon Rank Sum/Mann-Whitney rank test

Here is a way to get the values.

``````data comb;
do T= 1.3390, 1.3496, 1.4946, 1.4668, 1.1911, 1.2210;
do R= 1.1331, 1.1842, 1.0824, 1.3049, 1.0410, 1.2419;
ratio = T/R;
output;
end;
end;
run;

proc rank data=comb out=limits(where=(order in (8, 29)));
var ratio;
ranks order;
run;

proc print data=limits noobs; run;``````

It is not clear what you want in the report.

PG
Occasional Contributor
Posts: 18

Re: Perform Wilcoxon Rank Sum/Mann-Whitney rank test

Thank you!

This sounds the answer. Is there a way to get the values of T and R from the dataset?

Super User
Posts: 10,787

Re: Perform Wilcoxon Rank Sum/Mann-Whitney rank test

Sounds like you are doing some Statistical Programming. Suggest you post it at IML forum. It is better for IML programming.
Occasional Contributor
Posts: 18

Re: Perform Wilcoxon Rank Sum/Mann-Whitney rank test

[ Edited ]

Thank you. i will do that.

Discussion stats
• 5 replies
• 609 views
• 0 likes
• 4 in conversation