topic Re: Do you use custom (add-in) tasks? in SAS Enterprise Guide

Do you use custom (add-in) tasks?

ChrisHemedinger — Tue, 07 Mar 2006 20:27:34 GMT

Greetings,

I find that many EG users aren't aware of what you can do with custom tasks. (See http://support.sas.com/eguide for links to explanation and examples.)

Have you extended SAS Enterprise Guide by creating or using custom add-in tasks? If so, what business problem were you able to solve?

Chris

Re: Do you use custom (add-in) tasks?

AlanC — Mon, 13 Mar 2006 12:14:40 GMT

When will EG support .NET 2.0 for custom tasks?

Re: Do you use custom (add-in) tasks?

ChrisHemedinger — Mon, 13 Mar 2006 14:10:47 GMT

EG 3.0 and the forthcoming version, EG 4.1, are both built/tested using .NET 1.1. (.NET 2.0 only recently became available in production, too late for SAS to consider switching framework versions...)

That means that the .NET 1.1 runtime is used in process when running EG, and that pretty much restricts custom add-in tasks to .NET 1.1 for now.

Now, I know that folks on the cutting edge will want to use .NET 2.0 to build their custom tasks -- it's the latest and greatest technology and there are some great capabilities in it. It is possible to tweak the EG configuration to run with the .NET 2.0 runtime; however, this configuration has not been tested as extensively as the default .NET 1.1 environment and cannot be officially supported at this time.

In the next few weeks we hope to have a statement about what you can do here, how it's supported, and perhaps an example or two.

Chris

Re: Do you use custom (add-in) tasks?

AlanC — Sun, 19 Mar 2006 21:25:13 GMT

Chris,

It's Alan Churchill. I am now independent

.NET 2.0 is a huge release. I know that there are some risks here with using 2.0 based upon testing, etc. but the advantages are great (generics, nullable types, VS2005). We use generics a lot as well as nullable types.

Any examples you can provide for supporting 2.0 would be great.

We would like to port some of our SAS add-ins to EG but we use 2.0 too much. It cuts our coding time down by 25% at least. We do 1.1 as well but I can tell a massive productivity hit whenever we sign up for a 1.1 task. That is mainly due to the editor, BTW. Generics are great but if we need to box/unbox we will.

-Alan

Re: Do you use custom (add-in) tasks?

ChrisHemedinger — Wed, 22 Mar 2006 17:58:59 GMT

Alan, and others,

Microsoft is providing a tool that allows you to take your Visual Studio 2005 projects and target the .NET 1.1 framework. Here is a link to the tool:

http://msdn.microsoft.com/vstudio/downloads/tools/msbee/default.aspx

This allows you to take advantage of extra productivity features in the VS2005 IDE, but still build custom tasks that use .NET 1.1 (necessary for EG 3.0 and 4.1 support).

There are some caveats: you won't be able to use some of the .NET 2.0 features. That includes partial classes, which are automatically employed by the VS2005 forms designer.

We plan to do some in-house testing of this process and then provide a more detailed write-up of how this might work. However, I didn't want to wait until that's complete before sharing this information with you, in case it might help you immediately.

Chris

Re: Do you use custom (add-in) tasks?

deleted_user — Thu, 23 Mar 2006 13:06:25 GMT

Hi Chris and others!
I gave a presentation on "customized analyses with SAS Enterprise Guide" (in Finnish) at SAS Forum Finland in February. I compared three alternatives to do custom analytics with EG: macros, stored processes and add-ins. My example add-in was a statistical analysis task that uses the new ods graphics of LIFETEST and the class statement of TPHREG.

Many listeners were interested in the possibilities that I tried to demonstrate, and we could agree that a libname generator would have been a useful simple add-in...

I intend to deploy some advanced statistical analytics in an easy-to-use EG look and feel for customers who have specific business needs that can be addressed with specific analytics. One such case is currently under development and I look forward for many more. The potential is huge (as it allways is with SAS), and the process of building an add-in is quite easy with for example Visual Studio .NET.

Looking forward for the 4.1 release,
Jouni

Re: Do you use custom (add-in) tasks?

ChrisHemedinger — Thu, 23 Mar 2006 15:34:47 GMT

Jouni,

Sounds like a great presentation! When I present on this topic, I make a similar distinction among the options for custom analyses: from simple (code and macros) to more advanced (stored processes) to the very sophisticated (custom tasks). It all depends on the audience and need.

You'll be happy to know that in EG 4.1 there is an Assign Library tool, which generates LIBNAME statement code for you.

Chris

Re: Do you use custom (add-in) tasks?

AlanC — Tue, 28 Mar 2006 12:29:07 GMT

Chris,

Good link. Thanks for this information, just wish I had it sooner. VS2005, IMO, shaves 25% off of development time alone so being able to use it for 1.1 cding is a godsend.

Alan

Re: Do you use custom (add-in) tasks?

PhilC — Thu, 05 Nov 2020 20:18:07 GMT

@ChrisHemedinger

Do you know if there are there organized.maintained collections or lists of EG add-ins and/or scripts? …scripts such as the VBA, etc, scripts are in your GitHub account...

Re: Do you use custom (add-in) tasks?

AlanC — Thu, 05 Nov 2020 21:33:56 GMT

personally, i would never use VBA for anything: there are better ways.

My own SAS/C#/PowerShell solutions are on github under https://github.com/savian-net

None of my EG add-ins are there at this time since it has not been checked against the latest EG. That said, it can help guide you in today's world since all of my code is written using .NET Core.

Chris has loads of examples out there as well as a very good book on it: https://www.amazon.com/Custom-Tasks-Enterprise-Guide-Microsoft-ebook/dp/B00AWSMT9K/ref=sr_1_1?crid=3KQRKG47RUVPQ&dchild=1&keywords=sas+enterprise+guide+custom+tasks&sprefix=SAS+Enterop%2Caps%2C190&sr=8-1