Hello World, hello Falco, Is it possible to use the option "Path ranking count" directly in the path analysis report, so that a report user can change it?  Cheers, Klaus         ... View more

Hello World, We are trying to run a random forest model in SAS Viya 3.4 VDMML and keep getting this error. Does anyone know what this means? And what is meant by 'quota'? We have not set any OS quota. And maybe one more question where the astore file  _6WR5KOEIE2Y4J12PNBZEZAR3Y_AST is written to?   Thanks, Klaus     NOTE: Writing HTML5 Body file: ods.htm NOTE: Fileref _FR has been deassigned. NOTE: The file _TFREF is: Dateiname=/opt/sas/viya/config/var/tmp/compsrv/default/3246bba6-2709-4bed-b816-b70ff22102a8/SAS_workDA4200000E54_rviap0v01.dst .tk-inline.net/74b72ccd-f517-4a62-a07e-53a6196492be/traincode.sas, Besitzername=p226526,Gruppenname=tk, Zugriffsberechtigung=-rw-r--r--, Zuletzt geändert=05. Juni 2020 15.13 Uhr, Dateigröße (Byte)=0 NOTE: 19 records were written to the file _TFREF. The minimum record length was 3. The maximum record length was 93. NOTE: Verwendet wurde: DATA statement - (Gesamtverarbeitungszeit): real time 0.00 seconds cpu time 0.01 seconds NOTE: Using SEED=12345 for FOREST model building. NOTE: Wrote 10139446832 bytes to the savestate file _6WR5KOEIE2Y4J12PNBZEZAR3Y_AST. ERROR: Local CASLIB quota exceeded. ERROR: The action stopped due to errors. ... View more

