topic Re: SAS AMO - Silent Execution of Stored Process in Microsoft Integration with SAS

SAS AMO - Silent Execution of Stored Process

Scott_Mitchell — Thu, 27 Jun 2019 00:35:03 GMT

Hi All,

I have created a stored process which I want to execute silently i.e. without the "Executing SAS Analysis" Popup or the Information window appearing on the right hand side of the screen as per below. Is there an option that can stop these things occurring either from the interface or via VBA?

Any help would be greatly appreciated.

Thank you in advance.

Re: SAS AMO - Silent Execution of Stored Process

fifthand57th — Thu, 27 Jun 2019 15:56:51 GMT

@Scott_Mitchell

Try this sample VBA code (modify for your stored process):

Sub InsertStoredProcess()

    Dim sas As SASExcelAddIn
    Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
    sas.Options.AutoInsertResultsIntoDocument = True

    Application.DisplayAlerts = False

    Dim stp As SASStoredProcess
    Set stp = sas.InsertStoredProcess("/Shared Data/Stored Processes/Bar chart prdsale", Sheet1.Range("A1"))
    
    Application.DisplayAlerts = True
    
End Sub

Unfortunately, I do not think there is a way to suppress the new SAS Panel on the right, but I am checking with R&D to be certain.

Re: SAS AMO - Silent Execution of Stored Process

fifthand57th — Thu, 27 Jun 2019 18:22:24 GMT

@Scott_Mitchell

I was correct. Unfortunately, no option currently exists to suppress the SAS panel that opens automatically when results are rendered. But I have opened a software feature request to ask for this option in a future release of the SAS Add-in for Microsoft Office.

Re: SAS AMO - Silent Execution of Stored Process

Scott_Mitchell — Tue, 09 Jul 2019 02:25:06 GMT

@fifthand57th Thank you so much for this. Greatly appreciated.