topic list with columns in sas tables,table name and libname! VCOLUMN - but error in SAS Enterprise Guide

list with columns in sas tables,table name and libname! VCOLUMN - but error

ANLYNG — Fri, 19 Aug 2016 15:18:54 GMT

I want to see all columns in sas tables,table name and libname.I get an error like below:

Is there a work around or al alternative to get this information (the table from dictionary show the same error).

Alternative can I ask the metadata server ? and how (code example is appreciated).

Thanks in advance.

23 proc sql;

24 create table XXXX AS

25 select libname, memname, name, type from

27 sashelp.VCOLUMN;

ERROR: Incorrect length in SAS Metadata Repository for column initial_1.

ballardw — Fri, 19 Aug 2016 15:24:56 GMT

Either fix the metadata for initial_1 or disconnect from meta data?

ANLYNG — Fri, 19 Aug 2016 15:26:25 GMT

hoW can i disconnect metadata in EG? and connect again?

BrunoMueller — Fri, 19 Aug 2016 16:27:55 GMT

Have a look at the "Update Library Metadata" task under Tools.

This task can report on the differences between the Metadata definition and the actual physical table.

The task can also update the Metadata definition, provided you have the necessary permissions.

Bruno