BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Quantopic
Obsidian | Level 7

Hello SAS users,

 

I need for exporting a SAS visual analytics Report into a MS Power Point file.

 

Anyone of you can provide some advices/hint in order to be able to do that?

 

Thanks all for the help!

1 ACCEPTED SOLUTION

Accepted Solutions
itchyeyeballs
Pyrite | Level 9

No problem,

 

Main points: 

 

  • End users don’t need specific versions of MS Office - Trying to get everyone in a large organsiation on the right version of Office (and associated service packs) in order to share Power BI content is a nightmare.
  • Reports are interactive - users with the SAS analytics plugin can filter and drill into reports. The MS functionality just produces static images in PowerPoint (and its still only a preview feature). MS have confirmed they have no plans to develop this either so users need to be linked across to the web reports.
  • Reports can easily be shared with users that don’t have the SAS analytics plugin
  • SAS is on prem, Power BI is still cloud only (as far as I'm aware) and you need a licence for every user that you want to share reports with.
  • Excel Power BI functionality is widely regarded to be extremely buggy at the moment, 2016 update made things worse. SAS plugin is more stable (although doesn't play nicely if you use it along side Power BI in Excel)

 

There are more but I stopped comparing once I got the SAS add in up and running as the points above are key for us. 

 

The one feature that I have found to be better in the MS offering is the ability to create a full data model in Power BI then link it directly to Excel, it means you can create a very complex model with lots of tables and measures and re-use across multiple Excel workbooks and PBI reports. SAS doesn’t do data models in VA at all.

 

View solution in original post

10 REPLIES 10
MichelleHomes
Meteorite | Level 14

You can only export a SAS Visual Analytics report to a .pdf file. However, if you have SAS Office Analytics licensed you can create Powerpoints from SAS Visual Analytics reports. Have a look at the following paper for information

http://support.sas.com/resources/papers/proceedings16/SAS3360-2016.pdf

 

Kind Regards,

Michelle

 

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

To second Michelles suggestion,

 

we use the Office Analytics to embed reports into MS Word and Powerpoint, its a really good tool and makes life much easier for report designers and end users, it's actually better than Microsofts own integreation between Power BI and Office.

 

I think there are two versions of the tool though so make sure you get the right one.

MichelleHomes
Meteorite | Level 14

Hi @itchyeyeballs,

 

I'm curious to your comment "it's actually better than Microsofts own integreation between Power BI and Office." Could you please expand on your experiences and why it is better?

 

Thanks,

Michelle

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

No problem,

 

Main points: 

 

  • End users don’t need specific versions of MS Office - Trying to get everyone in a large organsiation on the right version of Office (and associated service packs) in order to share Power BI content is a nightmare.
  • Reports are interactive - users with the SAS analytics plugin can filter and drill into reports. The MS functionality just produces static images in PowerPoint (and its still only a preview feature). MS have confirmed they have no plans to develop this either so users need to be linked across to the web reports.
  • Reports can easily be shared with users that don’t have the SAS analytics plugin
  • SAS is on prem, Power BI is still cloud only (as far as I'm aware) and you need a licence for every user that you want to share reports with.
  • Excel Power BI functionality is widely regarded to be extremely buggy at the moment, 2016 update made things worse. SAS plugin is more stable (although doesn't play nicely if you use it along side Power BI in Excel)

 

There are more but I stopped comparing once I got the SAS add in up and running as the points above are key for us. 

 

The one feature that I have found to be better in the MS offering is the ability to create a full data model in Power BI then link it directly to Excel, it means you can create a very complex model with lots of tables and measures and re-use across multiple Excel workbooks and PBI reports. SAS doesn’t do data models in VA at all.

 

Quantopic
Obsidian | Level 7

Hi guys,

 

thanks for the quick replies.

 

Could you suggest me how can I check whether I have or not the license for Office Analytics?

 

Thanks again!

itchyeyeballs
Pyrite | Level 9

Open Base SAS on the server and type

 

PROC SETINIT;
RUN ;

 

you should see something like

 

---SAS Add-in for Microsoft Excel
expiry date
---SAS Add-in for Microsoft Outlook
expiry date
---SAS Add-in for Microsoft PowerPoint
expiry date
---SAS Add-in for Microsoft Word

 

rsleslie
Fluorite | Level 6

When you say "reports are interactive", that's from the VA side.  Once you Insert Report (or Insert Selection) to PPT the VA report is static.  One can only change the PPT by opening the VA report.  Correct?

 

Do you know of a way to burst reports to PPT?  That is, I have one VA report with data for multiple clients.  I want to create a separate PPT deck foreach person showing their client's data only.

 

Scott

itchyeyeballs
Pyrite | Level 9

Reports have simiar level of interaction as the normal web viwer i.e. end users can filter & refresh data

 

Row level security on the underlying LASR tables may give you what you need in terms of personalising the reports, will depend on how your data is structured and exactly what you need to achieve, should be possible to have a single set of VA reports and 1 Powerpoint template though.

rsleslie
Fluorite | Level 6
Thanks. This is helpful

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!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 10 replies
  • 3876 views
  • 4 likes
  • 4 in conversation