Today I receive:
ERROR: Incorrect length in SAS Metadata Repository for column DISBURSEMENT_COMMENT.
ERROR: SQL View SASHELP.VCOLUMN could not be processed.
when I run:
data temp; set sashelp.vcolumn; run;
Yesterday this worked.
SAS replied:
The common issue for this behavior is when the table registered in Metadata does not have the same column length as the physical table. To solve the problem, update table metadata so that it matches the physical data. Do this by running Update Metadata within SAS Management Console. From the Plug-ins tab, select the library containing the table Right-click the table and select Update Metadata from the popup menu.
You can also run the PROC METALIB to update table metadata. Please see documentation for METALIB Procedure here
If this is not the case it is possible there was a loss of connection to the servers when the Enterprise Guide has been idle for a while and the restart reestablished the connection to SASApp.
SAS: Please fix this bug. I restarted Enterprise Guide and the Error went away.
If you want to officially report what you think is a SAS bug then you need to raise a track with SAS Tech Support.
I did they just closed the ticket for no reason though.
Ask for an explanation then?
SAS replied:
The common issue for this behavior is when the table registered in Metadata does not have the same column length as the physical table. To solve the problem, update table metadata so that it matches the physical data. Do this by running Update Metadata within SAS Management Console. From the Plug-ins tab, select the library containing the table Right-click the table and select Update Metadata from the popup menu.
You can also run the PROC METALIB to update table metadata. Please see documentation for METALIB Procedure here
If this is not the case it is possible there was a loss of connection to the servers when the Enterprise Guide has been idle for a while and the restart reestablished the connection to SASApp.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.