How to find difference between metadata and physical data in SAS

dhruvakumar — Wed, 28 Aug 2019 12:23:31 GMT

Hi ALL,

Please help to provide how extract the data register in the metadata and compare with physical data in SAS Enterprise Guide.

Many Thanks

Re: How to find difference between metadata and physical data in SAS

ChrisHemedinger — Thu, 29 Aug 2019 17:40:11 GMT

Check the Tools->Update Library Metadata task. It allows you to create a report of your libraries/tables according to what metadata shows, and report on the differences.

It generates code like this:

/* assign library using metaout=data */
/* resulting library shows all physical tables */
libname _temp meta library="My Library" metaout=data;

/* show report of changes that *would* be made */
proc metalib;
  omr (library="My Library");
  update_rule=(delete);
  report;
  noexec;
run;

libname _temp clear;

topic How to find difference between metadata and physical data in SAS in SAS Enterprise Guide

How to find difference between metadata and physical data in SAS

Re: How to find difference between metadata and physical data in SAS