Export Matrix - Example #1 (Teradata Database) - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
  1. Parameterize a Export Matrix analysis as follows:
    • Selected Matrix — Customer_Analysis_Matrix_Short
    • SSCP — Enabled
    • Create a SAS Data Step — Enabled
    • Use truncated (8 character) column names — Enabled
    • File Name — Twm_SSCP_Values.sas
  2. Run the analysis.
  3. Edit the resultant SSCP_Values.sas SAS data step script.
    DATA SSCP_Values (type=SSCP);
    infile cards flowover;
    ARRAY columns [7] INTERCEP income age years_01 nbr_ch01 marita01 female;
    input _type_ $ _name_ $ columns[*];
    cards;
    N CNT 747.000000 747.000000 747.000000 747.000000 747.000000 747.000000
    MEAN AVG 22728.281124 42.479250 3.907631 0.714859 1.882195 0.559572
    STD STDDEV 22207.221405 19.114879 2.675634 1.103410 0.892051 0.496771
    SSCP INTERCEP 747.000000 16978026.000000 31732.000000 2919.000000 534.000000 1406.000000 418.000000
    SSCP income 16978026.000000 753779217048.000000 798771897.000000 68143689.000000 17316503.000000 35612419.000000 8290553.000000
    SSCP age 31732.000000 798771897.000000 1620524.000000 130921.000000 21784.000000 64058.000000 17696.000000
    SSCP years_01 2919.000000 68143689.000000 130921.000000 16747.000000 2010.000000 5475.000000 1629.000000
    SSCP nbr_ch01 534.000000 17316503.000000 21784.000000 2010.000000 1290.000000 1355.000000 295.000000
    SSCP marita01 1406.000000 35612419.000000 64058.000000 5475.000000 1355.000000 3240.000000 787.000000
    SSCP female 418.000000 8290553.000000 17696.000000 1629.000000 295.000000 787.000000 418.000000 	
    ;