SAS Support Communities

MadhavCheluka · ‎04-26-2022

I am getting below error while creating a table on Redshift using (datastep) Redshift ODBC connection. ERROR: The character variable VAR1 has too long a value for the RSCONN library. my connection statement and datastep: libname rsconn odbc datasrc='XXXXXXXXXX' user="&user." pwd="&rspwd." schema=XXXXX; data rsconn.table1; set work.table2(keep=var1); run; The length of the var1 is $10. any help in resolving this issue is appreciated

MadhavCheluka · ‎07-25-2018

Thank you Tim for the information. We have some reports that needed to point to new library so, when I saw the the object name remain same and not changed to new library I was wondering what could be the reason for not changing. I agree with you that the object name change could break the VBA code. if the object name is only used for VBA scripting to uniquely identify the contents we need to document/highlight it so that people could know exact reason for not changing. I was searing all over the internet for any information on this but could not find any 🙂 but for some reports just use the SAS Addin to create pivot tables and don't use VBA code, the object name difference (with Name) could indicate wrong location/data. Please let me know if there are any alternatives. your information is really helpful! Thanks, Madhav

MadhavCheluka · ‎07-23-2018

Thanks Chris!

MadhavCheluka · ‎07-23-2018

Anyone?

MadhavCheluka · ‎07-20-2018

This is In SAS Addin for Microsoft Excel (sas ribbon in excel) When I change the data source from one LIBREF to Another (Data set name and the Server name is same but the LIBREF is different) using SAS -> selection -> Change Data Source the Name (in SAS -> selection -> properties) is updating accordingly but the Object Name remains unchanged/updated to new LIBREF. is there a way to fix this. Thanks!

Online Status	Offline
Date Last Visited	‎04-30-2022 08:39 AM

SAS Support Communities

Error - variable has too long a value for the XXX library

Re: Object Name remains unchanged when pointing to new libref

Re: Object Name remains unchanged when pointing to new libref

Re: Object Name remains unchanged when pointing to new libref

Object Name remains unchanged when pointing to new libref

Error - variable has too long a value for the XXX library

Re: Object Name remains unchanged when pointing to new libref

Re: Object Name remains unchanged when pointing to new libref

Re: Object Name remains unchanged when pointing to new libref

Object Name remains unchanged when pointing to new libref

Follow Us

What is...