Parameterize a Sample analysis as follows:
- Available Tables — TWM_CUSTOMER
-
Selected Columns and Aliases
- TWM_CUSTOMER.cust_id
- TWM_CUSTOMER.income
- TWM_CUSTOMER.age
- TWM_CUSTOMER.years_with_bank
- TWM_CUSTOMER.nbr_children
- TWM_CUSTOMER.gender
- TWM_CUSTOMER.marital_status
- Sample Style — Stratified
- Stratified Condition — gender = ‘M’
- Sizes/Fractions — 1,2,3
- Stratified Condition — gender = ‘F’
- Sizes/Fractions — 4,5,6
For this example, the Sample analysis generated the following results. Note that not all SQL is shown for brevity and that the specific rows returned will vary randomly.
cust_id | income | age | years_with_bank | nbr_children | gender | marital_status | xsampleid |
---|---|---|---|---|---|---|---|
1363462 | 9495 | 25 | 4 | 2 | F | 3 | 1 |
1363081 | 41876 | 37 | 7 | 0 | F | 1 | 1 |
1362611 | 24115 | 48 | 8 | 1 | F | 2 | 1 |
1362993 | 20702 | 30 | 0 | 1 | F | 3 | 1 |
1363066 | 3240 | 64 | 1 | 0 | M | 1 | 1 |
1363306 | 15576 | 46 | 6 | 0 | F | 1 | 2 |
1363197 | 19088 | 52 | 2 | 2 | F | 2 | 2 |
1363400 | 49258 | 49 | 9 | 0 | F | 2 | 2 |
1362730 | 12988 | 37 | 7 | 3 | F | 4 | 2 |
1362535 | 26548 | 46 | 5 | 4 | F | 4 | 2 |
1362999 | 29403 | 36 | 6 | 2 | M | 4 | 2 |
1363083 | 22680 | 64 | 4 | 0 | M | 1 | 2 |
1362697 | 5848 | 83 | 3 | 0 | F | 1 | 3 |
1362492 | 40252 | 40 | 0 | 5 | F | 3 | 3 |
1363039 | 0 | 15 | 7 | 0 | F | 1 | 3 |
1362548 | 44554 | 59 | 9 | 2 | F | 4 | 3 |
1362836 | 5920 | 66 | 6 | 0 | F | 3 | 3 |
1363266 | 20889 | 23 | 2 | 0 | F | 3 | 3 |
1363051 | 0 | 14 | 6 | 0 | M | 1 | 3 |
1362563 | 14711 | 73 | 3 | 0 | M | 2 | 3 |
1362962 | 2858 | 83 | 3 | 0 | M | 4 | 3 |