This will not resolve the issue for you, but there are a few additional settings for the editor window that may help. Go to Program -> Editor Options -> Appearance tab:   ... View more

@TS2000    In Enterprise Guide 8.1 and later, the ALT + S key sequence will display the Search window.  Here's a link to the documentation:  https://go.documentation.sas.com/doc/en/egcdc/8.3/egdoccdc/ega11y/titlepage.htm#p03zz70s5igtwqn1xugh81ax4yil     ... View more

@Rosss  Is this an issue with one project or several? Did you test Enterprise Guide scheduling using a very simple project first? As we discuss in the webinar, always test using a very simple project using the "Run only when logged on" security context first.    After confirming that a very simple project using "Run only when logged on" executes successfully, then verify that the VBScript created by SAS Enterprise Guide for your project executes successfully outside of Task Scheduler and creates the expected results. See slide 10 of the EG Scheduling.pdf file download mentioned above.    What is are the results of these two tests? ... View more

@MrManSledge    You can schedule a refresh of your Excel workbooks using the SAS Add-in. A VBScript file is created that will execute in non-interactive mode when scheduled in Windows Task Scheduler.   Here's the doc: https://go.documentation.sas.com/?cdcId=amodoccdc&cdcVersion=8.3&docsetId=amoug&docsetTarget=p1fqgkd7pbj5wpn1f54xlg5clrwc.htm&locale=en   A SAS Note I wrote with a list of tips for scheduling a refresh successfully: http://support.sas.com/kb/59947   Alternatively, you can enable the "Refresh on file open" option for individual SAS content in a workbook. Open Manage Content and right-click on the SAS content you want to refresh automatically when the Excel workbook opens. Choose Properties, then on the Execution tab you'll see the "Refresh on file open" option.   ... View more

@MariaD    What is the full version of SAS Add-in for MS Office installed? Go to Help -> About SAS Add-in on the SAS ribbon in Excel for this information. For example, 8.2 Update 5 (8.2.5.842) (32-bit).   Please post a screen shot of the Results options in the "SAS Results" section:   ... View more

@Jonison    Check out the following SAS notes for EG Scheduling assistance: http://support.sas.com/kb/59079 http://support.sas.com/kb/56648   Additionally, here's a webinar link that steps through the debug process: https://communities.sas.com/t5/Ask-the-Expert/SAS-Enterprise-Guide-Scheduling-Projects/ta-p/506514   ... View more

@Nsp96    Double-check that you have enabled the SAS Add-in VBA reference.    Does this work?   Sub test()   Dim SAS As SASExcelAddIn   Set SAS = Application.COMAddIns.Item("SAS.ExcelAddin").Object   SAS.Refresh ThisWorkbook End Sub ... View more

If you bring up the Submission Status window (on the View menu in EG 8.2), you should be able to right click on a node that is processing and cancel just that node.   ... View more

@harrison_david    First ensure that the project runs successfully interactively on the OA server machine. Next make sure the project runs successfully from script on the server. Then schedule the project after opening EG using "Run as Administrator". ... View more

@harrison_david    Outside of Windows Task Scheduler on the OA Server machine, have you verified that the project runs successfully from VBScript at a command prompt? In the webinar I mention uncommenting the MsgBox line at the end of the .vbs file to catch any errors that may occur when the VBScript executes.    If the project runs successfully from VBScript outside of Task Scheduler, did you open EG using "Run as Administrator" before scheduling the project? See SAS Note 59079, http://support.sas.com/kb/59079   Does the scheduled job run successfully when you choose the "run only when user is logged on" Task Scheduler security context? ... View more

@sundx045    Each time you open an Excel workbook, the SAS Add-in for MS Office must load in Excel. Before you Refresh SAS Content, the SAS Add-in for MS Office must establish a connection to the metadata server then instantiate a workspace server where execution will occur. If I understand what you are doing correctly, you are looping through closed Excel files and refreshing SAS Content.    When you refresh SAS content from VBA in this manner, the VBA must first open the Excel file, then the SAS Add-in must load in Excel, then the metadata connection occurs and workspace server is instantiated, and, finally, the refresh occurs. You likely count all of this as your "refresh time".    Without using VBA, you first open the Excel file and the SAS Add-in loads, then it is likely that the metadata and workspace server connections are made before the user clicks the "Refresh" button. You are likely not counting the time it takes to open Excel, load the Add-in, make the connections, then refresh the data as your "refresh time".  ... View more

@sundx045    Is your goal to have the SAS content refresh on workbook open? If so, enable the "Refresh on file open" option on the Execution tab of the properties of the SAS content. See screen shot below.    If refresh on file open is not your goal, try using only the sample VBA code in the SAS Add-In help without other VBA present:   Sub RefreshContents() Dim sas As SASExcelAddIn Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object sas.Refresh ThisWorkbook End Sub   ... View more

Hi @Scott_Mitchell,   Do the stored process and output parameters behave as expected without VBA involved? If you just run the stored process interactively, do you receive different results? This will tell us if the issue is in the VBA or the SAS stored process.   Check out this paper from page 14 to the end: http://support.sas.com/resources/papers/proceedings12/036-2012.pdf. It steps through setting up a similar stored process with output parameters, but doesn't add VBA until the stored process works interactively first.     ... View more