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 2024

Innovate_SAS_Blue.png

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. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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