07-20-2017 02:22 AM
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.
07-20-2017 02:35 AM
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.
07-20-2017 02:37 AM
07-20-2017 03:06 AM
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.
07-20-2017 11:43 AM
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
07-20-2017 09:55 AM
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.
07-20-2017 04:02 PM
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.
07-20-2017 04:14 PM
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?
07-20-2017 08:42 PM
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
07-20-2017 11:55 PM
No SAS/AF from Enterprise Guide.
Many other options though, like:
1- EG reports as @KurtBremser 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.
07-20-2017 05:09 PM
Then I would create the reports in EG, make them flexible with user prompts, and create stored processes from them.