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. 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 3211 views
  • 1 like
  • 3 in conversation