BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DavidPhillips2
Rhodochrosite | Level 12

When I run this statement I receive

data test; set sashelp.vcolumn ;
run;

 

ERROR: Incorrect length in SAS Metadata Repository for column SCHEV_ETHNICITY_DESC.
ERROR: SQL View SASHELP.VCOLUMN could not be processed.

 

I recently updated some tables.  

 

How do I pinpoint what is causing this error?

1 ACCEPTED SOLUTION

Accepted Solutions
DavidPhillips2
Rhodochrosite | Level 12

Is there a way to identify which table is out of sync? I updated the metadata for a full library to resolve the error.

View solution in original post

4 REPLIES 4
pink_poodle
Barite | Level 11

data test 

set sashelp.vcolumn;

if memname ne 'SCHEV_ETHNICITY_DESC';

run;

 

If that gets rid of the problem, then go to folder location:

 

Local -> Libraries -> SASHELP -> Vcolumn ->

rc, 'Explore' -> look at length column to get the idea about correct length values ->  Set filter memname = 'SCHEV_ETHNICITY_DESC', keep memname and length

 

that will show the incorrect length value

 

data sashelp.vcolumn;

where memname = 'SCHEV_ETHNICITY_DESC';

lengh = correct-value;

run;

 

SASKiwi
PROC Star

It looks like you register your SAS tables in SAS metadata. What this means is, every time you change the attributes of your SAS tables, you need to update those tables in SAS metadata so the column definitions remain the same.

DavidPhillips2
Rhodochrosite | Level 12

Is there a way to identify which table is out of sync? I updated the metadata for a full library to resolve the error.

SASKiwi
PROC Star

Yes, @pink_poodle's VCOLUMN example code will also identify the table. 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 3125 views
  • 1 like
  • 3 in conversation