topic Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option in SAS Visual Analytics

Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

naishj1 — Thu, 09 Nov 2017 13:16:48 GMT

Everybody in my organisation constantly bemoans the fact you can only export a table from Explore in CSV format and not Excel. Is there a reason for this shortcoming? Is there any way around this or am I going to be forever annoyed that I can only extract data in the most annoying format known to the human race?

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option goddam

RW9 — Thu, 09 Nov 2017 13:11:13 GMT

I believe you are mistaken, CSV is plain text, portable format excellent for using and sending data, and can be imported into Excel directly using the inbuilt CSV read engine in Excel. On the juxtaposition, Excel is a proprietary binary file format (yes, zip with XML, but still not plain text), is not portable, and is terrible as a data medium.

If you want to create reports - i.e. human readable reports, then use ods tagsets.excelxp and proc report - creates nice formatted output, which is generally useless for programming purposes. If you are transferring data then avoid Excel totally and use CSV/XML.

If you just want something simple then use proc export.

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

ChrisHemedinger — Thu, 09 Nov 2017 13:25:43 GMT

I moved this to the SAS Visual Analytics board because I think that's the context you're working in (with Explore). If I have that wrong, let me know -- product and version number you're using -- and I can adjust it. SAS VA experts may chime in here with their practices.

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

Reeza — Thu, 09 Nov 2017 16:14:16 GMT

@naishj1 wrote:

Everybody in my organisation constantly bemoans the fact you can only export a table from Explore in CSV format and not Excel. Is there a reason for this shortcoming? Is there any way around this or am I going to be forever annoyed that I can only extract data in the most annoying format known to the human race?

Excel is the most annoying format known to the human race!

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option bleep

naishj1 — Fri, 10 Nov 2017 07:53:11 GMT

Thank you for your response, I need something I can advise the various users within my organisation to use as I get a lot of grumbles. I will investigate your suggestions.

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

naishj1 — Fri, 10 Nov 2017 12:29:14 GMT

Hi Chris,
Thank you for your response, my end users and I are using explore. I think you may be right about the responses I will get otherwise. The end users/consumers I work with want simple non-technical solutions in a format they can use for day to day office work and the Excel format is preferred by almost all, generating a lot of grumbles within my organisation that get directed to my BI team.
Regards
Justin Naish

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

naishj1 — Fri, 10 Nov 2017 08:10:11 GMT

Maybe to you but not my finance and account teams who pretty much live in it. I prefer not to use CSV/Excel at all but I am fed up with the constant grumbles standard MS office users have.

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

JuanS_OCS — Fri, 10 Nov 2017 14:17:24 GMT

Hello @naishj1,

I believe you are working with the classic mode of SAS VA. Perhaps you would like to give a chance to the modern view, since it allows to Export to Excel format.

https://communities.sas.com/t5/SAS-Visual-Analytics/Export-to-MS-Excel-from-a-SAS-VA-report-Viewer-mode/td-p/267752

https://communities.sas.com/t5/SAS-Visual-Analytics/Export-to-Excel-in-SAS-Visual-Analytics-Modern-look-HTML5/td-p/242294

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option **blee

Madelyn_SAS — Fri, 10 Nov 2017 19:42:11 GMT

I think that the assumption is most end users who need to export data would be viewing the dashboard in a report (SAS Visual Analytics Viewer or Designer) and not in Explorer. An exploration is not usually the end product.

SAS Visual Analytics Viewer and Designer do support exporting to Excel. However, note that modern (HTML5) viewer supports exporting beginning with 7.4, and not in 7.3

They could export their explorations as reports and gain access to Excel export in that way.

topic Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option in SAS Visual Analytics

Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option goddam

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option **bleep**

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option **blee

Re: Why oh why can you only export a table to CSV in Explore? Give an export to Excel option bleep