05-02-2017 06:13 AM - edited 05-02-2017 06:26 AM
I have been given the task of producing a single VA report which can be filtered (on multiple data-items) 200+ times and use AMO to present the resulting visualisations in Excel using Add-In for Microsoft Office, which will then be converted to a PDF for consumption.
The users do not want to manually change the filters or manually convert the reports to PDF.
Is there a way, using only a vanilla install of VA 7.3 (i.e. no OA, no EG, etc.), to produce a result in the above manner?
I have read http://support.sas.com/resources/papers/proceedings16/SAS3500-2016.pdf and gather there is a way to create VBA code that interacts with the AMO, but I may be "barking up the wrong tree", given that the paper is discussing OA also.
Any help or ideas would be greatly appreciated.
Thank you in advance.
05-02-2017 06:55 AM
I read your question and realised that it can be understood in two ways. So I wanted to make sure that everybody is on the same page.
SAS® Office Analytics (OA) is the commercial package that includes (not limited to) SAS Add-In for Microsoft Office (AMO) and SAS Enterprise Guide (EG). AMO is the component enabling SAS VA reports to be accessible from your Microsoft Office applications.
Now, did you want to achieve your task without OA, meaning no AMO either? Or do you have AMO in your platform by some other means? Anyway, I think AMO is mandatory to achieve what you are after.
05-02-2017 07:10 AM - edited 05-02-2017 07:17 AM
Thank you for giving me the opportunity to clarify.
We have VA 7.3 and AMO 7.1 installed onsite, and we are hoping to use both of these to achieve the desired outcome. We don't have E.G. or any other SAS products licensed.
I was lead to believe that you could license AMO without licensing OA, hence the confusion.
Thank you again.
05-02-2017 07:00 AM
If you don't mind, can you please elaborate your question with sample example, so can understand better way to provide you the perfect solution..
05-02-2017 05:39 PM
05-02-2017 07:27 PM
Have you thought about using one of the browser automation tools to get the pdf files direct from VA itself? You could cut out using Excel all together.
In my experience the Office tools are great but can be slow to refresh after selecting an option, even if you get something working with VBA looping through 200 options could be pretty slow.
Alternativley is it feasible to create the report in Base SAS? I think that would be much more geared up to producing batch pdf outputs.
05-03-2017 05:39 PM