Hello! I have downloaded the job log from the Environment Manager.  What format has it? How can I view it?    Cheers, Klaus       Example:   {"version":2,"name":"items","accept":"application/vnd.sas.compute.log.line","start":0,"items":[{"version":1,"type":"source","line":"1 %JESBEGIN"},{"version":1,"type":"normal","line":""},{"version":1,"type":"normal","line":">>> SAS Macro Variables:"},{"version":1,"type":"normal","line":" _ADDJESBEGINENDMACROS=true"},{"version":1,"type":"normal","line":" _APSLIST=_clientname,_csrf,_debug,_htua,_program,_rmtaddr,_rmthost,_url,_userlocale,_version,_xforward"},{"version":1,"type":"normal","line":" _CLIENTNAME=SASJobExecution"},{"version":1,"type":"normal","line":" _CONTEXTNAME=SAS Job Execution compute context"},{"version":1,"type":"normal","line":" _CSRF=9008e378-e7a6-4e5c-9cd3-90cca6f76b95"},{"version":1,"type":"normal","line":" _DEBUG=log"},{"version":1,"type":"normal","line":" _HTUA=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36"},{"version":1,"type":"normal","line":" _OMITJSONLISTING=true"},{"version":1,"type":"normal","line":" _OMITJSONLOG=false"},{"version":1,"type":"normal","line":" _OMITSESSIONRESULTS=true"},{"version":1,"type":"normal","line":" _OMITTEXTLISTING=true"},{"version":1,"type":"normal","line":" _OMITTEXTLOG=true"},{"version":1,"type":"normal","line":" _PROGRAM=/TKbisy/Pilot/UC Versicherungspfade/03 Jobs/SeqJobDef"},{"version":1,"type":"normal","line":" _REPLAY=/SASJobExecution/?_jobexec=/jobExecution/jobs/5c50b76a-a741-4b9d-a5f2-587f328cd4fc&_entry="},{"version":1,"type":"normal","line":" _RMTADDR=10.252.54.142"},{"version":1,"type":"normal","line":" _RMTHOST=10.252.54.142"},{"version":1,"type":"normal","line":" _SUPPRESS_MVARS= "},{"version":1,"type":"normal","line":" _URL=/SASJobExecution/"},{"version":1,"type":"normal","line":" _USERLOCALE=de_DE"},{"version":1,"type":"normal","line":" _VARIABLEFILTER=eq(name,'_STATUS_MESSAGE')"},{"version":1,"type":"normal","line":" _VERSION=SASJobExecution Version 2.1"},{"version":1,"type":"normal","line":" _XFORWARD=sas-viya-plattform-prod.dst.tk-inline.net"},{"version":1,"type":"title","line":" The SAS System"},{"version":1,"type":"title","line":""},{"version":1,"type":"normal","line":" SYS_COMPUTE_DATA=/opt/sas/viya/config/data/compsrv/default"},{"version":1,"type":"normal","line":" SYS_COMPUTE_JOB_ID=4C52BF3D-7B4E-EC43-B040-B3245C02A510"},{"version":1,"type":"normal","line":" SYS_COMPUTE_SESSION_ID=a9f81288-23e1-4fef-b74e-754ddbf15ebb-ses0000"},{"version":1,"type":"normal","line":" SYS_COMPUTE_SESSION_OWNER=P226526"},{"version":1,"type":"normal","line":" SYS_JES_JOB_URI=/jobExecution/jobs/5c50b76a-a741-4b9d-a5f2-587f328cd4fc"},{"version":1,"type":"normal","line":"\r\n"},{"version":1,"type":"normal","line":""},{"version":1,"type":"source","line":"2 /*****************************************************************************************************"},{"version":1,"type":"source","line":"3 * Job: SeqJobDef"},{"version":1,"type":"source","line":"4 * Beschreibung: UC Kündigerpfade: Test unterschiedlicher Setting für Proc Sequence"},{"version":1,"type":"source","line":"5 * Datum: 20.05.2020"},{"version":1,"type":"source","line":"6 * Autor: Klaus Rösner"},{"version":1,"type":"source","line":"7 ******************************************************************************************************/"},{"version":1,"type":"source","line":"8 "},{"version":1,"type":"source","line":"9 /*****************************************************************************************************"},{"version":1,"type":"source","line":"10 * Änderungshistorie:"},{"version":1,"type":"source","line":"11 *"},{"version":1,"type":"source","line":"12 * Datum Autor Änderung"},{"version":1,"type":"source","line":"13 * ----------------------------------------------------------------------------------------------------"},{"version":1,"type":"source","line":"14 *"},{"version":1,"type":"source","line":"15 *"},{"version":1,"type":"source","line":"16 *"},{"version":1,"type":"source","line":"17 *"},{"version":1,"type":"source","line":"18 ******************************************************************************************************/"},{"version":1,"type":"source","line":"19 "},{"version":1,"type":"source","line":"20 *----------------------------------------------------------------------------------------------------*;"},{"version":1,"type":"source","line":"21 * Optionen setzen;"},{"version":1,"type":"source","line":"22 *----------------------------------------------------------------------------------------------------*;"},{"version":1,"type":"source","line":"23 "},{"version":1,"type":"source","line":"24 *----------------------------------------------------------------------------------------------------*;"},{"version":1,"type":"source","line":"25 * SAS Programme inkludieren;"},{"version":1,"type":"source","line":"26 *----------------------------------------------------------------------------------------------------*;"},{"version":1,"type":"source","line":"27 "},{"version":1,"type":"source","line":"28 options cashost=\"rviap0v02.dst.tk-inline.net\" casport=5570;"},{"version":1,"type":"source","line":"29 "},{"version":1,"type":"source","line":"30 filename job filesrvc folderpath='/TKbisy/Pilot/UC Versicherungspfade/02 Sequential Rule Mining/Archiv/' filename='SAS Coaching"},{"version":1,"type":"source","line":"30 ! Action Set Pathing SAS Beispiel Daten.sas';"},{"version":1,"type":"source","line":"31 %include job /source;"},{"version":1,"type":"note","line":"NOTE: %INCLUDE (level 1) file JOB is file SAS Coaching Action Set Pathing SAS Beispiel Daten.sas."},{"version":1,"type":"source","line":"32 +"},{"version":1,"type":"source","line":"33 +*----------------------------------------------------Lauffähiges Programm mit \"proc cas pathing\""},{"version":1,"type":"source","line":"33 !+----------------------------------------------------"},{"version":1,"type":"source","line":"34 +----------------------------------------------------auf SAS Beispieldaten ----------------------------------------------------;"},{"version":1,"type":"source","line":"35 +"},{"version":1,"type":"source","line":"36 +"},{"version":1,"type":"source","line":"37 +/*Dokumentation Action Set: Sequence Action Set */"},{"version":1,"type":"source","line":"38 +/* https://documentation.sas.com/?docsetId=casanpg&docsetVersion=8.3&docsetTarget=n0gse7erokgd4un1gvqzehse1fkg.htm&locale=en*/"},{"version":1,"type":"source","line":"39 +"},{"version":1,"type":"source","line":"40 +"},{"version":1,"type":"source","line":"41 +/* Libname */"},{"version":1,"type":"source","line":"42 +cas casauto;"},{"version":1,"type":"note","line":"NOTE: The session CASAUTO connected successfully to Cloud Analytic Services rviap0v02.dst.tk-inline.net using port 5570. The UUID "},{"version":1,"type":"note","line":" is 8454dae2-c4f4-f148-a79f-48762d8ec39c. The user is P226526 and the active caslib is CASUSERHDFS(P226526)."},{"version":1,"type":"note","line":"NOTE: The SAS option SESSREF was updated with the value CASAUTO."},{"version":1,"type":"note","line":"NOTE: The SAS macro _SESSREF_ was updated with the value CASAUTO."},{"version":1,"type":"note","line":"NOTE: The session is using 4 workers."},{"version":1,"type":"source","line":"43 +libname mycas cas caslib=public;"},{"version":1,"type":"note","line":"NOTE: Libref MYCAS was successfully assigned as follows: "},{"version":1,"type":"title","line":" The SAS System"},{"version":1,"type":"title","line":""},{"version":1,"type":"note","line":" Engine: CAS "},{"version":1,"type":"note","line":" Physical Name: 8454dae2-c4f4-f148-a79f-48762d8ec39c"},{"version":1,"type":"source","line":"44 +"},{"version":1,"type":"source","line":"45 +"},{"version":1,"type":"source","line":"46 +/* What CAS sessions do I have running? */"},{"version":1,"type":"source","line":"47 +cas _all_ list;"},{"version":1,"type":"note","line":"NOTE: Session CASAUTO is ACTIVE using port 5570 and host rviap0v02.dst.tk-inline.net for user P226526. The session UUID is "},{"version":1,"type":"note","line":" 8454dae2-c4f4-f148-a79f-48762d8ec39c."},{"version":1,"type":"source","line":"48 +"},{"version":1,"type":"source","line":"49 +"},{"version":1,"type":"source","line":"50 +/* Zugriff auf die importierte Daten über print */"},{"version":1,"type":"source","line":"51 +/* eigener Import über \"Daten vorbereiten\" */"},{"version":1,"type":"source","line":"52 +/* Datei liegt hier: C: … */"},{"version":1,"type":"source","line":"53 +/* Daten sind Online hier zu finden http://support.sas.com/documentation/onlinedoc/viya/exampledatasets/retailbuys.csv */"},{"version":1,"type":"source","line":"54 +proc print data=mycas.retailbuys (obs=5);"},{"version":1,"type":"source","line":"55 +run;"},{"version":1,"type":"note","line":""},{"version":1,"type":"note","line":"NOTE: PROCEDURE PRINT used (Total process time):"},{"version":1,"type":"note","line":" real time 0.15 seconds"},{"version":1,"type":"note","line":" cpu time 0.04 seconds"},{"version":1,"type":"note","line":" "},{"version":1,"type":"note","line":""},{"version":1,"type":"source","line":"56 +"},{"version":1,"type":"source","line":"57 +"},{"version":1,"type":"source","line":"58 +/* Sequenzanalyse */"},{"version":1,"type":"source","line":"59 +proc cas;"},{"version":1,"type":"source","line":"60 + sequence.pathing / table={caslib=\"public\" name=\"retailbuys\"}"},{"version":1,"type":"source","line":"61 + item=\"product\""},{"version":1,"type":"source","line":"62 + time=\"proc_time\""},{"version":1,"type":"source","line":"63 + tran=\"customer_id\""},{"version":1,"type":"source","line":"64 + casOutSequTranMap={caslib=\"public\" name=\"casouttable\", replace=true}"},{"version":1,"type":"source","line":"65 + casout={caslib=\"public\" name=\"retailsequence\", replace=true}"},{"version":1,"type":"source","line":"66 + ;"},{"version":1,"type":"source","line":"67 + run;"},{"version":1,"type":"note","line":"NOTE: Active Session now CASAUTO."},{"version":1,"type":"note","line":"NOTE: Added action set 'sequence'."},{"version":1,"type":"normal","line":""},{"version":1,"type":"source","line":"68 +quit;"},{"version":1,"type":"note","line":""},{"version":1,"type":"note","line":"NOTE: PROCEDURE CAS used (Total process time):"},{"version":1,"type":"note","line":" real time 1.89 seconds"},{"version":1,"type":"note","line":" cpu time 0.07 seconds"},{"version":1,"type":"note","line":" "},{"version":1,"type":"note","line":""},{"version":1,"type":"source","line":"69 +"},{"version":1,"type":"source","line":"70 +"},{"version":1,"type":"source","line":"71 +"},{"version":1,"type":"source","line":"72 +/* Regellängen ermitteln */"},{"version":1,"type":"source","line":"73 +title \"Regellängen\";"},{"version":1,"type":"source","line":"74 +proc fedsql sessref=casauto;"},{"version":1,"type":"source","line":"75 + select distinct"},{"version":1,"type":"source","line":"76 + _ChainLength_ as ANZ_ChainLength_"},{"version":1,"type":"source","line":"77 + from"},{"version":1,"type":"source","line":"78 + public.retailsequence;"},{"version":1,"type":"source","line":"79 +quit;"},{"version":1,"type":"note","line":""},{"version":1,"type":"note","line":"NOTE: PROCEDURE FEDSQL used (Total process time):"},{"version":1,"type":"note","line":" real time 0.45 seconds"},{"version":1,"type":"title","line":" The SAS System"},{"version":1,"type":"title","line":""},{"version":1,"type":"note","line":" cpu time 0.01 seconds"},{"version":1,"type":"note","line":" "},{"version":1,"type":"note","line":""},{"version":1,"type":"source","line":"80 +title;"},{"version":1,"type":"source","line":"81 +"},{"version":1,"type":"source","line":"82 +"},{"version":1,"type":"source","line":"83 +*----------------------------------------------------ENDE Lauffähiges Programm mit \"proc cas pathing\""},{"version":1,"type":"source","line":"83 !+----------------------------------------------------;"},{"version":1,"type":"source","line":"84 +"},{"version":1,"type":"note","line":"NOTE: %INCLUDE (level 1) ending."},{"version":1,"type":"source","line":"85 %JESEND"},{"version":1,"type":"note","line":""}],"count":159,"limit":159,"links":[]}   ... View more

