topic Re: Save column info to a dataset in CAS in SAS Programming

Save column info to a dataset in CAS

ProtoLithic — Wed, 25 Oct 2023 02:54:30 GMT

Hi -

I'm trying to save the results of proc cas to a datset. Specifically, using the code below, but it fails. There's no descriptive error, it just returns "Execution Halted". It works without the saveresult part, though, so that seems to be the problem.

proc cas;
   table.columninfo result = cinfo /
     table={caslib="Library",name="Table"};
   saveresult cinfo casout={caslib="Library",name="Variable_Info"}
   ;
quit;

Re: Save column info to a dataset in CAS

Patrick — Wed, 25 Oct 2023 07:01:37 GMT

Using Form 3 syntax as per documentation for the SAVERESULT Statement works for me in a SAS Viya 4 environment.

cas mysess cassessopts=(caslib="casuser");

libname casuser cas;

data casuser.class;
    set sashelp.class;
run;

proc cas;
  table.columninfo result=cinfo / table={caslib="casuser", name="class"};
  saveresult cinfo caslib="casuser" casout="class_layout" replace;
quit;