Connect to private Google Drive Sheet

blaubner — Fri, 10 Jun 2022 01:02:55 GMT

Evening,

Is it possible to retrieve a google sheet from a private Google Drive using SAS? I found this discussion from a long time ago, but this example is using a google document URL that is public.

https://blogs.sas.com/content/sasdummy/2012/12/18/using-sas-to-access-data-stored-on-dropbox/

The data that I would like to retrieve is private and requires a username.

I was just introduced to a solution for R, so I'm wondering if SAS has a solution. The goal is to directly connect to the private Google Drive Sheet and bring the data into the SAS work folder.

Is this possible?

Re: Connect to private Google Drive Sheet

Reeza — Fri, 10 Jun 2022 01:18:10 GMT

I suspect so but don't have time to develop a solution.

You'll likely need to use the Google Sheets API REST interface and PROC HTTP.

SAS & REST API

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4426-2020.pdf

Google Sheets API

https://developers.google.com/sheets/api/reference/rest

topic Re: Connect to private Google Drive Sheet in SAS Programming

Connect to private Google Drive Sheet

Re: Connect to private Google Drive Sheet