Hello SAS World! we use the SEQUENCE Procedure for churn analysis. The procedure does not seem to make full use of the available memory and CPUs. Does anyone know which performance parameters (Memsize, CPUcount, etc.) we can use to shorten the runtime? The compute server has 30 GB Memsize and 4 Cores and the Procedure use only 154 MB memory and 1 Core. And the real time for the processing of a subset of the real data is 1:04 h.   Cheers, Klaus     ... View more

Hello World, We have a problem executing a CAS action:  sequence.pathing . Does anyone know what the error message means? The program appears to be correct.   /*Dokumentation Action Set: Sequence Action Set */ /* https://documentation.sas.com/?docsetId=casanpg&docsetVersion=8.3&docsetTarget=n0gse7erokgd4un1gvqzehse1fkg.htm&locale=en*/ /* Libname */ cas seq; libname mycas cas caslib=PowerUserDM; /* What CAS sessions do I have running? */ cas _all_ list; /* Zugriff auf die Daten über print */ proc print data=mycas.VP_SEQUENCE_DATA (obs=5); run; /*Reduktion der Daten für diesen Test */ data mycas.VP_SEQUENCE_DATA_tmp promote ; set mycas.VP_SEQUENCE_DATA (obs = 10000); run; /* Sequenzanalyse */ proc cas; sequence.pathing / table={caslib="PowerUserDM" name="VP_SEQUENCE_DATA_tmp"} item="EREIGNIS_ANONYM" time="ZEIT" tran="VS_VERS_NR_ANONYM" casOutSequTranMap={caslib="casuser" name="casouttable", replace=true} casout={caslib="casuser" name="versicherten_sequence", replace=true} ; run; quit; cas seq terminate; Log:   OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 75 76 *----------------------------------------------------NICHT Lauffähiges Programm mit "proc cas pathing" auf artifiziellen 76 ! Daten----------------------------------------------------; 77 78 79 /*Dokumentation Action Set: Sequence Action Set */ 80 /* https://documentation.sas.com/?docsetId=casanpg&docsetVersion=8.3&docsetTarget=n0gse7erokgd4un1gvqzehse1fkg.htm&locale=en*/ 81 82 83 /* Libname */ 84 cas seq; NOTE: The session SEQ connected successfully to Cloud Analytic Services rviap0v02.dst.tk-inline.net using port 5570. The UUID is 544a6756-aa54-ad44-85c3-a8c0db933ac5. The user is P226526 and the active caslib is CASUSERHDFS(P226526). NOTE: The SAS option SESSREF was updated with the value SEQ. NOTE: The SAS macro _SESSREF_ was updated with the value SEQ. NOTE: The session is using 4 workers. 85 libname mycas cas caslib=PowerUserDM; NOTE: Libref MYCAS was successfully assigned as follows: Engine: CAS Physical Name: 544a6756-aa54-ad44-85c3-a8c0db933ac5 86 87 88 /* What CAS sessions do I have running? */ 89 cas _all_ list; NOTE: Session SEQ is ACTIVE using port 5570 and host rviap0v02.dst.tk-inline.net for user P226526. The session UUID is 544a6756-aa54-ad44-85c3-a8c0db933ac5. 90 91 92 /* Zugriff auf die Daten über print */ 93 proc print data=mycas.VP_SEQUENCE_DATA (obs=5); 94 run; NOTE: The PROCEDURE PRINT printed page 2. NOTE: Verwendet wurde: PROZEDUR PRINT - (Gesamtverarbeitungszeit): real time 1.57 seconds cpu time 0.18 seconds 95 96 97 /*Reduktion der Daten für diesen Test */ 98 data mycas.VP_SEQUENCE_DATA_tmp promote ; 99 set mycas.VP_SEQUENCE_DATA (obs = 10000); 100 run; NOTE: There were 10000 observations read from the data set MYCAS.VP_SEQUENCE_DATA. NOTE: The data set MYCAS.VP_SEQUENCE_DATA_TMP has 10000 observations and 3 variables. NOTE: The data set WORK.PROMOTE has 10000 observations and 3 variables. NOTE: Verwendet wurde: DATA statement - (Gesamtverarbeitungszeit): real time 0.22 seconds cpu time 0.05 seconds 101 102 /* Sequenzanalyse */ 103 proc cas; 104 sequence.pathing / table={caslib="PowerUserDM" name="VP_SEQUENCE_DATA_tmp"} 105 item="EREIGNIS_ANONYM" 106 time="ZEIT" 107 tran="VS_VERS_NR_ANONYM" 108 casOutSequTranMap={caslib="casuser" name="casouttable", replace=true} 109 casout={caslib="casuser" name="versicherten_sequence", replace=true} 110 ; 111 run; NOTE: Active Session now SEQ. NOTE: Added action set 'sequence'. ERROR: Connection failed. Server returned: Session reconnect failed: Could not find the specified session. 112 quit; NOTE: Verwendet wurde: PROZEDUR CAS - (Gesamtverarbeitungszeit): real time 46.16 seconds cpu time 1.89 seconds 113 114 cas seq terminate; NOTE: Libref MYCAS has been deassigned. NOTE: Deletion of the session SEQ was successful. NOTE: The default CAS session SEQ identified by SAS option SESSREF= was terminated. Use the OPTIONS statement to set the SESSREF= option to an active session. NOTE: Request to TERMINATE completed for session SEQ. 115 *----------------------------------------------------ENDE NICHT Lauffähiges Programm mit "proc cas pathing" auf artifiziellen 115 ! Daten----------------------------------------------------; 116 117 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 130 ... View more