topic how to export the explorer properties columns for a data dictionary comparison in Excel in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-export-the-explorer-properties-columns-for-a-data/m-p/144375#M261855 <HTML><HEAD></HEAD><BODY><P>how to</P></BODY></HTML> Thu, 14 Nov 2013 21:05:04 GMT mspey 2013-11-14T21:05:04Z how to export the explorer properties columns for a data dictionary comparison in Excel https://communities.sas.com/t5/SAS-Programming/how-to-export-the-explorer-properties-columns-for-a-data/m-p/144375#M261855 <HTML><HEAD></HEAD><BODY><P>how to</P></BODY></HTML> Thu, 14 Nov 2013 21:05:04 GMT https://communities.sas.com/t5/SAS-Programming/how-to-export-the-explorer-properties-columns-for-a-data/m-p/144375#M261855 mspey 2013-11-14T21:05:04Z Re: how to export the explorer properties columns for a data dictionary comparison in Excel https://communities.sas.com/t5/SAS-Programming/how-to-export-the-explorer-properties-columns-for-a-data/m-p/144376#M261856 <HTML><HEAD></HEAD><BODY><P>Hit the data dictionaries instead <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P><P></P><P>Check SASHELP.VTABLE and query that or look into proc contents or proc dataset.</P></BODY></HTML> Thu, 14 Nov 2013 21:09:31 GMT https://communities.sas.com/t5/SAS-Programming/how-to-export-the-explorer-properties-columns-for-a-data/m-p/144376#M261856 Reeza 2013-11-14T21:09:31Z Re: how to export the explorer properties columns for a data dictionary comparison in Excel https://communities.sas.com/t5/SAS-Programming/how-to-export-the-explorer-properties-columns-for-a-data/m-p/144377#M261857 <HTML><HEAD></HEAD><BODY><P>For variable properties it would be Vcolumns or the dictionary.columns in SQL;</P><P></P><P>Proc sql;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; select *</P><P>&nbsp;&nbsp;&nbsp;&nbsp; from Dictionary.columns where libname='LIBRARY' and memname='DATASET';</P><P>quit;</P><P></P><P>The library name and data set name are in caps as that is the way the data is stored in data view.</P></BODY></HTML> Thu, 14 Nov 2013 22:37:38 GMT https://communities.sas.com/t5/SAS-Programming/how-to-export-the-explorer-properties-columns-for-a-data/m-p/144377#M261857 ballardw 2013-11-14T22:37:38Z