|Date: ||Fri, 23 Nov 2007 09:34:50 -0800|
|Reply-To: ||nichas <sachin.gadkar@GMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||nichas <sachin.gadkar@GMAIL.COM>|
|Subject: ||Re: DICTIONARY.COLUMNS|
|Content-Type: ||text/plain; charset=ISO-8859-1|
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
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..
now go and check in sashelp.vcolumn the name and age variables are
Keep surfing the other sashelp.vtable , sashelp.vmacro etc.. they are
also to store the information dynamically.
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.
> viewTable sashelp.vcolumn
> The describe statement of SQL will show the relationship with
> proc sql;
> describe view sashelp.vcolumn;
> describe table dictionary.columns;