topic Promote tables from session scope to global scope in caslib in SAS Programming

Promote tables from session scope to global scope in caslib

dishenpancholi — Tue, 21 Feb 2023 23:32:18 GMT

Hi Everyone,

I am writing datasets from a SAS Base library to a CASLIB using the below code.

proc datasets lib=dash; /* This is my SAS Base library */

copy out=cldast; /* This is my CASLIB */

run;

Now I want these tables to be available in SAS VA for which I believe I will have to promote the datasets in the CASLIB to a global scope. Is there a way to promote all the tables at once or do I need to promote each table one by one using the CASUTIL PROMOTE procedure.

Thank you in advance for your help.

Dishen

Re: Promote tables from session scope to global scope in caslib

DerylHollick — Tue, 28 Feb 2023 03:36:52 GMT

I don't see a way to do this with proc datasets (nor proc copy) but it would be nice to have. Maybe something like:

proc datasets lib=dash; 
copy out=cldast promote=yes; 
run;

You could suggest it: https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas

In the meantime, proc cas can be used to promote all the tables in a caslib:

proc cas;
  table.tableinfo result=tablesToPromote / caslib="cldast";
  do i = 1 to dim(tablesToPromote.TableInfo);
      tname = tablesToPromote.TableInfo[i,'Name'];
      table.promote / caslib="cldast" name=tname;
  end;
quit;