BookmarkSubscribeRSS Feed
mali
Calcite | Level 5

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

2 REPLIES 2
BrunoSilva
Quartz | Level 8

Hello,

I think the paper bellow have exactly what you want, give a check.

Tips and Techniques for Automating the SAS® Add-In for Microsoft Office with Visual Basic for Applications

http://support.sas.com/resources/papers/proceedings11/012-2011.pdf

Sample VBA macro to run a stored process

https://support.sas.com/rnd/datavisualization/BridgeForESRI/V2/stored_process_code.htm

Turn Your SAS® Macros into Microsoft Excel Functions with the SAS® Integrated Object Model and ADO

http://support.sas.com/resources/papers/proceedings14/1598-2014.pdf

Probably you need a few adjustments in order to comply with your SAS version.

Best Regards.

mali
Calcite | Level 5

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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2203 views
  • 1 like
  • 2 in conversation