That's a good question without a good answer today. We are working on some larger changes that remove this issue, but the next release is still a good way out. So, while there's no good answer today, we are working on the problem and a solution is coming! ... View more

Todd, That's a clever way around the protection issue. I'm glad that the results updated event met your need. ... View more

George, I don't think you needed to recycle the metadata server. You will need to recycle your Office application(s) (exit and re-run Excel, Word, PPt or re-connect to the metadata server via SAS->tools->server connections). I would suggest working with tech support. I've run out of ideas, sorry. ... View more

George, Go bach into SMC and bring up the properties for your library. On the Options tab, press the "Advanced Options..." button. The first tab, Pre-Assign, has one checkbox, "Library is pre-assigned". By default, library is pre-assigned is unchecked. For your needs, you will want to enable this checkbox turning on pre-assignment for this library. Pre-assigning libraries defined in metadata will force the underlying engine, in your case BASE, to be used instead of the META engine which renders the data read-only in the Add-In. ... View more

Hi Dave, Don't do it. The EG hot fix is not compatible with SAS Learning Edition. ... View more

I don't think there is a reliable way to align a stored process call to some VBA code via the stored process server. That said, it is possible with the 2.1 version of the Add-in to catch an event upon refresh of any item (stored process, task, or SAS data in Excel). There is a detailed explanation with example VBA code in the online help. Look in the index for events->writing for Word. While it won't help to unprotect the section, you could use the event to protect the section. ... View more

You can save your login credentials via the Options, Administration->Repository and Server page. Press the Manage... button, and select your repository from the list. To add your credentials to the repository, press the Modify... button and place the user and password into the correct fields. ... View more

For SAS 9.1.3/EG 4.1, there is no way to limit data access from metadata. You can use OS-level file access to limit users from accessing data by removing read access rights for specific user accounts. Unfortunately this is not controllable via SAS Management Console. ... View more

George, Libraries defined with the META engine (using the default options) and those marked as read-only will not be shown when choosing a place to save data. AMO hides read-only (and META when tracking columns as that makes it read-only as well) libraries for saving purposes. To address the error message, I don't have a useful answer. Please contact tech support to resolve this issue. Bill ... View more

The most likely culprit is that your SAS setinit has expired. You most likely need to renew your license once a year. Try running SAS directly (c:\program files\SAS\SAS9.1\sas.exe or something like this). You should see a more specific error from that. I would talk to tech support if you require more assistance. ... View more

You can stop looking because the option is not there. We did not consider your case when designing the Add-In. I will put it on the list of feature requests. ... View more

This sounds like something SAS Technical Support should handle. ... View more

You will need to add a second item to the Convert.ToDouble() statement. After your Me.TextBox1.Text add a second argument of "System.Globalization.CultureInfo.InvariantCulture". This will force the Convert.ToDouble() to use the default/US-english locale for the conversion no matter what Tools/Options/General/Locale settings. ... View more

To answer your three issues: 1.Ability to download data into read-only pivot table in excel. If by read-only you mean the user can't write back changes to the OLAP server, then yes this works in SP4. If you instead mean precluding the modification of OLAP data behind the pivot table, the addin does not have the ability to stop that from happening. 2.Disable drill to detail data in pivot table Drill through to detail has not been enabled for the 2.1 version (SP4). We are planning on enabling drill though to detail in a future release and that will be limited to cubes that allow drill through (use Cube Studio to set this flag). 3.Disable some of the SAS Menu options like ‘Open SAS datasets in worksheets’ and server connection Disabling these kinds of functions is not possible with the 2.1 release. We are working on this kind of IT admin controls in the next release. Can you explain why these specific items need to be disabled? I don't believe that the open SAS data item is currently on our list. ... View more