04-29-2016 03:56 PM
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:
please see attached: Table-1
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
Can some one from the community please help me. I really appreaciate your help.
Thanks in advance!
04-29-2016 11:41 PM
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.