topic Re: Adding google sheets file as data set in SAS Programming

Adding google sheets file as data set

lvenner — Mon, 10 Jun 2019 17:56:26 GMT

Hi all, I am a student researcher using SAS for an epidemiological study. I have compiled data (ongoing) in a google sheets file (which is similar to excel) and am interested in attaching the google sheets file as my data set for my analyses. I'd like to do this so that as I add more data, it will be included in the analysis. Is this possible?

Thank you for your help!

Re: Adding google sheets file as data set

noling — Mon, 10 Jun 2019 18:32:51 GMT

This topic looks helpful - https://communities.sas.com/t5/SAS-Studio/Import-data-Google-SpreadSheet/td-p/350220

If you want to add more data over time you could either re-build your dataset with all your data (including new data), or Proc-Append on only the new data onto your existing dataset. You could schedule your loading job to run at fixed times. Lots of options.

Re: Adding google sheets file as data set

Reeza — Mon, 10 Jun 2019 18:50:05 GMT

Just a note that the HTTPS restriction on SAS UE was removed I think.