SAS DI Studio

[JJP1]

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

[ed_sas_member]

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,

[JJP1]

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

[ErikLund_Jensen]

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;