How can i register the below mentioned tables using SAS DI studio.i tried to see under SASHELP library and i did not found tables and columns datasets that are under
dictionary library.please suggest
dictionary.tables
,dictionary.columns
Hi @JJP1
As far as I know, Dictionary.tables can only be accessed by running a PROC SQL.
You can also access a Dictionary table by referring to the PROC SQL view of the table that is stored in the Sashelp library.
e.g. SASHELP.Vtable
e.g. SASHELP.VColumn
Best,
i know under SASHELP library as these vtable and vcolumn and i can see this in SAS DI while regietering.
But i want to register tables,columns dataset from dictionary library.
any suggestion please
Hi @JJP1
There is a work-around. You can manually use proc SQL to create a view on the table in a permanent library, and then register the view and use it like it was the "real" dictionary table:
proc sql;
create view dw1sasme.dict_table as
select * from dictionary.tables;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.