topic Re: SAS/AF software in SAS Programming

SAS/AF software

Garik — Thu, 20 Jul 2017 06:22:36 GMT

Hello.

I came accross a problem. I want to create dynamic reports, but I must install the SAS/AF software.

Where I can get the software. I cannot find the soft. Is it free, or maybe it is available in trial mode.

please support. thanks a lot.

Re: SAS/AF software

Kurt_Bremser — Thu, 20 Jul 2017 06:35:01 GMT

SAS/AF is a SAS module that needs additional licensing.

(expanded license from SAS -> new installation package -> add to SAS depot -> install and configure with the SDW to add it to your installation)

Depending on what you want to do, you might get the same functionality from macro programming (creating dynamic code) and/or from using stored processes with input parameters.

Re: SAS/AF software

LinusH — Thu, 20 Jul 2017 06:37:47 GMT

SAS/AF is legacy software and hasn't been developed since version 8, that's well over ten years...
Perhaps you should talk to a SAS architect for other options (there are quite a few depending on your needs and constraints).

Re: SAS/AF software

SASKiwi — Thu, 20 Jul 2017 07:06:18 GMT

SAS/AF also requires Foundation SAS aka Base SAS to run and both products need to be installed on all PCs using it. A SAS desktop licence could easily cost over $10K per year depending on what mix of products you want.

Re: SAS/AF software

AlanC — Thu, 20 Jul 2017 13:55:01 GMT

As mentioned here, this is legacy software. Did you try to run something inside of PC SAS from the menu and it complained? If so, I wouldn't go that route since the products are very dated.

Tell us what you are wanting to do and we can help with how to go about doing it.

Re: SAS/AF software

art297 — Thu, 20 Jul 2017 15:43:54 GMT

One slight correction to @SASKiwi's comments: SAS/AF only has to be licensed on the one machine that uses it to develop and compile SAS/AF modules. The compiled modules can be run on any machine that has base SAS licensed. However, those modules are NOT compatible with SAS/EG and I have no idea if the are compatible with SAS Studio.

Regardless, if one's shop does run on base SAS and AF turns out to be the most effective way to accomplish certain tasks, it might be most cost effective to have an outside contractor (who does have a license for AF) develop and supply the compiled modules for use at one's shop.

Art, CEO, AnalystFinder.com

p.s. While I am experienced with AF, I am NOT one of the above mentioned contractors

Re: SAS/AF software

Garik — Thu, 20 Jul 2017 20:02:06 GMT

Hello.

The main problem is to create dynamic reports for the management. The report should contain several analysing and calculatin moduls. I want to cretae easy to use reports, I try to use ODS, but is not dynamic as I know. How to handle this issue? The dynamic reports can be created in excel, but excel is not so flexible as SAS is, I have 3 mln. rows minimum. I Have licence for SAS Enterprise Guide.

Re: SAS/AF software

Kurt_Bremser — Thu, 20 Jul 2017 20:14:39 GMT

3 mil rows are data, not a report. A report is something a human can take in at a glance, more or less.

I would keep everything in SAS until it reaches the report stage as mentioned above.

Can you use stored processes?

Re: SAS/AF software

Garik — Thu, 20 Jul 2017 20:30:01 GMT

I just ment, that my data contains minimum 3 mln rows, from which I should create reports.

Yes, I can use stored processes.

thanks

Re: SAS/AF software

AlanC — Thu, 20 Jul 2017 20:35:50 GMT

That leads to another question which is what tools (SAS software) do you have available to use?

Re: SAS/AF software

Garik — Thu, 20 Jul 2017 20:44:12 GMT

I have licensed SAS Enterprise Guide.

Re: SAS/AF software

AlanC — Thu, 20 Jul 2017 21:07:34 GMT

Well, EG is a client license so there needs to be more stuff on the server. Any idea what SAS packages are available on the server?

Re: SAS/AF software

Kurt_Bremser — Thu, 20 Jul 2017 21:09:20 GMT

Then I would create the reports in EG, make them flexible with user prompts, and create stored processes from them.

Re: SAS/AF software

ChrisBrooks — Fri, 21 Jul 2017 00:42:06 GMT

As others have said AF is very old - I've used it a lot in the past but I don't think many people are writing new systems with it these days. If you need a really flexible interface and you have EG then you might consider Custom Tasks; these can be written in C# or VB .NET using the free version of Visual Studio

Re: SAS/AF software

ChrisNZ — Fri, 21 Jul 2017 03:55:29 GMT

No SAS/AF from Enterprise Guide.

Many other options though, like:

1- EG reports as @Kurt_Bremser said

2- SAS addon for office, to reports and query SAS data from MS Office (Usually Excel)

3- Create HTML reports and push them somewhere on the network.

You can tweak the SAS-created HTML code to add add menus and navigation, .

Or create a main menu to point to the different pages, or a combination of both.

Re: SAS/AF software

Garik — Fri, 21 Jul 2017 12:09:20 GMT

Are there any books or papers on the "Stored Processes". Think it is what I am looking for.

Many thanks to all of you.

Re: SAS/AF software

AlanC — Fri, 21 Jul 2017 12:17:19 GMT

http://www2.sas.com/proceedings/sugi30/135-30.pdf

Re: SAS/AF software

Rick_SAS — Fri, 21 Jul 2017 12:37:21 GMT

What version of SAS software are you running? Submit

%put &=sysvlong;

and then cut and paste the last line in the SAS log.

Also, how are you running SAS? From SAS Studio? From SAS Enterprise Guide?

SAS Studio supports creating custom tasks. SAS Enterprise Guide also supports custom tasks, although it requires some specialized skills to create them.

Re: SAS/AF software

Garik — Fri, 21 Jul 2017 12:48:26 GMT

SAS Enterprise Guide 4.3

Re: SAS/AF software

Kurt_Bremser — Fri, 21 Jul 2017 12:53:01 GMT

Look at the Stored Process Developer's Guide.