Quick Example

 

This example loads a fixed width text data file with more than 200k records, calculates a crosstab between 2 dimensions, and saves the workspace to a file. The total execution time for all 3 steps is just under 2 seconds (1.891221)

Load data

Script:

load "cola.dat"
    hhid  measure   ( 1 8 ),
    date  dimension ( 9 2 ),
    cat   dimension ( 11 2 ) [ cola 1, uncola 2, water 3 ],
    brand dimension ( 13 2 ) [ coke 1, pepsi 2, rc 3, sprite 4,
                               fanta 5, mist 6, desani 7, aqua 8, perrier 9 ],
    type  dimension ( 15 2 ) [ reg 1, diet 2 ],
    pkg   dimension ( 17 2 ) [ can 1, bot 2 ]
    ;

Result:

Rows Loaded: 232882
Execution time: 00:00:01.6923687

Get a report

 

Script:

Total count [ brand ] [ cat ];

Result:

  cat_cola cat_uncola cat_water
  Count Count Count
brand_coke 21203 0 0
brand_pepsi 12814 0 0
brand_rc 8479 0 0
brand_sprite 0 42596 0
brand_fanta 0 34615 0
brand_mist 0 43279 0
brand_desani 0 0 4425
brand_aqua 0 0 43924
brand_perrier 0 0 21547

Execution time: 00:00:00.0597251

 

Save File

Script:

save "soda.oc";

Result:

 

File Size: 490 KBs
Execution time: 00:00:00.1391272