topic updating the length of a character variable in SAS Enterprise Guide

updating the length of a character variable

jubikunjumon — Tue, 22 Nov 2016 15:20:06 GMT

Hi,

Can anyone guide in resolving the below issue.

While running the query in EG getting following error "Incorrect length in SAS Metadata Repository for columns ABC". After looking at the structure of oracle database i could see that ABC column is having character length of 40 while in EG its showing up with 140, Any way that we can update in SAS Mangement console and will this http://support.sas.com/kb/38/707.html help us in resolving the issue, since we need are having multiple environments

Regards

Jubi

Re: updating the length of a character variable

Patrick — Wed, 23 Nov 2016 22:29:35 GMT

The KB you reference is only for the specific case where you're using DBSASTYPE= in your libname definition. Is this the case for you?

If not then I believe you could just change the column metadata definition in the table so it's in sync with what you have in Oracle (not sure but I would just try in a DEV environment, may be first by playing around on a copy of the existing table metadata object to not impact on anything existing).

In case you're using the table metadata not only in EG but also with tools like DIS then you will have to do some impact analysis first in order to determine where else you have to amend things.

I personally don't like to use the meta engine for EG. Is there any reason you have to?

Re: updating the length of a character variable

jubikunjumon — Thu, 24 Nov 2016 13:55:10 GMT

Hi Patrick,

Thanks for sharing an update for the query

~~The KB you reference is only for the specific case where you're using DBSASTYPE= in your libname definition. Is this the case for you?~~ NO ,

I think the below option which you have specified sounds good, will try to take the backup of the metadata in SMC before replicating the changes. Will try to go through dev env.

there is no specfic reason for doing this in EG will try to have in DIS