topic Re: cas in-memory table creation in SAS Programming

cas in-memory table creation

vallsas — Tue, 06 Sep 2022 19:18:50 GMT

proc casutil incaslib="public";
save casdata="name" outcaslib="public" replace;
run;

i am creating the cas table wih sashdat and in-memory table

with the above code cas table created but not in-memory table

with this code again i need to manually load the table in to cas in-memory.

i am expecting with the second screenshot symbol in-memory table with programming in sas studio.

any help pls..

Re: cas in-memory table creation

LinusH — Wed, 07 Sep 2022 06:08:50 GMT

I'm expecting that the SAVE statement is saving an already existing in-memory table to disk.

So your name table should already be in CAS memory.

What does the log say?

Re: cas in-memory table creation

vallsas — Wed, 07 Sep 2022 10:38:10 GMT

I did not check the log but in-memory table does not exist.

where should i check the log?

Re: cas in-memory table creation

SASKiwi — Wed, 07 Sep 2022 20:28:27 GMT

Where are you running PROC CASLIB? In SAS Studio or a different user interface? In SAS Studio, each program should have a log tab where your SAS log output should be displayed after you run the program.

Re: cas in-memory table creation

vallsas — Thu, 08 Sep 2022 17:08:57 GMT

yes, i am using sas studio and the log is below
%studio_hide_wrapper;
77
78 proc casutil ;
NOTE: The UUID '29a73618-47a3-a349-96bf-665595acd061' is connected using session MYSESS.
79 save casdata="MTEST" replace;
NOTE: Cloud Analytic Services saved the file MTEST.sashdat in caslib Public.
NOTE: The Cloud Analytic Services server processed the request in 0.002436 seconds.
80 run;
81
82 %studio_hide_wrapper;