09-25-2014 10:55 PM
does SAS Help library dataset VCOLUMN and Dictionary.Vcolumn functionally the same? Can anybody please advise me how best and effectively both the former and latter is used and for what purpose?If there is a difference, what's the difference?
I have done my research online and with books, but I am struggling in understanding the application of the concepts.I'd appreciate anybody explaining with an example.
09-25-2014 11:07 PM
SASHELP.VCOLUMNS is a view of Dictionary.Column
You can see this by right clicking on the view in the SASHELP library and run the "Describe SQL" to see the code.
Some people prefer using Dictionary.Column because using a table may be marginally faster than the view, but I haven't seen any performance difference.