Promote tables from session scope to global scope in caslib

[dishenpancholi]

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

[DerylHollick]

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;