I read in your post that you're after metadata and I think: "extract information about extended attributes for tables".
You can use the CLI and REST APIs mentioned in the answer in this post.
Just recently I had to pull out 'metadata' for some CAS tables, specifically the columns, type and lengths. I needed this information to help me code a CAS Star Schema view.
I did this using SAS9 code:
You can get this CAS table information a couple of ways in SAS 9 code:
1) using Proc CASUtil, with the contents statement https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/casref/p0e32z0e8q5ge6n1fk1u8cuhzj4g.htm
This returns output similar to the proc contents;
2) Using Proc CAS with the table.tabledetails actionset. Note that this action set may not be available in earlier versions of 9.4M5
You can wrap your proc code with ods statements to get the output into datasets like this:
%let table=FACT_XXX;
/*ods trace on;*/
ods output TableInfo=TableInfo;
ods output TableDetails=TableDetails;
ods output ColumnInfo=ColumnInfo;
proc casutil;
contents incaslib="dev_AAAA" casdata="&table";
quit;
ods trace off;
I could then post process the ColumnInfo dataset and used that to generate code for creating a star schema view
Mark
... View more