topic Re: How do I import files(.xlsx) files from Tableau in SAS Programming

How do I import files(.xlsx) files from Tableau

Santt0sh — Thu, 31 Mar 2022 20:50:58 GMT

Hi All,
I was trying to create summary of a report which is created on tableau in excel.
To get the excel im current downloading the file and then importing the excel file into SAs and after minor changes to the SAs code I am running a summary statistics using Proc summary and then create another report and share it.
I have never worked with Tableau, so wanted to know if I can read the excel file from Tableau and generate the required reports.
The tableau reports are stored at a Share point.

I tried accessing the files using filename statements but I keep getting a not found error.

Can anyone suggest if I need to add any connections into order to aceesss the share point.

Thank you

Re: How do I import files(.xlsx) files from Tableau

Tom — Fri, 01 Apr 2022 02:25:40 GMT

You have two separate problems.

1) Getting something (anything) out sharepoint.

2) Knowing whether the data in the Excel files generated by Tableau are readable.

To answer the second one try manually moving one of the Excel files to a place where SAS can access it and see whether PROC IMPORT or the XLSX libname engine can read the data out of it.

Re: How do I import files(.xlsx) files from Tableau

ChrisNZ — Fri, 01 Apr 2022 05:13:24 GMT

Many resources about accessing sharepoint from SAS, for example: https://support.sas.com/kb/42/054.html

Re: How do I import files(.xlsx) files from Tableau

Kurt_Bremser — Fri, 01 Apr 2022 06:52:49 GMT

Tableau can also export to csv, which is a much better transport medium than Excel files, by orders of magnitude.

Re: How do I import files(.xlsx) files from Tableau

Santt0sh — Fri, 01 Apr 2022 12:09:55 GMT

Hi Kurt,

Thank you for your quick response.
1. I would like to read anything or something from the shared point.
2. Currently I am manually downloading the file created by Tableau from Share Point and reading them into SAS by Proc Import and perform calculations and a generate report.

Kindly Suggest me on #1.

Re: How do I import files(.xlsx) files from Tableau

Kurt_Bremser — Fri, 01 Apr 2022 12:34:33 GMT

@ChrisNZ has given you an answer for #1.

For #2, csv files are to be preferred, as you can avoid PROC IMPORT and use a properly written DATA step instead.