topic Re: SAS DI Studio in SAS Data Management

SAS DI Studio

JJP1 — Wed, 05 Feb 2020 12:55:46 GMT

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

Re: SAS DI Studio

ed_sas_member — Wed, 05 Feb 2020 13:05:57 GMT

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,

Re: SAS DI Studio

JJP1 — Wed, 05 Feb 2020 13:27:12 GMT

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

Re: SAS DI Studio

ErikLund_Jensen — Wed, 05 Feb 2020 15:52:30 GMT

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;