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?
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: