Adding google sheets file as data set

[lvenner]

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! 

[noling]

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.

[Reeza]

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