Hello
I have been following examples from book "SAS Viya: The R Perspective". I am facing some issues when executing code. Maybe someone can help me out, maybe the syntax or parameters have changed since the release of this book.
Using cas.table.columnInfo(cars) works correctly but cas.table.tableInfo(cars) gives an error:
Secondly, loading regression actionset:
cas.builtins.loadActionSet(conn, 'regression') gives also an error:
When I use instead loadActionSet(conn, 'regression') I'll get another kind of error:
For comparison, then loading decision tree action set works just fine:
loadActionSet(conn, 'decisiontree')
Finally, in order to get rid of CAS table groupby functionality I should use quotes like this: cars@groupby<- ''
but this gives me an error when trying to calculate new summary:
@Rain ,
Please repeat the problem and show me the most recent CAS server log files from /opt/sas/viya/config/var/log/cas/default directory (from all CAS nodes).
Hi @alexal.
This is what I got from Viya logs not much. Basically the same messages as previously:
2020-04-02T09:10:13,682 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:4250] - ++ action table.columnInfo / table={name='cars'}, _messageLevel='note';
2020-04-02T09:10:13,689 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:6088] - -- 'table.columnInfo' SUCCESSFUL.
2020-04-02T09:10:13,915 INFO [09776584] firstname.lastname local MAIN NoUser [tkident.c:1233] - User firstname.lastname successfully authenticated using the OAuth authentication provider.
2020-04-02T09:10:13,952 INFO [09776585] firstname.lastname local MAIN NoUser [tkident.c:1233] - User firstname.lastname successfully authenticated using the OAuth authentication provider.
2020-04-02T09:10:14,071 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:6088] - -- 'table.tableInfo' FAILED. Error parsing action parameters.
2020-04-02T09:11:22,317 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:4250] - ++ action builtins.loadActionSet / actionSet='regression', _messageLevel='note';
2020-04-02T09:11:22,348 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:7340] - Could not load action set 'regression'.
2020-04-02T09:11:22,351 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:6088] - -- 'builtins.loadActionSet' FAILED. 0x88bfc191
2020-04-02T09:11:22,507 INFO [09776810] firstname.lastname local MAIN NoUser [tkident.c:1233] - User firstname.lastname successfully authenticated using the OAuth authentication provider.
2020-04-02T09:11:22,578 INFO [09776811] firstname.lastname local MAIN NoUser [tkident.c:1233] - User firstname.lastname successfully authenticated using the OAuth authentication provider.
2020-04-02T09:11:22,766 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:4250] - ++ action builtins.actionSetInfo / extensions={'regression'}, _messageLevel='note';
2020-04-02T09:11:22,769 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:6088] - -- 'actionSetInfo' SUCCESSFUL.
2020-04-02T09:13:50,805 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcastaba.c:3108] - Accessed session table CARS loaded in caslib CASUSER(firstname.lastname).
2020-04-02T09:13:50,807 INFO [00000007] cas local 9914 firstname.lastname 580088 [tkcasaimp.c:6088] - -- 'simple.summary' FAILED. A required column does not exist in the table.
Thank you
Rain
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.