Retrieving All Objects in SAS DI

Reply
Contributor
Posts: 70

Retrieving All Objects in SAS DI

Hello everyone,

I'm looking for a way to be able to pull in all the objects created in SAS DI studio.

I first looked to the dictionary and sashelp but they are not pulling information from the environment really.

Any suggestions.

proc sql;

   describe table dictionary.tables;

proc sql;

   describe view sashelp.vtable;

proc sql;

   title 'All Tables and Views in the SQL Library';

   select libname, memname, memtype, nobs

      from dictionary.tables;

proc sql;

   select * from sashelp.VLIBNAM;

proc sql;

   title 'All Tables and Views in the SQL Library';

   select * from dictionary.tables;

Respected Advisor
Posts: 3,894

Re: Retrieving All Objects in SAS DI

SAS DI Studio is SAS Metadata driven. So what you create there is stored in the SAS Metadata repository.

The "physical" objects like SAS tables get only created once you execute code on the SAS server.

Contributor
Posts: 70

Re: Retrieving All Objects in SAS DI

Thank you Patrick that definitely helps.

Ask a Question
Discussion stats
  • 2 replies
  • 172 views
  • 0 likes
  • 2 in conversation