Creating SAS Profile

Dreamer — Fri, 05 Dec 2014 21:14:45 GMT

Hi,

I have created a Excel VBA utility for my business users where on button click it runs a SAS stored procedure and refreshes excel with newly created data sets.

There are many users of this report and most of them don't know how to configure SAS profile in Excel SAS Add in.

Most of the time I get complains that utility is not working. But the real problem is that they have not configured the profile in SAS Add in.

So I am looking for a way to automatically configure SAS profile if its not been configured.

Currently I got a way to check if profile is configured or not. But can't configure it as its a read only property!!

Dim SAS As SASExcelAddIn

Set SAS = Application.COMAddIns.Item("SAS.ExcelAddIn").Object

If Trim(SAS.ActiveProfile.Name) = "" Then

MsgBox "Please configure your SAS profile!", vbInformation

End If

Re: Creating SAS Profile

Patrick — Sat, 06 Dec 2014 00:02:44 GMT

You could also write some step by step instructions and then add a link to these instructions as part of your message.

Re: Creating SAS Profile

Dreamer — Mon, 08 Dec 2014 14:33:35 GMT

Hi , I've already done that but its less useful!!

topic Re: Creating SAS Profile in Microsoft Integration with SAS

Creating SAS Profile

Re: Creating SAS Profile

Re: Creating SAS Profile