Help using Base SAS procedures

where is dictionary.columns

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

where is dictionary.columns

Hello everyone,

I have a question:we can use dictionary.columns dataset to gather information of any datasets in SAS but

Where is dictionary.columns dataset?

Thanks !


Accepted Solutions
Solution
‎04-09-2012 11:21 AM
Super User
Posts: 11,343

Re: where is dictionary.columns

They are VIEWS in the SASHELP library. The DICTIONARY entries start their names with V. So DICTIONARY.COLUMNS is SASHELP.Vcolumn.

View solution in original post


All Replies
Regular Contributor
Posts: 233

Re: where is dictionary.columns

The dictionary tables are in library called DICTIONARY, a 9 letter libref, and as we know, SAS librefs are limited to 8 characters so the views are needed to get access to the dictionary tables in DATA and PROC steps. These views are in the SASHELP library. The Dictionary Tables are only accessible through PROC SQL whereas, the

views are accessible from any SAS proc or data step as well as the SAS explorer window.

Solution
‎04-09-2012 11:21 AM
Super User
Posts: 11,343

Re: where is dictionary.columns

They are VIEWS in the SASHELP library. The DICTIONARY entries start their names with V. So DICTIONARY.COLUMNS is SASHELP.Vcolumn.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 204 views
  • 3 likes
  • 3 in conversation