About Rain

Rain · ‎09-23-2020

@USP2405 did you find a solution to your problem? I am in similar situation. We have Viya environment and Python scripts from pilot project done outside SAS. Trying to understand if there's any change we can run Python scripts using SAS Viya end-user tools as it is without installing any third-party tools. These scripts produce csv files. @alexal, do you know if there's been advancements in this area as this post was originally posted several years ago. Thank you Rain

Rain · ‎05-14-2020

Hi @Cynthia_sas Is it possible to download datasets for practicing on my organisation environment? Or I have to use Virtual Lab? Thank you Rain

Rain · ‎04-02-2020

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

Rain · ‎04-01-2020

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 · ‎11-20-2019

Hi! Where can I find the next article in this series? Thank you. Rain

Rain · ‎09-24-2019

Hi. I have been browsing posts here(How to migrate SAS DI Jobs in SAS VIYA) and also looking at the presentations/documentation available from SAS to understand Viya ETL capabilities compared to SAS 9.4. Currently my understanding is that Viya: Doesn't have native graphical user interface tools like DI Studio or Enterprise Guide although you can interact with Viya through various transformations. SAS Studio on Viya doesn't have GUI interface like Studio on 9.4. Has limited scheduling possibilities compared to SAS 9.4. is more focused towards data scientists, analysts aiming to take advantage of Viya's new data mining and machine learning features and in-memory approach. Is this correct or am I missing something? I want to confirm that currently SAS 9.4 is the ETL platform for handling and running several hundred batch jobs in addition to about 15 concurrent active users. Rain

Rain · ‎08-07-2019

@ChandanKSAS did you receive any additional information regarding scheduling capabilities for Viya like it works for SAS 9.4? I am in process of trying to understand similar thing. Rain

Rain · ‎05-08-2019

Hi Ashish, unfortunately not- we weren't able to resolve our aim. Br. Rain

Rain · ‎01-07-2019

Thank you. I'll look into the proposed approaches.

Rain · ‎12-21-2018

Hi. I am using a compute window with data quality QKB functions and they return duplicate events I need to discard in next window. Here's an example: This compute window takes company names as inputs. Single unique row that acts as a key field: Company AB Industrial Company Mechanics Ltd Company BA Industrial etc Then I apply this function: <field-expr><![CDATA[bf3.matchcode("Name", 95, CompanyName, result95) return result95]]></field-expr> Output is company name and matchcode: Company AB Industrial, 42&BF&7R7B4#7B8$$$$$$$$$$$$ Company Mechanics Ldt, 42&BF&7Y~Y&87BF$$$$$$$$$$$$ Company BA Industrial, 42&BF&7R7B4#7B8$$$$$$$$$$$$ Because I am using matchcode sensitivity 95 then first and third company get similar matchode values. My aim is to have a lookup window with unique matchcode values so I can compare these to data coming from another source window. Any suggestion how I can get rid of duplicate matchode values? This means that input would be company name, matchode but output would be only unique matchode(this would become unique key field also). Ideally my previous example would produce only two rows: 42&BF&7R7B4#7B8$$$$$$$$$$$$ 42&BF&7Y~Y&87BF$$$$$$$$$$$$ I tried union window(strict="false" output-insert-only="true") as it should prevent duplicate outputs but it seems to work only when duplicates origin from different windows that are connected to union window. We are using ESP 4.3.

Rain · ‎11-07-2018

We had similar issue when setting environmental variables for Event Stream Processing in Linux to use QKB. Although examples say "data folder" it meant actually "/opt/sas/viya/home/qkb/data/ci/29" for us. After changing DFESP_QKB Event Stream Processing was able to run data quality tasks in ESP project also.

Rain · ‎09-14-2018

Hi Fredrik. I maybe missed the whole logic from you suggestion but I took this boolean logic and now my filter looks like this: ( GetLength('parameter'p) > 0 ) AND ( 'parameter'p = 'County1'n ) And this actually did the trick. After clearing text input box and pressing enter nothing is shown as we wanted. Thank you.

Rain · ‎09-14-2018

Hi. Our aim is to have a list table showing only records that match one value typed inside text input control. I have create a new parameter with default value like this "select state". Applied that parameter to text input control. And also applied filter to list table that takes into consideration the value of parameter. Because "select state" value is not present in list table, nothing is displayed. Good so far. After user enters correct state values and presses Enter, list table again shows everything correctly. Now, the problem happens when user clears text input control and presses Enter, then parameter has lost it's default value and all the records are shown but in our case we shouldn't display all records but empty list table. Any suggestions how to achieve this? Rain

Rain · ‎09-14-2018

Hi. Not sure if this can be useful but we had a similar objective. But we used SAS Event Stream Processing to basically read messages from JMS queue and then after transforming data in ESP we streamed results to VA. We have set a time limit of 10 seconds so every 10 seconds all the events accumulating in ESP are sent to VA.

Rain · ‎07-17-2018

Hi. I have been wrestling in understanding how ESP file system adapter reads data from XML file. I have a xml file for example: <document> <queryid>1</queryid> <events> <event> <eventsequence>1123</eventsequence> </event> </events> </document> My current understanding is that tags <event><events> cannot be nested inside another tag. They must be first tags. Am I correct? Because when I remove <document> tag then ESP can read XML succesfully. Second observation: if I have a nested tag inside event tag then ESP will read values inside those tags not tags and values. For example <dog> <name>Boss</name> <weight>67</weight> </dog> will be read as <value name='dog'> Boss 67 </value> But when I include <![CDATA[ ]]> between <dog> and </dog> then tags and values are read correctly. <value name='dog'> <name>Boss</name> <weight>67</weight> </value> This second approach allows me to use functional window and parse nested XML. My aim is to understand if it's possible to read XML generated by third party application or do I need to have some requirements in place for that application so it produces XML that ESP can read.

Online Status	Offline
Date Last Visited	‎12-29-2020 05:58 AM

Re: Python using SAS Viya

Re: How do I obtain the dataset for Case Study Scenario and University...

Re: Errors when using R SWAT in SAS Viya 3.4

Errors when using R SWAT in SAS Viya 3.4

Re: Decision Tree in Layman’s Terms

Viya ETL capabilities

Re: Scheduling sas code/jobs in SAS Viya

Re: Customizing the new SAS Visual Analytics Hub 7.3

Re: Discarding duplicate events produced by QKB matchcode function

Discarding duplicate events produced by QKB matchcode function

Re: Python using SAS Viya

Promoting SAS Viya Job Flows

SAS Viya continues to open doors

Question about proc hpsplit in SAS Enterprise Miner

ESP Deployment – Viya Overlap and Differences

Re: Python using SAS Viya

Re: How do I obtain the dataset for Case Study Scenario and University...

Re: Errors when using R SWAT in SAS Viya 3.4

Errors when using R SWAT in SAS Viya 3.4

Re: Decision Tree in Layman’s Terms

Viya ETL capabilities

Re: Scheduling sas code/jobs in SAS Viya

Re: Customizing the new SAS Visual Analytics Hub 7.3

Re: Discarding duplicate events produced by QKB matchcode function

Discarding duplicate events produced by QKB matchcode function

Re: How to point the QKB

Re: VA 7.4: How to keep default "text input" control value

VA 7.4: How to keep default "text input" control value

Re: SAS Visual Analytics 7.4 streaming data visualization

Reading XML file into ESP project

SAS Analytics Explorers

SAS Global Forum 2018