1

We use SAS to manage our data, and we have a table that updates every day.

We use Google sheets to create a dashboard.

In this regard I would like to have Google Sheets access the table directly and import all the data, instead of me manually importing the data

Is there a way to do this?

KhalidN
  • 385
  • 1
  • 7
  • 13
  • How are you manually importing the data now? I didn't think google had the capability read to a SAS dataset. – Reeza Dec 02 '16 at 14:14

1 Answers1

1

Google sheets does not allow direct import of SAS datasets, according to this page:

https://support.google.com/docs/answer/40608?hl=en

However, you can run a SAS program as a batch job to export your SAS dataset to csv or one of the other supported formats, then I think you could use Google Apps Script to automate the rest of the import, as per this answer:

How to automatically import data from uploaded CSV or XLS file into Google Sheets

Community
  • 1
  • 1
user667489
  • 9,501
  • 2
  • 24
  • 35