BookmarkSubscribeRSS Feed

About VA to Excel..

Started ‎03-04-2015 by
Modified ‎10-05-2015 by
Views 1,559

This post originated at I thought it may also be useful for the community too.

 

Kind Regards,

Michelle

-----------------------------------------------

Hi all,

 

How to Connect MS Excel to SAS VA,

 

 

I want SAS VA Reports in Excel...., and i want to automate them every day or week or month. Any Suggestions?

 

 

Thanks,

Teja Surapaneni.

 

Hi Teja,

 

If you have SAS Add-in for Microsoft Office licensed or Office Analytics then this is possible. Here is a link that outlines version compatibility - 52813 - Support for SAS® Visual Analytics reports in the SAS® Add-In for Microsoft Office and in SAS...  and a link to a SAS Global Forum 2015 paper that outlines this with screenshots http://support.sas.com/resources/papers/proceedings14/SAS274-2014.pdf

 

Kind Regards,

Michelle

 

Hi, MIchelle,

 

Thanks for u r fast rply. i am referred http://support.sas.com/resources/papers/proceedings14/SAS274-2014.pdf.

 

i am not understood that how to import SAS VA objects or sections or Entire Report  into Excel.

 

When i click on reports, The below image appears.

 

Untitled.png

 

 

 

I am totally struck.....

 

 

 

 

Thanks,

 

Teja Surapanen

 

Hi Teja,

 

From the screenshot you've provided you need to use the dialog to find where your VA reports are. If they are not in any of these folders then perhaps you are not connecting to the correct SAS server. It could be that you have another SAS server that communicates with SAS Visual Analytics and the reports are stored in a separate metadata repository.

 

Kind Regards,

Michelle

 

Hi MIchelle Thanks for Your Rply,

 

 

Then let me know how can i find another SAS Server in Excel?

 

 

 

 

 

Regards,

 

Teja Surapaneni.

 

Hi Teja,

 

I'd suggest talking to your SAS Administrator to see if there is another SAS Server and then he/she can set up the connection profile for you.

 

Kind Regards,

Michelle

 

Thanks Michelle,

 

 

I got the solutions, now i am connected to VA Server in Office Analytics.

 

 

Regards,

Teja Surapaneni.

 

Great to hear!

 

This document was generated from the following discussion:

Comments

For any reader who would like a "show me" demo of what this integration looks like, you can watch this SAS Tech Talk video about SAS Add-In for Microsoft Office and SAS Visual Analytics.

That video was very helpful. They go together well (all we need is memory Smiley Wink). Thanks Chris.

Version history
Last update:
‎10-05-2015 04:20 PM
Updated by:

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags