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;
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.
Thank you Patrick that definitely helps.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.