cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mali
‎09-01-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Invoke SAS Stored Process using EXCEL Macro

by Calcite | Level 5 in Developers
‎06-10-2015 01:16 PM
‎06-10-2015 01:16 PM
Hi , I tried to insert the following code in macro editor Sub TestConnectionToSAS() Dim sas As SASExcelAddIn Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object sas.HelloWorld End Sub I am getting a complie error: USer-Defined type not defined. I assume this is because connection to API is not working properly. I am unable to go to references tab within macro editor to enable SAS COM add-in. Am I missing something.Please let me know . Thanks ... View more

Invoke SAS Stored Process using EXCEL Macro

by Calcite | Level 5 in Developers
‎06-03-2015 01:58 PM
‎06-03-2015 01:58 PM
Hi, I have a stored process that can be run in excel using AMO. I am trying to create a macro in excel that will invoke the stored process directly. My questions are as follows. 1) Since I am using SAS EG , I figured I will need to write code to connect to server for running this Stored process. How do I connect to linux server using EXCEL? 2) How do I find the location of metadata? My stored process is located on the server. Thanks in Advance ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:12 AM
Quick links