Assign ordinal values to the unique values in specified columns of a Phoenix worksheet. If more than one column is selected, there is an option to enumerate all unique combinations of all selected columns. The user can select to start the numeration at zero or one. One typical usage of this tool is to convert covariates to numerical values for modeling in Phoenix NLME.
Use one of the following to add the object to a Workflow:
Right-click menu for a Workflow object: New > Data Management > Enumerate Worksheets.
Main menu: Insert > Data Management > Enumerate Worksheets.
Right-click menu for a worksheet: Send To > Data Management > Enumerate Worksheets.
Note:To view the object in its own window, select it in the Object Browser and double-click it or press ENTER. All instructions for setting up and execution are the same whether the object is viewed in its own window or in Phoenix view.
Additional information is available for the following topics:
Mappings panel
Output Column Names panel
User Supplied Values panel
Options tab
Results
The Mappings panel allows users to specify which columns in a worksheet are involved in the worksheet transformation. Required input is highlighted orange in the interface.
Enumerate: Column(s) to enumerate.
Column names can be assigned manually using the Output Column Names panel in the Setup tab.
Type the new name in the Output Column Name column of the table.
Enumerated worksheet with new column name
Output values can be assigned manually using the User Supplied Values panel in the Setup tab.
Because Female is alphabetically before Male, the values assigned by default will be 0 to Females and 1 to Males. To indicate other values to assign, use the Setup option User Supplied Values.
In this example, Female has been assigned 1 and 0 to Males.
The default is for the output to concatenate the word code to the selected Enumerate column’s original name to create the output column. In this case, the output column will be named Sex_code.
-
Check the Group Values to Generate a Single Output Column box group values in the output. This option can only be applied when more than one column is mapped to Enumerate.
-
Set the Start Value to begin the enumeration at 0 or 1. This option only works if there are no User Supplied Values worksheet defined.
In the example below, the source data includes a column of sex and weights and both sex and wt are selected to enumerate.
Mappings set for enumerating two columns available in the source
If the Group Values to Generate a Single Output Column box is not checked, the output will show a column for each variable.
Output with Group Values option turned off
If the Group Values to Generate a Single Output Column box is checked, then the output generates a single column, by default called Code, that has levels for the mapped data. For this example, that will result in levels zero to six, all the combinations for the two variables are enumerated together.
Output with Group Values option turned on
The Enumerate Worksheet object generates one worksheet and one text file.
Results: The enumerated worksheet.
Settings: Text file containing input worksheets used and the options selected.
