Big Data - Module 2 In Memory Stats 4 dim xtab

[odesh]

Hello,

Please see attached. 

Why is the group by statement "  .../groupby = (cat_input2 cat_input2)  

and NOT ".../groupby = (cat_input2 cat_input3)  ?  

What additional info is generated by having another identical dimension ?

Thanks.

Odesh.

[Cynthia_sas]

Hi:
I've sent your question to the instructors.
Cynthia

[AndyRavenna · Accepted solution]

Hi,

The point of that example was to create a 4-way crosstab. Unfortunately, the banking data table only had a limited number of categorical variables. That is the reason that cat_input2 is used twice. You are correct in suggesting that if there had been a cat_input3 variable, we could have used it there. Unfortunately, the data table does not contain that variable. 

Hope this is helpful,

Andy

[odesh]

Hi Andy,
Thanks for the quick succinct reply. This is very helpful

Odesh.

[AndyRavenna]

You are most welcome!
Andy