This example shows how to reproduce table template 9 that is used in WinNonlin 5.3 and earlier. Phoenix does not have a specific table type for this template. The main difference between table template 9 and the other table templates in Win-Nonlin is that two data sets are joined to create the final output. The Phoenix Table object only works with one data set at a time. To produce a table similar to table template 9 it is necessary to use Phoenix’s Join Worksheets object prior to creating the table.
In this example two data sets are joined by the Sort variables in both data sets.
The Default table type in Phoenix is used to recreate table template 9 in WinNon-lin.
Recreating WinNonlin’s table template 9 in Phoenix
Import the data sets:
This example uses two data sets, clayton.CSV and clayton_pk.dat. clayton.CSV contains time and concentration data for two formulations. clayton_pk.dat con-tains the Final Parameters output from a noncompartmental analysis.
Note: Select multiple files at once in the Open File(s) dialog by pressing the CTRL key and using the mouse pointer to select the files.
1. Select File > Import or click the Import button. The Open File(s) dialog is displayed.
2. Navigate to the Phoenix examples directory, which by default is located at C:\Program
Files\Pharsight\Phoenix\applica-tion\Examples.
3. Select clayton.CSV and click Open.
The Worksheet Import Options dialog is displayed. The dialog is used to assign options for how the data are imported and presented.
4. Select the Has units row check box.
5. Click Finish. The data set is added to the project’s Data folder.
6. Select File > Import or click the Import button.
7. Select clayton_pk.dat and click Open.
The Worksheet Import Options dialog is displayed. The dialog is used to assign options for how the data are imported and presented.
The correct import options are automatically assigned to the data set. Do not change these settings.
8. Click Finish. The data set is added to the project’s Data folder.
Merge the data:
1. Select the workflow in the Object Browser and then select Insert > Data >
Join Worksheets.
The Join Worksheets object is added to the workflow in the Object Browser.
2. Map the data set clayton as an input source for the Join Worksheets object:
• Use the pointer to drag the clayton worksheet from the Data folder to the
OR
• In the Join Worksheets Worksheet 1 Mappings panel click the Select source button to open the Select Object dialog.
• Select the clayton worksheet and click Select.
3. Repeat Step 2 to map clayton_pk to the Join Worksheets object’s Work-sheet 2 Mappings panel.
The clayton and clayton_pk data sets are mapped to the Join Worksheet object.
4. Use the option buttons in the Worksheet 1 Mappings panel to map the data types to the following contexts:
• Map Subject to the Sort context.
• Map Form to the Sort context.
• Map Hour to the Source Column context.
• Map Conc to the Source Column context.
5. Use the option buttons in the Worksheet 2 Mappings panel to map the data types to the following contexts:
• Map Subject to the Sort context.
• Map Form to the Sort context.
• Map Tmax to the Source Column context.
• Map Cmax to the Source Column context.
• Map AUClast to the Source Column context.
6. Click the Execute button. The results are displayed on the Results tab.
7. Copy the joined worksheet to the Data folder:
• In the Join Worksheets object’s Results tab, right-click the Result work-sheet and select Copy to Data Folder.
The Result worksheet is added to the project’s Data folder and renamed Result from Join Worksheets.
Create the table:
1. Select the workflow in the Object Browser and then select Insert > Table >
Table.
The Table object is added to the workflow in the Object Browser.
Note: When multiple objects of the same type are added to a workflow they are numbered sequentially. For example, the second Table object added to this workflow is called Table 1.
2. Map the joined data set Result from Join Worksheets as the input source for the Table 1 object:
• Use the pointer to drag the Result from Join Worksheets worksheet from the Data folder to the Table 1 object’s Main Mappings panel.
OR
• In the Table 1 Main Mappings panel click the Select source button to open the Select Object dialog.
• Select the Result from Join Worksheets worksheet and click Select.
The Result from Join Worksheets data set is mapped to the Table 1 object.
3. Use the option buttons in the Main Mappings panel to map the data types to the following contexts:
• Map Subject to the Row ID context.
• Map Form to the Stratification Row context.
• Map Hour to the Stratification Column context.
• Map Conc to the Data context.
• Map Tmax, Cmax, and AUClast to the Dependency context.
Default table type mappings
Summary statistics
This table includes the following summary statistics and formatting options.
Select summary statistics:
1. Select the Statistics tab, which is located underneath the Setup tab.
2. Select the check boxes in the Display column to select the following sum-mary statistics:
• N
• Mean
• SE
Format the table:
Use the Options tab to specify output and formatting options for the Default table type. The Options tab is located underneath the Setup tab.
1. Select Table in the Options menu tree.
2. Select the Page Break on Row Stratification check box.
3. Click the (+) sign beside Precision/Alignment to view the mapped column headers and click the (+) sign beside Statistics to view the selected sum-mary statistics.
4. Select Precision/Alignment > Hour in the Options menu tree.
5. Select 1 in the Value menu.
6. Select Precision/Alignment > Subject in the Options menu tree.
7. Select 0 in the Value menu.
8. Select Captions in the Options menu tree.
9. In the Caption field type Table 2.
10.Click the Add button.
11.In the Caption field type Raw Data and Pharmacokinetic Parame-ters.
12.Click the Add button.
13.Click the Execute button. The results are displayed on the Results tab.
Default table type Formulation c results
Default table type Formulation t results