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.
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.
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.
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.