topic Re: Big Data - Module 2 In Memory Stats 4 dim xtab in SAS Academy for Data Science

Big Data - Module 2 In Memory Stats 4 dim xtab

odesh — Tue, 24 Sep 2019 18:48:25 GMT

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.

Re: Big Data - Module 2 In Memory Stats 4 dim xtab

Cynthia_sas — Wed, 25 Sep 2019 01:04:50 GMT

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

Re: Big Data - Module 2 In Memory Stats 4 dim xtab

AndyRavenna — Wed, 25 Sep 2019 14:03:10 GMT

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

Re: Big Data - Module 2 In Memory Stats 4 dim xtab

odesh — Wed, 25 Sep 2019 14:41:25 GMT

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

Odesh.

Re: Big Data - Module 2 In Memory Stats 4 dim xtab

AndyRavenna — Wed, 25 Sep 2019 14:47:32 GMT

You are most welcome!
Andy