Object Name remains unchanged when pointing to new libref

[MadhavCheluka]

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!

[MadhavCheluka]

Anyone?

[ChrisHemedinger]

@MadhavCheluka I'm checking to see if we can get an expert to respond.

[MadhavCheluka]

Thanks Chris!

[TimBeese]

Hello madhav1,

I'm a developer for the SAS Add-In, and we do not change the object name when the data source is changed.  The object name is only used for VBA scripting to uniquely identify the contents.  If we were to change the object name, existing VBA code could be broken when someone changes the data source.  The original object name that we choose is derived from the name of the library/dataset that was opened, so unfortunately after a "change data source" operation, the object name may look like it is indicating the wrong data.

If you'd like to discuss your usage of this and how it is causing problems, I may be able to offer some other alternatives.  Hope this helps.

Tim Beese

tim.beese@sas.com

[MadhavCheluka · Accepted solution]

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