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.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

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