topic Re: where is dictionary.columns in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/where-is-dictionary-columns/m-p/58625#M16459 <HTML><HEAD></HEAD><BODY><P>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</P><P>views are accessible from any SAS proc or data step as well as the SAS explorer window.</P></BODY></HTML> Mon, 09 Apr 2012 13:58:04 GMT Hima 2012-04-09T13:58:04Z where is dictionary.columns https://communities.sas.com/t5/SAS-Procedures/where-is-dictionary-columns/m-p/58624#M16458 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I have a question:we can use dictionary.columns dataset to gather information of any datasets in SAS but</P><P></P><P>Where is dictionary.columns dataset?</P><P></P><P>Thanks !</P></BODY></HTML> Mon, 09 Apr 2012 13:31:53 GMT https://communities.sas.com/t5/SAS-Procedures/where-is-dictionary-columns/m-p/58624#M16458 George_S 2012-04-09T13:31:53Z Re: where is dictionary.columns https://communities.sas.com/t5/SAS-Procedures/where-is-dictionary-columns/m-p/58625#M16459 <HTML><HEAD></HEAD><BODY><P>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</P><P>views are accessible from any SAS proc or data step as well as the SAS explorer window.</P></BODY></HTML> Mon, 09 Apr 2012 13:58:04 GMT https://communities.sas.com/t5/SAS-Procedures/where-is-dictionary-columns/m-p/58625#M16459 Hima 2012-04-09T13:58:04Z Re: where is dictionary.columns https://communities.sas.com/t5/SAS-Procedures/where-is-dictionary-columns/m-p/58626#M16460 <HTML><HEAD></HEAD><BODY><P>They are VIEWS in the SASHELP library. The DICTIONARY entries start their names with V. So DICTIONARY.COLUMNS is SASHELP.Vcolumn.</P></BODY></HTML> Mon, 09 Apr 2012 15:21:09 GMT https://communities.sas.com/t5/SAS-Procedures/where-is-dictionary-columns/m-p/58626#M16460 ballardw 2012-04-09T15:21:09Z