topic Re: Error in CAS runCode Action in Developers

Error in CAS runCode Action

xiaoys0725 — Sat, 09 Sep 2017 17:51:30 GMT

Hello,

I have an issue with runCode Action and save Action.

1st one is the runCode Action. I submitted the following code, and cart is a cas table in a caslib called "MYCASLIB3".

proc cas;

datastep.runCode submit /

code =

"data cart;

length id 8 name $100 units 8 price 8;

id=1000;

name='iphone5s';

units=1;

price=4300;

run;";

run;

quit;

I should have only 1 row in the output, while I got 8 rows. No idea why it is 8 rows.

I also tried other codes like output statement, or "data cart;set work.cart;run;" every time I got 8 rows*the row I am supposed to have.

2st thing is when I used the save action. My save action is like this("proc cas" omitted):

table.save /

table="cart"

caslib="MYCASLIB3"

name="cart.sashdat"

replace=true;

run;

I found I cannot save the cart table into my cart.sashdat because I load the table from cart.sashdat and then fetched the table again and I still got the previous records. I also tried table={name="cart",caslib="MYCASLIB3"} and it still does not work.

Re: Error in CAS runCode Action

BrunoMueller — Mon, 11 Sep 2017 15:52:16 GMT

Have a look at the dataStep.runCode action, if you are not reading from any table, the code gets execute on each node, this is why you get the 8 output rows.

You can specify the SINGLE="NOINPUT" to run the code only one node

datastep.runCode submit  status=rc /
  
   single="noinput" code=sasCode
   ;
 print rc;

See also DATA Step Processing Modes for more information.

Re: Error in CAS runCode Action

xiaoys0725 — Mon, 11 Sep 2017 20:30:49 GMT

Thank you, it works now. May I ask if you know about CAS REST API? I got another issue about the api when I ran fetch action

Re: Error in CAS runCode Action

BrunoMueller — Tue, 12 Sep 2017 06:27:44 GMT

Please start a new thread with the question on the REST API.

Re: Error in CAS runCode Action

xiaoys0725 — Tue, 12 Sep 2017 19:53:44 GMT

Thank you I started one.

https://communities.sas.com/t5/About-SAS-Viya/Save-action-does-not-work-by-REST-api/m-p/395259#M73