Automatic SAS Help and Dictionary Dataset/libraries comparison?

Reply
Contributor
Posts: 46

Automatic SAS Help and Dictionary Dataset/libraries comparison?

HI,

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.

Thanks.

Super User
Posts: 19,105

Re: Automatic SAS Help and Dictionary Dataset/libraries comparison?

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.

Contributor
Posts: 46

Re: Automatic SAS Help and Dictionary Dataset/libraries comparison?

Thanks very much. That makes perfect sense in my understanding

Ask a Question
Discussion stats
  • 2 replies
  • 133 views
  • 0 likes
  • 2 in conversation