topic Re: Tables & Columns SAS in SAS Programming

Tables & Columns SAS

Srigyan — Thu, 13 Dec 2018 11:23:07 GMT

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...

Re: Tables & Columns SAS

Kurt_Bremser — Thu, 13 Dec 2018 11:30:29 GMT

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.

Re: Tables & Columns SAS

s_lassen — Thu, 13 Dec 2018 12:21:29 GMT

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.

Re: Tables & Columns SAS

ballardw — Thu, 13 Dec 2018 15:14:23 GMT

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

Re: Tables & Columns SAS

Reeza — Thu, 13 Dec 2018 16:18:38 GMT

https://documentation.sas.com/?docsetId=sqlproc&docsetVersion=9.4&docsetTarget=n02s19q65mw08gn140bwfdh7spx7.htm&locale=en

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...