Parameterize a Variable Transformation Analysis as follows.
- Select twm_tutorials_vc1 (created in Variable Creation Tutorial #1 Variable Creation - Example #1) as the Available Table.
-
Drag and drop the following columns from twm_tutorials_vc1 to the following transformation functions in Created Transformations.
- cust_id — Retain folder
- income — Bin Code folder
- gender — Design Code folder
- marital_status — Recode folder
- age — Rescale folder
- avg_cc_tran_amt — Z Score folder (rename zavg_cc_tran_amt)
- Let all of the transformation functions properties default, except as follows. Double-click on the variable name to bring up the Properties dialog.
-
Do the following to set up gender - Design Code:
-
Click on the Design Code tab on the Properties dialog and then click Values to bring up the Design Code Values Wizard.
Variable Transformation Tutorial #1: Design Code Values Wizard
- Select both F and M by highlighting them and clicking Add.
- Click Finish to exit the Wizard.
-
The default values of F_gender and M_gender are given for the values of F and M, respectively. Highlight those values and type in Females and Males, accordingly.
Variable Transformation Tutorial #1: Design Code
-
Click on the Design Code tab on the Properties dialog and then click Values to bring up the Design Code Values Wizard.
-
Do the following to set up marital_status - Recode:
-
Click on the Recode tab on the Properties dialog and then click Values to bring up the Recode Values Wizard.
Variable Transformation Tutorial #1: Recode Values Wizard
- Select 1-4 by highlighting them and clicking Add.
- Click Finish to exit the Wizard.
-
Specify recode values as follows: 1-S, 2-M, 3-S and 4-S.
Variable Transformation Tutorial #1: Recode
-
Click on the Recode tab on the Properties dialog and then click Values to bring up the Recode Values Wizard.
-
Do the following to set up age - Rescale:
-
Specify a lower bound of 0 and an upper bound of 1 as follows.
Variable Transformation Tutorial #1: Rescale
-
Specify a lower bound of 0 and an upper bound of 1 as follows.
- Go to the OUTPUT-storage tab.
- Select Store the tabular output of this analysis in the database.
-
Specify that a Table should be created named twm_tutorials_vt1.
For this example, the Variable Transformation Analysis generated the following results. Note that the SQL is not shown for brevity.
Variable Transformation - Example #1 Data cust_id income Females Males marital status age zavg_cc_tran_amt 1362480 4 0 1 M 0.26 0.28 1362481 2 1 0 M 0.30 -0.39 1362484 1 1 0 S 0.38 0.07 1362485 2 1 0 S 0.16 0.05 1362486 1 1 0 S 0.83 -0.39 1362487 1 0 1 M 0.76 -0.01 1362488 1 1 0 M 0.84 -0.39 1362489 4 1 0 S 0.29 0.61 1362492 3 1 0 S 0.36 0.15 1362496 1 0 1 S 0.00 -0.39 1362497 1 0 1 S 0.01 -0.39 1362498 1 1 0 M 0.62 -0.39 1362499 3 0 1 M 0.68 -0.06 1362500 4 0 1 S 0.36 -0.39 1362501 5 1 0 M 0.59 0.31 1362502 2 0 1 M 0.58 -0.39 1362503 1 0 1 S 0.07 -0.39 1362504 1 1 0 S 0.03 -0.39 1362505 1 1 0 M 0.53 -0.39 1362506 6 0 1 M 0.51 0.98 1362507 1 1 0 S 0.05 -0.39 1362508 1 1 0 S 0.70 0.13 1362509 1 0 1 M 0.91 0.10 1362510 1 1 0 M 1.00 -0.39 1362511 1 0 1 S 0.92 -0.01 1362512 2 1 0 S 0.64 -0.10 1362513 2 1 0 S 0.25 -0.39 1362516 3 0 1 S 0.26 0.19 1362520 5 1 0 S 0.47 0.64 1362523 1 1 0 S 0.00 -0.39