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!
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.
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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: