SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
jdmarshg
Obsidian | Level 7

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;

2 REPLIES 2
Patrick
Opal | Level 21

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.

jdmarshg
Obsidian | Level 7

Thank you Patrick that definitely helps.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 619 views
  • 0 likes
  • 2 in conversation