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

[Santt0sh]

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

[Tom]

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.

[ChrisNZ]

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

[Santt0sh]

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.

[Kurt_Bremser]

@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.

[Kurt_Bremser]

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