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

Reply
N/A
Posts: 1

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

how to

Super User
Posts: 19,792

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

Hit the data dictionaries instead Smiley Happy

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

Super User
Posts: 11,343

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

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.

Ask a Question
Discussion stats
  • 2 replies
  • 297 views
  • 2 likes
  • 3 in conversation