topic Re: Incorrect length in SAS Metadata Repository for column FPROD in SAS Programming

Incorrect length in SAS Metadata Repository for column FPROD

seshu456 — Thu, 18 Jul 2019 10:58:36 GMT

i am trying to use dictionary.columns for one of SAP permanant library, which throws a error.

proc sql;

select *

from dictionary.columns

where libname = 'SAP-Library' and name= 'column_name'

;quit;

the program fails and generating error "Incorrect length in SAS Metadata Repository for column FPROD"

andreas_lds — Thu, 18 Jul 2019 11:32:21 GMT

Have you checked the length using sas management console? Maybe database and metadata are out of sync.

seshu456 — Thu, 18 Jul 2019 12:08:18 GMT

Thanks.. now working after updating metadata