LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2007, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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>
Organization:   http://groups.google.com
Subject:   Re: DICTIONARY.COLUMNS
Comments:   To: sas-l@uga.edu
Content-Type:   text/plain; charset=ISO-8859-1

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;


Back to: Top of message | Previous page | Main SAS-L page