Tables & Columns SAS

[Srigyan]

I was using dictionary.tables & dictionary.columns table, but I am not aware what each column means from both the table.

Can some one explain each column, I know many are self explanatory, but I am not sure about all.Please help...

[Kurt_Bremser]

Look at the labels of the columns in the dirctionary tables:

proc sql;
title 'Dictionary.Tables';
select name, label from dictionary.columns
where libname = 'SASHELP' and memname = 'VTABLE';
title 'Dictionary.Columns';
select name, label from dictionary.columns
where libname = 'SASHELP' and memname = 'VCOLUMN';
quit;

Please state which are still cryptic to you.

[s_lassen]

I think the easiest way to get the information is this:

proc sql;
  describe table dictionary.tables;
  describe table dictionary.columns;
quit;

But I understand your frustration, there does not seem to be any other documentation of this on support.sas.com, only for FEDSQL, and I am not sure if that's the same.

[ballardw]

The online documentation that I have for SAS 9.4 has entries for dictionary tables for both basic language concepts and FedSQL.

[Reeza]

https://documentation.sas.com/?docsetId=sqlproc&docsetVersion=9.4&docsetTarget=n02s19q65mw08gn140bwf...

There's a lot of columns, explaining each one would take way too much time. Is there a specific question you have that the label does not answer.

---

@Srigyan wrote:

I was using dictionary.tables & dictionary.columns table, but I am not aware what each column means from both the table.

Can some one explain each column, I know many are self explanatory, but I am not sure about all.Please help...

---