BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
TejaSurapaneni
Lapis Lazuli | Level 10

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.

1 ACCEPTED SOLUTION

Accepted Solutions
MichelleHomes
Meteorite | Level 14

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

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

View solution in original post

8 REPLIES 8
MichelleHomes
Meteorite | Level 14

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

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
TejaSurapaneni
Lapis Lazuli | Level 10

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

MichelleHomes
Meteorite | Level 14

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

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
TejaSurapaneni
Lapis Lazuli | Level 10

Hi MIchelle Thanks for Your Rply,

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






Regards,


Teja Surapaneni.

MichelleHomes
Meteorite | Level 14

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

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
TejaSurapaneni
Lapis Lazuli | Level 10

Thanks Michelle,

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

Regards,

Teja Surapaneni.

MichelleHomes
Meteorite | Level 14

Great to hear!

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
vps
Fluorite | Level 6 vps
Fluorite | Level 6

Hi,

 

I am trying to connect SAS via VBA excel and get the result in Sheet. If you have achieved this. Can you help me with the code. I am not able to get this,

 

Cheers

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Discussion stats
  • 8 replies
  • 2315 views
  • 7 likes
  • 3 in conversation