topic Re: Export the whole report/page into one excel/pdf file in SAS Visual Analytics

Export the whole report/page into one excel/pdf file

filippo_kow — Wed, 27 Jul 2022 11:58:51 GMT

Hi guys,

I am new VA user and I have some basic question related to exporting the whole report into an excel of pdf file.

In my report I have drop-down list, listing table and multidimentional table. I know that I can export listing table or multidimentional table into excel file separately, but I would like to export both listing and multidimentional table into one single excel or pdf file (something like "export entire page to excel/pdf file"). Is it possible in SAS VA?

Thanks in advance!
Filip

Re: Export the whole report/page into one excel/pdf file

Madelyn_SAS — Wed, 27 Jul 2022 13:06:24 GMT

Which version are you using? Click the icon representing your ID in the upper right, select About to see the version.

Re: Export the whole report/page into one excel/pdf file

filippo_kow — Wed, 27 Jul 2022 13:29:20 GMT

Hi,

I am using version 8.5.1 (SAS Viya V.03.05).

Cheers,

Filip

Re: Export the whole report/page into one excel/pdf file

Madelyn_SAS — Wed, 27 Jul 2022 15:39:23 GMT

You can get a PDF by printing or by distributing the report. You cannot export an entire report in Excel format.

Re: Export the whole report/page into one excel/pdf file

MarkusWeick — Wed, 27 Jul 2022 15:43:41 GMT

Hi @filippo_kow,

for a first impression on how Visual Analytics and Excel work together, I recommend:

SAS Tutorial | Working with SAS Visual Analytics Reports in Microsoft Excel - YouTube

Best

Markus

Re: Export the whole report/page into one excel/pdf file

filippo_kow — Thu, 28 Jul 2022 07:44:53 GMT

Hi @Madelyn_SAS ,

Thanks for the info. Unfortunately currently option for distributing report is unavailable in my VA (I will check the permissions and so on), but I am a little bit confused about printing to PDF.

In my report I have quite wide table, and when I print it to PDF I have something like screen shot of current view, and not the entire table. Is it normal behaviour?

Thanks,

Filip

Re: Export the whole report/page into one excel/pdf file

filippo_kow — Thu, 28 Jul 2022 07:45:32 GMT

Hi @MarkusWeick ,

Thanks a lot, I will take a look at this video 🙂

Thanks,

Filip

Re: Export the whole report/page into one excel/pdf file

filippo_kow — Tue, 02 Aug 2022 14:14:13 GMT

Hi again,

Unfortunately I still didn't find a way how can I export the whole report into a pdf file (not a "screen shot", but with entire wide table) - any ideas? 🙂

Thanks in advance!
Filip