Hi,

dictionary.columns are same as sashelp.vcolumn ( v in vcolumn means views ) views are basically logical linking of data rather than creating the data physically. thats why view table are of less memory size than the actual table. lets try with an example

data column; set sashelp.vcolumn; run;

now go and check the size of sashelp.vcolumn ( its 5kb in my system) and see column ( its 353kb ). the size of column table is very large with respect to sashelp.vcolumn.

Moreover the dictionary tables have the dynamic created information. Say if u create a table now.. data test; name='nich'; age=12; run;

now go and check in sashelp.vcolumn the name and age variables are created there. Keep surfing the other sashelp.vtable , sashelp.vmacro etc.. they are also to store the information dynamically. thanks

On Nov 23, 6:21 pm, Peter <crawfordsoftw...@gmail.com> wrote: > On 23 Nov, 13:11, ash007 <RamsamyAsh...@gmail.com> wrote: > > > hello, > > > is someone know how to watch the table DICTIONARY.COLUMNS ? > > > thank. > > try > > viewTable sashelp.vcolumn > > The describe statement of SQL will show the relationship with > dictionary.columns > > proc sql; > describe view sashelp.vcolumn; > describe table dictionary.columns; > quit;