Hello, As usual, please refer to the attached printscreen for I ( uppercase or big i ) in the DS2 ( and Base SAS programs).   Is "I" part of the PDV or is it defined somewhere ? "i" ( lowercase or small i is the array index variable. But this is not the same as I ? Is it ?   I must be missing something here.   Thanks. Odesh.  ... View more

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. ... View more

Hello, Please refer to the attached question.  I am not sure what the suggested answer means by "SORT BY provides reducer level sorting instead of job level sorting".   I know what ORDER BY means in the context of PROC SQL and DBMS's in general.   Thanks. Odesh.   ... View more

Hello, Please refer to the attachment. This is part of the solution of the last exercise in Chapter 4. There are 5 lines of Pig Latin code and I am not sure that I am understanding the logic correctly and completely. I am writing down what I think is being done . Please tell me where I am correct and where I am not.    line 1: a = " loads mobydick text file into DIHPS folder. ( in Hive ? )   line 2: b = "For each row in "a" above ( that is in the mobydick text file ) put words separately on each consecutive physical line.                   Why do we need a flatten statement here ? Would the TOKENIZE statement not be enough ?   line 3: c = "Are we grouping each row in Step a by "word". Can you please give an example here to clarify ?   line 4: d = "Are we counting the number of occurrences of a given word. For example a word like "whale" might have been used about                  4000 times in the book.   line 5: We store a table with 2 columns in a table called pig_wordcount in the DIHPS  back on the SAS server.   Thanks. Odesh.           ... View more