Hi,   I am trying to execute the below SAS code in SAS Viya CAS environment and it took a long time as it is not using the CAS worker nodes. The log shows the session is using 0 worker node.   // code    cas MySession sessopts=(caslib=casuser); libname mycas cas caslib=casuser; proc casutil; load data=sashelp.cars replace; run; data mycas.bigcars; set mycas.cars; do i=1 to 150000; output; end; run; data mycas.bigcars_score; set mycas.bigcars; length myscore 8; myscore=0.3*Invoice/(MSRP-Invoice) +0.5*(EngineSize+Horsepower)/Weight + 0.2*(MPG_City+MPG_Highway); Thread=_threadid_; run;   //log info 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 56 57 58 cas MySession sessopts=(caslib=casuser); NOTE: The session MYSESSION connected successfully to Cloud Analytic Services rpclab03045.exnet.sas.com using port 5570. The UUID is cd58cd44-5125-0445-b613-019d12ffb677. The user is viyauser and the active caslib is CASUSER(viyauser). NOTE: The SAS option SESSREF was updated with the value MYSESSION. NOTE: The SAS macro _SESSREF_ was updated with the value MYSESSION. NOTE: The session is using 0 workers. NOTE: 'CASUSER(viyauser)' is now the active caslib. NOTE: The CAS statement request to update one or more session options for session MYSESSION completed. 59 libname mycas cas caslib=casuser; NOTE: Libref MYCAS was successfully assigned as follows: Engine: CAS Physical Name: cd58cd44-5125-0445-b613-019d12ffb677 60 61 proc casutil; NOTE: The UUID 'cd58cd44-5125-0445-b613-019d12ffb677' is connected using session MYSESSION. 62 62 ! load data=sashelp.cars replace; NOTE: SASHELP.CARS was successfully added to the "CASUSER(viyauser)" caslib as "CARS". 63 run;   64   NOTE: PROCEDURE CASUTIL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   65 data mycas.bigcars;   66 set mycas.cars; 67 do i=1 to 150000; 68 output; 69 end; 70 run;   NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads. NOTE: There were 428 observations read from the table CARS in caslib CASUSER(viyauser). NOTE: The table bigcars in caslib CASUSER(viyauser) has 64200000 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 45.17 seconds cpu time 0.01 seconds     71 72 data mycas.bigcars_score; 73 set mycas.bigcars; 74 length myscore 8; 75 myscore=0.3*Invoice/(MSRP-Invoice) 76 +0.5*(EngineSize+Horsepower)/Weight + 0.2*(MPG_City+MPG_Highway); 77 Thread=_threadid_; 78 run;   NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads. NOTE: There were 64200000 observations read from the table BIGCARS in caslib CASUSER(viyauser). NOTE: The table bigcars_score in caslib CASUSER(viyauser) has 64200000 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 23.69 seconds cpu time 0.00 seconds ... View more

I need to create a  decision flow in SAS RTDM which reads the table data as input parameter and insert the data into that table. I need to make this as a REST API call which invokes this decision flow and processes the input table data as a JSON parameter. E.g   { "version":"1", "correlationId":"a325f232-982c", "clientTimeZone":"UTC", "inputs":{ "visitorIdentification":"demo@sample.com", "sample":[ { "metadata":[ { "action":"string" }, { "targetType":"string" }, ] }, { "data":[ [ "TopOfPage", null, ], [ "BottomOfPage", null, ], [ "Replace", "Name", ] ] } ] } }   As I am new to RTDM, please let me have your inputs on how to start with this?   Regards, Siva ... View more

Hi, Is there a SAS fucntion to check whether the field value is numeric or decimal. Please anyone can advise? Regards, Siva ... View more