how to export the explorer properties columns for a data dictionary comparison in Excel

[mspey]

how to

[Reeza]

Hit the data dictionaries instead

Check SASHELP.VTABLE and query that or look into proc contents or proc dataset.

[ballardw]

For variable properties it would be Vcolumns or the dictionary.columns in SQL;

Proc sql;

     select *

     from Dictionary.columns where libname='LIBRARY' and memname='DATASET';

quit;

The library name and data set name are in caps as that is the way the data is stored in data view.