The computed column node sims to have an issue. I will use the Query in stead that is working properly.   Thanks! ... View more

Hi, Thanks for your answer.   I get the following into the log  so i guess case is not a valid way for the condiitonal proceccing.   ANt ideas?   Thnaks     NOTE: The data set WORK._TMP_0F2A7CAC2D8C11EF87B43A81D86 has 0 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds     138 139 data null; 140 set work._tmp_0f2a7cac2d8c11ef87b43a81d86; 141 __valid_expr=case (Order_Type) ---- 68 142 when 1 then 2.5 ---- 22 76 ERROR 68-185: The function CASE is unknown, or cannot be accessed.   ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.   ERROR 76-322: Syntax error, statement will be ignored.   ... View more

Thnaks Russ and all the friends that contributed to my question.    You were right, i checked carefully the code that is downloaded from the SAS Visual Text Analytics and i can score a new data set by filling in the macro variables. Actually the scored data set is saved in a cas library called sascas1 that is created by the code, although i set the library to casuser. This is why i could not find the scored data set and i initiated the post. So if someone else tries this action the scored data set can be found in the sascas1 cas library.   /* specifies the CAS library to write the score output table. You must modify the value to provide the name of the library that will contain the output table that the score code produces. */ %let output_caslib_name = "casuser";   cas sascas1 host=&cas_server_hostname port=&cas_server_port; libname sascas1 cas sessref=sascas1 datalimit=all;     Thanks! ... View more

Hi koen, Thanks for your answer. When I download the code from visual text analytics Viya for learners- topics node - I get two files astorescorecode.sas and topicsmodel.astore. I don't get any ep file. Any idea? ... View more

Hi Koen, Thanks for your answer. When i try to score with the created astore cas table i receive the following error: ERROR: Store contents have been modified. Cannot continue. ERROR: Action score failed. ERROR: The action stopped due to errors.   Any ideas?   proc cas; 123 session mysess; 124 loadactionset "astore"; 125 126 action astore.score; 127 param 128 table={caslib=&input_caslib_name, name=&input_table_name} 129 rstore={caslib=&input_astore_caslib_name, name=&input_astore_name} 130 out={caslib=&output_caslib_name, name=&output_table_name, replace=TRUE} 131 copyVars={&copy_vars_variables}; 132 ; 133 run; NOTE: Active Session now mysess. NOTE: Added action set 'astore'. ERROR: Store contents have been modified. Cannot continue. ERROR: Action score failed. ERROR: The action stopped due to errors. 134 quit; NOTE: PROCEDURE CAS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   135 136 137 138 %studio_hide_wrapper; 149 150     ... View more

Hi,   I read the instructions. I had forgotten to upload the astore table in cas.   I did it with the following proc:   %let local_astore_file_path = "/shared/home/azaras@aueb.gr/casuser"; %let input_astore_caslib_name = "casuser"; %let input_astore_name = "astore_2"; %let input_astore_name_unquoted = %qsysfunc(dequote(&input_astore_name)) proc astore; upload rstore=public.&input_astore_name_unquoted store=&local_astore_file_path; quit; The astore_2 is created in public. When i try to open it in the data grid i get the following:     I continue with the action astore score but since the uploaded into cas astore table has a problem there the code cannot run.     Any ideas what is the problem?   Thanks in advance,   Andreas   ... View more

I use the code at the end of the post.   I receive the following error: Any hints on how to score? ERROR: The caslib '{CASUSER}' does not exist. ERROR: Table '{ASRS}' could not be loaded. ERROR: Failure opening table '{ASRS}' ERROR: The caslib '{CASUSER}' does not exist. ERROR: The action stopped due to errors.           %let input_caslib_name = "{CASUSER}"; %let input_table_name = "{ASRS}"; %let copy_vars_variable = "{'docID', 'ID','Text', 'Target05'}"; %let output_caslib_name = "{CASUSER}"; %let output_documents_table_name = "SCORED_TA"; %let input_astore_caslib_name = "Analytics_Project_1bcf9786-5598-4242-a05c-8f6093fc9373"; %let input_astore_name = "53a5b832-c925-4ee9-b641-8a50f3226aae_TEXT_MODEL"; %let cas_server_hostname = "pdcesx23103.exnet.sas.com"; %let cas_server_port = 5570; cas sascas1 host=&cas_server_hostname port=&cas_server_port; libname sascas1 cas sessref=sascas1 datalimit=all; proc cas; session sascas1; loadactionset "astore"; action astore.score; param table={caslib=&input_caslib_name, name=&input_table_name} rstore={caslib=&input_astore_caslib_name, name=&input_astore_name} out={caslib=&output_caslib_name, name=&output_documents_table_name, replace=TRUE} copyVars={&copy_vars_variable}; ; run; quit;   ... View more

You are correct. Thanks! ... View more

Hi again! In the pos table in my example is see around 63000 term but in the terms table i see around 11000. The 11000 are the kept terms as shown in the SAS Viosual Text Analytics so the dropped terms are the difference? Can i get the drop and keep lists that SAS uses by default? Thanks ... View more

Thanks! I managed to do ti witht his code. But what is the "pos" in the code? BR, Andreas ... View more