BookmarkSubscribeRSS Feed
Rain
Obsidian | Level 7

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:
kustuta_mind_1.JPG

Secondly, loading regression actionset: 

cas.builtins.loadActionSet(conn, 'regression') gives also an error:

kustuta_mind_2.JPG

When I use instead loadActionSet(conn, 'regression') I'll get another kind of error:
kustuta_mind_3.JPG

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:
kustuta_mind_4.JPG

 

2 REPLIES 2
alexal
SAS Employee

@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).

Rain
Obsidian | Level 7

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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1178 views
  • 0 likes
  • 2 in conversation