Phoenix can compute derived parameters as ratios of modeling output parameters. This functionality has been designed specifically for the computation of F (fraction of oral dose absorbed) and for the calculation of metabolite to parent drug ratios. This example will demonstrate the computation of F. Metabolite to parent drug ratios would be calculated in the same manner.
Two datasets are needed for this example: one with AUC from IV data for 24 subjects, and another with AUC from oral data from the same 24 subjects. These datasets are provided in the Phoenix example subdirectory as IV.csv and Oral.csv. During the following steps, these datasets will be merged into one dataset, F will be computed for each subject, followed by calculations of the summary statistics for F.
Set up the project and data
Create a new project named Transformations.
Import IV.csv and Oral.csv from …\Examples\WinNonlin\Supporting files.
In the File Import Wizard dialog, press the arrow button and then press Finish.
Right-click IV in the Data folder and select Send To > Data Management > Join Worksheets.
In the Mappings panel, map the data types as follows:
Subject to Sort
Form to Source Column
AUC to Source Column
Select Worksheet 2 in the Setup list.
Drag the Oral worksheet from the Data folder to the Worksheet 2 Mappings panel.
Map the data types as follows:
Subject to Sort
Form to Source Column
AUC to Source Column
Click 
(Execute icon) to execute the object.
A portion of the Join results worksheet is shown below:
Calculate F
1. Right-click Workflow in the Object Browser and select New > Data Management > Data Wizard.
2. In the Options tab, select Transformation from the Action menu.
3. Press Add.
4. In the Mappings panel for the Data Wizard (Step 1: Transformation), click 
(Select Source icon).
5. In the dialog, select the Join Worksheets object’s Result worksheet and press OK.
6. Keep Arithmetic as the Transformation Type.
7. Select x/y from the Transformation menu.
8. In the New Column Name field type Fraction.
9. Map the data types as follows:
AUC_1 to y Column
AUC_2 to x Column
10. Execute the object.
Calculate descriptive statistics
1. Right-click Workflow in the Object Browser and select New > Computation Tools > Descriptive Statistics.
2. Click .
3. Select the Data Wizard object’s Result worksheet and press OK.
4. Map the data types as follows:
Fraction to Summary
All others to None
5. In the Options tab, in addition to the default checked boxes, check the Confidence Intervals and Number of SD Statistics boxes but do not change their default values.
6. Check the Other Statistics box.
7. Execute the object.
The Statistics worksheet results are shown below:
