How to find difference between metadata and physical data in SAS

[dhruvakumar]

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 

[ChrisHemedinger]

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;